Back to results
US 11,308,070 B2Granted
Database change capture with transaction-consistent order
AssigneeSap SE
InventorsJuchang Lee, Chang Gyoo Park, Hyoung Jun Na
Life of this patent
Estimating the term…
Abstract
Techniques are described for use in database and data management systems to efficiently capture and replicate changes that occur in database tables. The changes are captured in a transaction-consistent order, and in a format that may easily be searched and accessed using common relational queries.
Claims20
A computer program product, the computer program product being tangibly embodied on a non-transitory computer-readable storage medium and comprising instructions that, when executed, are configured to cause at least one computing device to:
- detect a first database change operation of a first transaction of the transactions, the first database change operation writing first record data to a source table of a database instance using a record buffer that temporarily stores the first record data during the first database change operation;
- extract the first record data from the record buffer;
- generate, using the extracted first record data, a first replication log entry that includes first metadata characterizing the first record data, including a corresponding first transaction commit identifier (CID) for the first transaction;
- and
- store the first replication log entry within a replication log table storing a change history of transactions for the source table.
2 more elements
A computer-implemented method, comprising:
- detecting a first database change operation of a first transaction of the transactions, the first database change operation writing first record data to a source table of a database instance using a record buffer that temporarily stores the first record data during the first database change operation;
- extracting the first record data from the record buffer;
- generating, using the extracted first record data, a first replication log entry that includes first metadata characterizing the first record data, including a corresponding first transaction commit identifier (CID) for the first transaction;
- and
- storing the first replication log entry within a replication log table storing a change history of transactions for the source table.
2 more elements
A system comprising:
- at least one processor;
- and
- a memory communicatively coupled to the at least one processor, the memory storing instructions which, when executed, cause the at least one processor to perform operations comprising:
- detecting a first database change operation of a first transaction of the transactions, the first database change operation writing first record data to a source table of a database instance using a record buffer that temporarily stores the first record data during the first database change operation;
- extracting the first record data from the record buffer;
- generating, using the extracted first record data, a first replication log entry that includes first metadata characterizing the first record data, including a corresponding first transaction commit identifier (CID) for the first transaction;
- and
- storing the first replication log entry within a replication log table storing a change history of transactions for the source table.
5 more elements
Dependencies are inferred from the claim text.