07580971 is referenced by 136 patents and cites 30 patents.

A method and apparatus for efficiently processing data requests in a network oriented n-tier database environment is presented. According to one embodiment of the invention, certain or all data from the tables of a database server device can be maintained in tables on the client device in a client side database cache server system. This local cache allows the network oriented n-tier database system to eliminate the expense of repetitive network transmissions to respond to duplicate queries for the same information. Additionally, the local client device may also keep track of what data is cached on peer network nodes. This allows the client to request that data from a peer database cache server and off load that burden from the database server device. Moreover, the local client may also keep statistics regarding the frequency of requested data in order to optimize the data set maintained in the local database cache server.

Title
Method and apparatus for efficient SQL processing in an n-tier architecture
Application Number
9/953490
Publication Number
7580971 (B1)
Application Date
September 10, 2001
Publication Date
August 25, 2009
Inventor
Debashish Chatterjee
Fremont
CA, US
Lakshminarayanan Chidambaran
Fremont
CA, US
Anindo Roy
Fremont
CA, US
Debashis Saha
Menlo Park
CA, US
Sreenivas Gollapudi
Fremont
CA, US
Agent
Vista IP Law Group
Assignee
Oracle International Corporation
CA, US
IPC
G06F 15/16
View Original Source