公开(公告)号：US20240168954A1

公开(公告)日：2024-05-23

申请号：US18426114

申请日：2024-01-29

Applicant: SAP SE

Inventor： Ruediger Karl ,  Mihnea Andrei ,  Juchang Lee ,  Stefan Baeuerle ,  Seyeong Bae ,  Joo Yeon Lee

IPC: G06F16/2455 ,  G06F16/23

CPC classification number: G06F16/24562 ,  G06F16/2379 ,  G06F16/24552

Abstract: Techniques and solutions are described for implementing virtual table schemas. A virtual table schema includes a logical pointer that is used to target a table that includes data and is defined according to the virtual table schema. Values assigned to the logical pointer can be used to target tables at different locations, such as in-memory storage or in dynamic storage of a database management system. The dynamic storage includes an in-memory buffer cache and persistent storage. The logical pointer can be updated to point to the in-memory storage or the dynamic storage, including based on use statistics. Similarly, a table having data for the virtual table can be transitioned between the in-memory buffer cache and the persistent storage, including based on use statistics for the virtual table. A value for the logical pointer can be updated when the table is transferred between the in-memory buffer cache and the dynamic storage.

公开(公告)号：US20230113142A1

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

申请号：US18065187

申请日：2022-12-13

Applicant: SAP SE

Inventor： Franz Faerber ,  Juchang Lee ,  Ivan Schreter

IPC: G06F16/2455 ,  G06F16/24 ,  G06F16/21 ,  G06F16/22

Abstract: A system and method of query processing in a multi-level storage system having a unified table architecture. A query is received by a common query execution engine connected with the unified table architecture, the query specifying a data record. The common query execution engine performs a look-up for the data record based on the query at the first level storage structure. If the data record is not present at the first level storage structure, the common query execution engine performs separate look-ups in each of the second level storage structure and the main store.

公开(公告)号：US11599543B2

公开(公告)日：2023-03-07

申请号：US17826060

申请日：2022-05-26

Applicant: SAP SE

Inventor： Jaeyoung Choi ,  Deok Hoe Kim ,  Kyu Hwan Kim ,  Chae Kwang Lee ,  Jane Jung Lee ,  Juchang Lee

IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/248 ,  G06F16/2453

Abstract: Technologies are described for routing structured query language (SQL) statements to elastic compute nodes (ECNs) using workload classes within a distributed database environment. The elastic compute nodes do not store persistent database tables. For example, a SQL statement can be received for execution within the distributed database environment. A workload class can be identified that matches properties of the SQL statement. Based on the workload class, a routing location hint can be obtained that identifies a set of elastic compute nodes. The SQL statement can then be routed to one of the identified elastic compute nodes for execution. Execution of the SQL statement at the elastic compute node can involve retrieving database data from other nodes which store persistent database tables.

公开(公告)号：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.

公开(公告)号：US20210224280A1

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

申请号：US17220556

申请日：2021-04-01

Applicant: SAP SE

Inventor： Franz Faerber ,  Juchang Lee ,  Ivan Schreter

IPC: G06F16/2455 ,  G06F16/24 ,  G06F16/21 ,  G06F16/22

Abstract: A system and method of query processing in a multi-level storage system having a unified table architecture. A query is received by a common query execution engine connected with the unified table architecture, the query specifying a data record. The common query execution engine performs a look-up for the data record based on the query at the first level storage structure. If the data record is not present at the first level storage structure, the common query execution engine performs separate look-ups in each of the second level storage structure and the main store.

公开(公告)号：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.

公开(公告)号：US11036540B2

公开(公告)日：2021-06-15

申请号：US16223888

申请日：2018-12-18

Applicant: SAP SE

Inventor： Kyu Hwan Kim ,  Juchang Lee

IPC: G06F9/46 ,  G06F16/22 ,  G06F16/23 ,  G06F3/06

Abstract: Innovations in the area of server-side processing when committing transactions to disk in a distributed database system can improve computational efficiency at database nodes and/or reduce network bandwidth utilization. For example, when transactions are committed in a database system, at a master node of the database system, a server uses different threads for certain processor-intensive operations and certain I/O-intensive operations. Or, as another example, when transactions are committed in a database system, at a master node of the database system, a server groups jobs for I/O requests.

公开(公告)号：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.