Method and apparatus for efficient SQL processing in an n-tier architecture
US7580971B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Sep 10, 2001 |
| Grant date | Aug 25, 2009 |
| Priority date | — |
| Expiry date | Jan 7, 2023 |
Classification
- Technology area (CPC H)Electricity
- CPC primaryH04L67/1097
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.