System, Method And Computer Program Product For Managing Caches

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.

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.