System, Method And Computer Program Product For Managing Caches
First Claim
1. A method for managing at least one cache for a database, the method comprising:
- inserting an operation record in an operations log for each write operation to the database, wherein the operation record comprises a Log Sequence Number (LSN); and
updating at least one cache, wherein updating a cache comprises;
identifying unapplied operations in the operations log for the cache using an applied LSN associated with the cache, wherein the applied LSN denotes an LSN of a last operation applied to the cache;
applying the unapplied operations to the cache; and
updating the applied LSN with an LSN corresponding to a last unapplied operation of the unapplied operations that were applied to the cache during updating the cache.
9 Assignments
0 Petitions
Accused Products
Abstract
Methods, systems and computer program products are provided for managing at least one cache for a database. In one method, an operation record is inserted in an operations log for each write operation to the database. The operation record includes a Log Sequence Number (LSN). At least one cache is updated using operation records in the operations log. To update a cache, unapplied operations in the operations log for the cache are identified using an applied LSN associated with the cache. The applied LSN denotes an LSN of a last operation applied to the cache. The unapplied operations are then applied to the cache and the applied LSN is updated with an LSN corresponding to the last unapplied operation of the unapplied operations that were applied to the cache during updating the cache.
-
Citations
29 Claims
-
1. A method for managing at least one cache for a database, the method comprising:
-
inserting an operation record in an operations log for each write operation to the database, wherein the operation record comprises a Log Sequence Number (LSN); and updating at least one cache, wherein updating a cache comprises; identifying unapplied operations in the operations log for the cache using an applied LSN associated with the cache, wherein the applied LSN denotes an LSN of a last operation applied to the cache; applying the unapplied operations to the cache; and updating the applied LSN with an LSN corresponding to a last unapplied operation of the unapplied operations that were applied to the cache during updating the cache. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A system for managing at least one cache for a cache, the system comprising:
-
an insertion module configured to insert an operation record in an operations log for each write operation to the database, wherein the operation record comprises a Log Sequence Number (LSN); and an update module, coupled to at least one cache, configured to; identify unapplied operations in the operations log for each cache using an applied LSN associated with the cache, wherein the applied LSN denotes an LSN of a last operation applied to the cache; apply the unapplied operations to the cache; and update the applied LSN with an LSN of a last operation in the unapplied operations list of the unapplied operations that were applied to the cache during updating the cache. - View Dependent Claims (14, 15, 16, 17, 18)
-
-
19. A computer-readable storage medium encoded with computer-executable instructions for managing at least one cache for a database, the computer- executable instructions, when executed, operable to cause one or more processors to:
-
insert an operation record in an operations log for each write operation to the database, wherein the operation record comprises a Log Sequence Number (LSN); and update at least one cache, wherein the computer program product further comprises computer executable instructions operable to cause the one or more processors to; identify unapplied operations in the operations log for a cache using an applied LSN associated with the cache, wherein the applied LSN denotes an LSN of a last operation applied to the cache; apply the unapplied operations to the cache; and update the applied LSN with an LSN corresponding to a last unapplied operation of the unapplied operations that were applied to the cache during updating the cache. - View Dependent Claims (20, 21, 22, 23, 24, 25, 26, 27, 28, 29)
-
Specification