-
公开(公告)号:US20220215011A1
公开(公告)日:2022-07-07
申请号:US17701185
申请日:2022-03-22
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Hyoung Jun Na
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.
-
公开(公告)号:US11341112B2
公开(公告)日:2022-05-24
申请号:US16918057
申请日:2020-07-01
Applicant: SAP SE
Inventor: Chang Gyoo Park
IPC: G06F16/23 , G06F16/22 , G06F16/2455
Abstract: Lock table management is provided for a lock manager of a database system, in which lock management is provided in a manner that is fast and efficient, and that conserves processing, memory, and other computational resources. For example, the lock table management can use a hashmap in which keys and values are stored in separate arrays, which can be loaded into separate CPU cache lines.
-
公开(公告)号:US11200221B2
公开(公告)日:2021-12-14
申请号:US16576498
申请日:2019-09-19
Applicant: SAP SE
Inventor: Kyu Hwan Kim , Juchang Lee , Beomsoo Kim , Chang Gyoo Park , Reiner Singer , Christoph Roterring , Werner Thesing , Michael Muehle
IPC: G06F16/00 , G06F16/23 , G06F16/245 , G06F16/27
Abstract: A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US11003689B2
公开(公告)日:2021-05-11
申请号:US16351001
申请日:2019-03-12
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Kyu Hwan Kim , Deok Koo Kim
Abstract: Technologies are described for facilitating transaction processing within a database environment having a coordinator node, a first worker node, and at least a second worker node. The first worker node sends a request from to the coordinator node for at least a first synchronization token maintained by the coordinator node. The first worker node receives the at least a first synchronization token from the coordinator node. The first worker node assigns the at least a first synchronization token to a snapshot as a snapshot ID value. The snapshot is executed at the first worker node. The first worker node forwards the snapshot ID value to the at least a second worker node.
-
公开(公告)号:US10997161B2
公开(公告)日:2021-05-04
申请号:US16386776
申请日:2019-04-17
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Hyejeong Lee
Abstract: Technologies are provided for reducing or eliminating transaction consistency anomalies that can occur during data replication, such as during database table replication. For example, commit values can be used to coordinate requests so that the requests are not performed on database tables with inconsistent data.
-
公开(公告)号:US10572510B2
公开(公告)日:2020-02-25
申请号:US14977372
申请日:2015-12-21
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Deok Koo Kim
IPC: G06F16/27 , G06F16/951 , G06F16/23 , G06F1/14 , H04L29/08
Abstract: Technologies are described for facilitating transaction processing within a database environment having a coordinator node, a first worker node, and at least a second worker node. The coordinator node receives local transaction tokens from the first and the at least a second worker nodes. The coordinator nodes determines a synchronized transaction token using at least the local transaction tokens from the first and the at least a second worker nodes. The coordinator node sends the synchronized transaction token to the first and the at least a second worker nodes.
-
公开(公告)号:US20200034373A1
公开(公告)日:2020-01-30
申请号:US16595505
申请日:2019-10-08
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Deok Koo Kim
IPC: G06F16/27 , G06F16/951 , G06F16/23 , G06F1/14 , H04L29/08
Abstract: Technologies are described for facilitating transaction processing within a database environment having a coordinator node, a first worker node, and at least a second worker node. The coordinator node receives local transaction tokens from the first and the at least a second worker nodes. The coordinator nodes determines a synchronized transaction token using at least the local transaction tokens from the first and the at least a second worker nodes. The coordinator node sends the synchronized transaction token to the first and the at least a second worker nodes.
-
公开(公告)号:US20200012633A1
公开(公告)日:2020-01-09
申请号:US16576498
申请日:2019-09-19
Applicant: SAP SE
Inventor: Kyu Hwan Kim , Juchang Lee , Beomsoo Kim , Chang Gyoo Park , Reiner Singer , Christoph Roterring , Werner Thesing , Michael Muehle
IPC: G06F16/23 , G06F16/245
Abstract: A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US10298702B2
公开(公告)日:2019-05-21
申请号:US15202366
申请日:2016-07-05
Applicant: SAP SE
Inventor: Chang Gyoo Park , Juchang Lee , Kyu Hwan Kim , Chul Won Lee , Myunggon Park , Eunjin Song , Nosub Sung
IPC: H04L29/06 , H04L29/08 , G06F16/20 , G06F16/2455 , H04L12/747
Abstract: Technologies are described for facilitating replay of requests for database operations. A plurality of requests for database operations are received. Each of the plurality of requests includes a type, an access unit identifier, and a chronological identifier. Execution dependencies are determined between the plurality of requests based on the type, access unit identifier, and chronological identifier of each of the plurality of requests. The execution dependencies are stored.
-
公开(公告)号:US10268743B2
公开(公告)日:2019-04-23
申请号:US14866449
申请日:2015-09-25
Applicant: SAP SE
Inventor: Juchang Lee , Chang Gyoo Park , Kyu Hwan Kim , Deok Koo Kim
IPC: G06F17/30
Abstract: Technologies are described for facilitating transaction processing within a database environment having a coordinator node, a first worker node, and at least a second worker node. The first worker node sends a request from to the coordinator node for at least a first synchronization token maintained by the coordinator node. The first worker node receives the at least a first synchronization token from the coordinator node. The first worker node assigns the at least a first synchronization token to a snapshot as a snapshot ID value. The snapshot is executed at the first worker node. The first worker node forwards the snapshot ID value to the at least a second worker node.
-
-
-
-
-
-
-
-
-