Patent ID: 8712961

Claim:
A system comprising: one or more processors; one or more non-transitory memories for storing program instructions executable upon the one or more processors; a query router, comprising at least a portion of the program instructions, within a database system and configured to route a database request to a database or a cache, 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; a caching handler within the database system, comprising at least a portion of the program instructions, able to manage the synchronization state of tables replicated within the cache; a pending statements table listing all cache tables and transactions written to the cache tables; and a replication manager within the database system, comprising at least a portion of the program instructions, configured to asynchronously replicate a database table to a cache via metadata logging.