Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-08-08
2006-08-08
Corrielus, Jean M. (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07089228
ABSTRACT:
A query processor caches data retrieved from executing prepared statements, and uses the cached data for subsequent accesses to the data, if certain conditions for using the cached data are met. The preferred embodiments also include a data staleness handler that takes care of issues that arise from data that may have changed in the database but is not reflected in the cache. One way to handle data staleness in the cache is to specifically enable or disable caching in a query. If caching is disabled, the query processor will access the data in the database. Another way to handle data staleness in the cache is to provide a timer that causes the cache to be invalidated when the timer times out. Yet another way to handle data staleness in the cache is to provide specified conditions that must be met for caching to occur, such as time or date limitations. Still another way to handle data staleness in the cache is to provide an update trigger for the data in the database that corresponds to the cached data. When the data in the database is updated, the update trigger fires, causing the cache to be invalidated. Note that invalidating the cache could also be followed by automatically updating the cache. By caching the results of processing a prepared statement, other queries that use the same prepared statement may be able to access data in the cache instead of going to the database.
REFERENCES:
patent: 6578113 (2003-06-01), Krishnamurthy et al.
patent: 6826557 (2004-11-01), Carter et al.
patent: 6941310 (2005-09-01), Ahad et al.
patent: 2002/0143855 (2002-10-01), Traversat et al.
Chutney Technologies Extends Its Dynamic Content Acceleration Leadership with Enhanced Enterprise-Class Functionality, PR Newswire, May 8, 2001.
Arnold Jeremy Alan
Barsness Eric Lawrence
Dettinger Richard Dean
Santosuosso John Matthew
Corrielus Jean M.
International Business Machines - Corporation
Martin Derek P.
Martin & Associates LLC
LandOfFree
Computer apparatus and method for caching results of a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Computer apparatus and method for caching results of a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Computer apparatus and method for caching results of a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3696843