公开(公告)号：US20200320098A1

公开(公告)日：2020-10-08

申请号：US16373725

申请日：2019-04-03

Applicant: SAP SE

Inventor： Priya SHARMA ,  Mahendra Chavan ,  Kunj Kothari

IPC: G06F16/27 ,  G06F16/22 ,  G06F16/28 ,  G06F16/23

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a lock-free parallel log replay and synchronization scheme to support asynchronous table replication. By synchronizing a replica table with the server-side data and conducting subsequent updates using transaction logs via a replayer, locking of tables may be avoided. A consistent transactional state may be maintained by employing a replayer to mark the table as enabled instead of a synchronizer. The replayer may also deduce transitive closures among transactions and replay the transactions in parallel based on the deduced transitive closures to optimize playback. These techniques provide enhanced data availability and minimize database blocking and deadlocking while improving query performance.

公开(公告)号：US11182405B2

公开(公告)日：2021-11-23

申请号：US16373725

申请日：2019-04-03

Applicant: SAP SE

Inventor： Priya Sharma ,  Mahendra Chavan ,  Kunj Kothari

IPC: G06F16/27 ,  G06F16/23 ,  G06F16/28 ,  G06F16/22

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a lock-free parallel log replay and synchronization scheme to support asynchronous table replication. By synchronizing a replica table with the server-side data and conducting subsequent updates using transaction logs via a replayer, locking of tables may be avoided. A consistent transactional state may be maintained by employing a replayer to mark the table as enabled instead of a synchronizer. The replayer may also deduce transitive closures among transactions and replay the transactions in parallel based on the deduced transitive closures to optimize playback. These techniques provide enhanced data availability and minimize database blocking and deadlocking while improving query performance.