Patent ID: 8548945
Filing Date: 2013-10-01
Classification: G06F

Abstract:
1. A method comprising: identifying a database table within a database to persist within a cache as a cached table, wherein the database is at least one of a relational database management system (RDBMS) and an object oriented database management system (OODBMS), wherein the cache is a database cache; logging a plurality of database transactions within a log table and flagging the cached table within the cache as not cached during runtime; responsive to a commit action, inserting a checkpoint entry into a checkpoints table, wherein the checkpoint entry is at least one of a transaction identifier and a transaction completed directive; performing an asynchronous replication of the database table to the cached table, wherein the replication executes the plurality of database transactions within the log table upon the cached table; and when the replication is completed, flagging the cached table as cached; and updating a pending statement table with the database table name and the transaction identifier of a query statement writing to the database table.