Invention Grant
- Patent Title: Real-time cross-system database replication for hybrid-cloud elastic scaling and high-performance data virtualization
-
Application No.: US16686827Application Date: 2019-11-18
-
Publication No.: US11263236B2Publication Date: 2022-03-01
- Inventor: Juchang Lee , Seoyoon Choi , Eunsang Kim , Kyu Hwan Kim , Joo Yeon Lee , Hyoung Jun Na
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Buckley, Maschoff & Talwalkar LLC
- Main IPC: G06F16/27
- IPC: G06F16/27 ; G06F16/23 ; G06F16/22

Abstract:
RTR of a database transaction to a replica table may include receiving replication and transaction commit log entries (representing a database transaction). The replication log entry has a row-ID value, and the row at the replica table has a row-ID value. The replication log entry may be dispatched to a parallel log replayer and the associated transaction commit log entry to a transaction commit log replayer. The row-ID values may be compared, and the replication log entry is replayed at the parallel log replayer based on the comparison. The database transaction may then be committed to the replica table by replaying the associated transaction commit log entry at the transaction log replayer, wherein the database transaction is associated with row-level parallel replay having transactional consistency and DDL replication and reconstruction of a DDL statement at the replica system is associated with one or multiple metadata update log entries.
Public/Granted literature
Information query