System and method for reliable caching of database connections in a distributed application
US6434543B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 1, 1999 |
| Grant date | Aug 13, 2002 |
| Priority date | — |
| Expiry date | Nov 1, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99944
- WIPO fieldDigital communication
- WIPO sectorElectrical engineering
Abstract
Connection information for open database connections is stored or “cached” in a connection manager at the database client. Therefore, even when a query is complete and the connection between the client and server is released, the manager maintains the database connection open. When a new query arrives at the client, the connection manager compares the connection information in the query to the corresponding information stored for each open connection. If there is a match and the connection is not in use, the already open connection is used for the new query. If there is no match, a new connection is opened until a predetermined limit of the number of connections is reached. When the limit is reached, an open connection which is not in use is closed and a new connection is established. In accordance with a preferred embodiment, a “free” list of open connections which are not in use is maintained so that a quick comparison can be made with the incoming query information.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.