Invention Grant
- Patent Title: Measuring snapshot delay between source database and its asynchronous replica
-
Application No.: US16704727Application Date: 2019-12-05
-
Publication No.: US11379323B2Publication Date: 2022-07-05
- Inventor: Kyu Hwan Kim , Deok Hoe Kim , Beomsoo Kim , Juchang Lee , Werner Thesing , Christoph Roterring
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Klarquist Sparkman, LLP
- Main IPC: G06F11/00
- IPC: G06F11/00 ; G06F11/14 ; G06F16/23 ; G06F16/27 ; G06F11/20 ; G06F11/30 ; G06F11/07

Abstract:
A computer implemented method is provided for determining a delay between a first database and an associated replicated database by replicating transactions of the first database in the replicated database, determining a delay between the two databases based on a commit timestamp from the first database and a timestamp associated with the commit transaction becoming visible in the replicated database. Then, after a predefined period of time has elapsed since replicating the commit transaction, determining a second delay based on a timestamp associated with a heartbeat log and a replicated database system time. And, selectively determining to execute or deny a statement received by the replicated database based on the second delay. Related apparatus, systems, techniques and articles are also described.
Public/Granted literature
- US1779222A Distillation of crude oils Public/Granted day:1930-10-21
Information query