Patent ID: 7818292

Claim:
A system comprising: a memory; a database stored at the memory; and a processor coupled to the memory, the processor configured to: execute instructions retrieved from the memory that cause execution of a data change tracking layer configured to separate change tracking and change enumeration at the database and configured to maintain one or more table synchronization bookmarks associated with the database; execute instructions retrieved from the memory that cause execution of a transaction identifier configured to detect a transaction at the database and to create an entry corresponding to the transaction at each of the one or more table synchronization bookmarks; and update a single row of an index associated with a single data table of the database when the transaction is a multi-row transaction, wherein the multi-row transaction corresponds to database operations at the single data table of the database, wherein the multi-row transaction comprises at least one of inserting N rows into the single data table, deleting N rows from the single data table, and updating N rows at the single data table, wherein N comprises an integer greater than one; wherein the data change tracking layer comprises a transaction begin counter that monotonically increases to uniquely identify transactions at the database and wherein the transaction begin counter is incremented by one to uniquely identify the multi-row transaction.