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

公开(公告)号：US10824611B2

公开(公告)日：2020-11-03

申请号：US16027897

申请日：2018-07-05

Applicant: SAP SE

Inventor： Juchang Lee ,  KiYong Lee ,  Nosub Sung

IPC: G06F16/20 ,  G06F16/22 ,  G06F16/27 ,  G06F16/23 ,  G06F16/2455

Abstract: Improvements to the performance of distributed database systems are described. Suggested table distributions are provided that can reduce the performance overhead associated with database operations that involve multiple nodes, and can provide more even distribution of computing resource use. A method includes minimizing a cost function that includes a plurality of performance metrics, at least a portion of the metrics being associated with a weight. Candidate table distributions can be analyzed in an iterative manner to determine a lowest-cost distribution. A final table distribution can be output, such as to a user.

公开(公告)号：US10554771B2

公开(公告)日：2020-02-04

申请号：US16362286

申请日：2019-03-22

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.

公开(公告)号：US20200012734A1

公开(公告)日：2020-01-09

申请号：US16027897

申请日：2018-07-05

Applicant: SAP SE

Inventor： Juchang Lee ,  KiYong Lee ,  Nosub Sung

IPC: G06F17/30

Abstract: Technologies are described for improving the performance of distributed database systems. The technologies provide suggested table distributions that can reduce the performance overhead associated with database operations that involve multiple nodes, and can provide more even distribution of computing resource use. In a particular example, a method includes minimizing a scoring function that includes a plurality of performance metrics, at least a portion of the metrics being associated with a weight. Candidate table distributions can be analyzed in an iterative manner to determine a lowest-score distribution. A final table distribution can be output, such as to a user.

公开(公告)号：US11429584B2

公开(公告)日：2022-08-30

申请号：US17037484

申请日：2020-09-29

Applicant: SAP SE

Inventor： Juchang Lee ,  KiYong Lee ,  Nosub Sung

IPC: G06F16/20 ,  G06F16/22 ,  G06F16/27 ,  G06F16/23 ,  G06F16/2455

Abstract: Technologies are described for improving the performance of distributed database systems. The technologies provide suggested table distributions that can reduce the performance overhead associated with database operations that involve multiple nodes, and can provide more even distribution of computing resource use. In a particular example, a method includes minimizing a scoring function that includes a plurality of performance metrics, at least a portion of the metrics being associated with a weight. Candidate table distributions can be analyzed in an iterative manner to determine a lowest-score distribution. A final table distribution can be output, such as to a user.

公开(公告)号：US10698892B2

公开(公告)日：2020-06-30

申请号：US15950013

申请日：2018-04-10

Applicant: SAP SE

Inventor： Nosub Sung ,  Myunggon Park ,  Taehyung Lee ,  Chul Won Lee ,  Juchang Lee ,  Sung Heun Wi

IPC: G06F15/16 ,  G06F16/2453 ,  G06F16/14 ,  G06F16/2455

Abstract: A process is provided for independently hashing and filtering a data set, such as during preprocessing. For the data set, one or more records, separately having one or more fields, may be identified. A record hash value set, containing one or more record hash values for the respective one or more records, may be generated. Generating a given record hash value may be accomplished as follows. For a given record, a hash value set may be generated, having one or more field hash values for the respective one or more fields of the given record. The record hash value for the given record may be generated based on the hash value set. A total hash value for the data set may be generated based on the record hash value set. The records of the data set may be filtered based on classification of the query that generated the records.

公开(公告)号：US20190222658A1

公开(公告)日：2019-07-18

申请号：US16362286

申请日：2019-03-22

Applicant: SAP SE

Inventor： Chang Gyoo Park ,  Juchang Lee ,  Kyu Hwan Kim ,  Chul Won Lee ,  Myunggon Park ,  Eunjin Song ,  Nosub Sung

IPC: H04L29/08 ,  G06F16/2455 ,  G06F16/20

CPC classification number: H04L67/22 ,  G06F16/20 ,  G06F16/2455 ,  H04L45/742

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.

公开(公告)号：US20170329835A1

公开(公告)日：2017-11-16

申请号：US15150815

申请日：2016-05-10

Applicant: SAP SE

Inventor： Chul Won Lee ,  Jeong Hee Won ,  Jaeyoung Choi ,  Nosub Sung

IPC: G06F17/30 ,  G06F9/50 ,  G06F9/46

CPC classification number: G06F16/283 ,  G06F9/466 ,  G06F9/5083 ,  G06F16/2455

Abstract: Technologies are described for facilitating transaction processing within a database environment that includes one or more processing units and a memory. A request for a database operation, such as a query, is received from a client. Execution statistics associated with the request are retrieved. At least some of the execution statistics are compared with one or more threshold values. Based on results of the comparing, the request is carried out with a first execution component or delegated to a second execution component. The request is executed and execution results are sent to the client.

公开(公告)号：US11681684B2

公开(公告)日：2023-06-20

申请号：US17150868

申请日：2021-01-15

Applicant: SAP SE

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

IPC: G06F16/23 ,  G06F16/28

CPC classification number: G06F16/2365 ,  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.

公开(公告)号：US20190311057A1

公开(公告)日：2019-10-10

申请号：US15950013

申请日：2018-04-10

Applicant: SAP SE

Inventor： Nosub Sung ,  Myunggon Park ,  Taehyung Lee ,  Chul Won Lee ,  Juchang Lee ,  Sung Heun Wi

IPC: G06F17/30

Abstract: A process is provided for independently hashing and filtering a data set, such as during preprocessing. For the data set, one or more records, separately having one or more fields, may be identified. A record hash value set, containing one or more record hash values for the respective one or more records, may be generated. Generating a given record hash value may be accomplished as follows. For a given record, a hash value set may be generated, having one or more field hash values for the respective one or more fields of the given record. The record hash value for the given record may be generated based on the hash value set. A total hash value for the data set may be generated based on the record hash value set. The records of the data set may be filtered based on classification of the query that generated the records.