Systems and methods for query caching
US8019735B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Oct 14, 2004 |
| Grant date | Sep 13, 2011 |
| Priority date | — |
| Expiry date | Apr 22, 2026 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24552
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A query caching system and method for enabling the caching of software object instances at the granularity of query level. A query component in a container can issue a query to retrieve a query result from a database within a scope of a transaction. The query result includes one or more instances of a class that represents one or more persisted data entries retrieved from the database. A cache management component retrieves the query result for the query in the cache when a query registration component finds out that another query matches the query in the query registry. If the class is expected to remain unchanged within the transaction, the class can be configured to be used concurrently by multiple users, using an optimistic concurrency strategy. The cached query result can be invalidated during the transaction, when any row in any table in the database associated with the cached query result, or a range of any data entry of the one or more persisted data entries in the query is updated or invalidated.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.