公开(公告)号：US20180150496A1

公开(公告)日：2018-05-31

申请号：US15361760

申请日：2016-11-28

Applicant: SAP SE

Inventor： Kyu Hwan Kim ,  Juchang Lee ,  Beomsoo Kim ,  Chang Gyoo Park ,  Reiner Singer ,  Christoph Rottering ,  Werner Thesing ,  Michael Muehle

IPC: G06F17/30

CPC classification number: G06F16/2322 ,  G06F16/2365 ,  G06F16/2379 ,  G06F16/2386 ,  G06F16/245 ,  G06F16/27 ,  G06F16/273

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.

公开(公告)号：US20170177698A1

公开(公告)日：2017-06-22

申请号：US14977427

申请日：2015-12-21

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park ,  Kyu Hwan Kim

IPC: G06F17/30

CPC classification number: G06F17/30581 ,  G06F17/30351 ,  G06F17/30477

Abstract: Technologies are described for facilitating transaction processing within a database environment having first, second, and third database system nodes. In the database system, the first database system node receives from the second database system node a request to precommit a first database transaction. The first database system node stores information for the first database transaction that includes an indication that the second database system node coordinates the committing of the first database transaction. The first database system node receives from the third database system node a request to precommit a second database transaction. The first database system node stores information for the second database transaction that includes an indication that the third database system node coordinates the committing of the second database transaction.

公开(公告)号：US20170177697A1

公开(公告)日：2017-06-22

申请号：US14977372

申请日：2015-12-21

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park ,  Deok Koo Kim

IPC: G06F17/30 ,  H04L29/08

CPC classification number: G06F16/275 ,  G06F1/14 ,  G06F16/2322 ,  G06F16/2365 ,  G06F16/951 ,  H04L67/10

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.

公开(公告)号：US20170177658A1

公开(公告)日：2017-06-22

申请号：US14975365

申请日：2015-12-18

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park ,  Kyu Hwan Kim ,  Hyoung Jun Na ,  Deok Koo Kim ,  Joo Yeon Lee

IPC: G06F17/30 ,  G06F11/14

Abstract: Technologies are described for performing replication of data within a database environment having a source node and a replica node. The source node executes a database operation on at least one database table stored by the source node. The source node asynchronously sends the database operation to the replica node. A prepare commit request is synchronously sent from the source node to the replica node. The source node receives a synchronous precommit acknowledgement from the replica node. The precommit acknowledgement indicates that the database operation was executed at the replica node. The source node commits a transaction associated with the database operation.

公开(公告)号：US11372890B2

公开(公告)日：2022-06-28

申请号：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 ,  H04L67/10

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.

公开(公告)号：US11308070B2

公开(公告)日：2022-04-19

申请号：US16851227

申请日：2020-04-17

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park ,  Hyoung Jun Na

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

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.

公开(公告)号：US11080271B2

公开(公告)日：2021-08-03

申请号：US15261582

申请日：2016-09-09

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park ,  Francis Gropengiesser ,  Anil Kumar Goel ,  Deok Koo Kim ,  SunHo Lee

IPC: G06F16/23 ,  G06F9/46

Abstract: A transaction management service layer monitors a plurality of read and write transactions being executed by the data engines by way of client libraries at each of a plurality of data engines. In addition, the transaction management server layer maintains and coordinates transaction timestamp and sequence numbers that are shared by the plurality of data engines. The transaction management service layer identifies and resolves conflicts among the plurality of transactions. The transaction management service layer is a separate and independent service that is isolated from other components of the plurality of data engines. Related apparatus, systems, techniques and articles are also described.

公开(公告)号：US20210209092A1

公开(公告)日：2021-07-08

申请号：US17150868

申请日：2021-01-15

Applicant: SAP SE

Inventor： Juchang Lee ,  Deok Koo Kim ,  Chang Gyoo Park ,  Nosub Sung

IPC: G06F16/23 ,  G06F16/28

Abstract: Technologies are described for facilitating transaction processing in a distributed database environment. A database client sends database operations to a slave node, which mediates execution of the transaction. A connection between the database client and the slave node is associated with an identifier, and the transaction has an identifier. The database client sends a commit request to a master node over a network connection between the master node and the database client. The commit request includes the transaction identifier. The commit request can also include an indication of database nodes executing operations in the transaction.

公开(公告)号：US10990585B2

公开(公告)日：2021-04-27

申请号：US15976441

申请日：2018-05-10

Applicant: SAP SE

Inventor： Chang Gyoo Park ,  Juchang Lee

IPC: G06F16/23

Abstract: Techniques are described for use in database and data management systems to enable a database transaction to read uncommitted data from another database transaction on a selective (e.g., transaction-specific) basis, without requiring a change in the isolation level of either transaction (or related transactions). Accordingly, transaction speeds may be increased, and operations to audit or debug ongoing database transactions are also facilitated.

公开(公告)号：US10977227B2

公开(公告)日：2021-04-13

申请号：US15615196

申请日：2017-06-06

Applicant: SAP SE

Inventor： Juchang Lee ,  Chang Gyoo Park

IPC: G06F16/00 ,  G06F16/21 ,  G06F11/14 ,  G06F16/27 ,  G06F11/20 ,  G06F16/185

Abstract: Technologies are described for facilitating the processing of requests for database operations in a distributed database environment. Criteria are defined for processing a request for a database operation according to first or second snapshot isolation protocols. A request for a database operation is received and it is determined if the snapshot isolation protocol criteria are met. If the criteria are met, the request can be processed using a local snapshot identifier value of a worker node. If the criteria are not met, the local snapshot identifier value is synchronized with another node, and the request processed using the updated snapshot identifier value.