公开(公告)号：US20170322972A1

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

申请号：US15150075

申请日：2016-05-09

Applicant: SAP SE

Inventor： Chul Won Lee ,  Juchang Lee ,  Myunggon Park ,  Wonyoung Kwak ,  Jeong Hee Won ,  Ki Hong Kim ,  Kyu Hwan Kim ,  Beomsoo Kim

IPC: G06F17/30

CPC classification number: G06F16/24532 ,  G06F16/116 ,  G06F16/137 ,  G06F16/1727 ,  G06F16/21

Abstract: Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.

公开(公告)号：US20220100715A1

公开(公告)日：2022-03-31

申请号：US17210393

申请日：2021-03-23

Applicant: SAP SE

Inventor： Juchang Lee ,  Ivan Veselinov Andreev ,  Eunsang Kim ,  Jaehwa Kim ,  Yong Sik Kwon ,  Joo Yeon Lee ,  Jian Luo ,  Myunggon Park ,  Edward-Robert Tyercha ,  Zheng-Wei Wang ,  Paul Willems

IPC: G06F16/21 ,  G06F16/25 ,  G06F21/62 ,  G06F21/60

Abstract: A physio-logical migration of a database from a source system to a target system may include exporting a catalog of the database in a data interchange format that preserves the hierarchical dependencies present amongst the entities included in the catalog. The physio-logical migration of the database may further include exporting the contents of a table in the database in a binary format compatible at the target system. The binary format may be a data buffer having a metadata portion, a fixed-size portion, and a page chain portion. Where the target system is a cloud-based system, the physio-logical migration of the database may include exporting the catalog and the contents of the table to a cloud-based object store before importing the catalog and the contents of the table to the target system. Related systems and articles of manufacture, including computer program products, are also provided.

公开(公告)号：US20210311851A1

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

申请号：US16984303

申请日：2020-08-04

Applicant: SAP SE

Inventor： Juchang Lee ,  Myunggon Park ,  Jihwan Lim ,  YoungSeok Hwang

IPC: G06F11/34 ,  G06F16/185 ,  G06F16/17

Abstract: Methods, systems, and computer-readable storage media for receiving a capture file, the capture file including data representative of a workload executed in a source database system, and processing the capture file to provide a replay file, the replay file being in a format that is executable by a replayer to replay the workload in a target database system, processing the capture file including: processing the capture file to provide a set of intermediate files, and processing the set of intermediate files using in-memory merge sort operations to generate a set of replay files.

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

公开(公告)号：US11829360B2

公开(公告)日：2023-11-28

申请号：US17678720

申请日：2022-02-23

Applicant: SAP SE

Inventor： Chul Won Lee ,  Juchang Lee ,  Myunggon Park ,  Wonyoung Kwak ,  Jeong Hee Won ,  Ki Hong Kim ,  Kyu Hwan Kim ,  Beomsoo Kim

IPC: G06F16/2453 ,  G06F16/11 ,  G06F16/13 ,  G06F16/17 ,  G06F16/21

CPC classification number: G06F16/24532 ,  G06F16/116 ,  G06F16/137 ,  G06F16/1727 ,  G06F16/21

Abstract: Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.

公开(公告)号：US11615012B2

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

申请号：US16984303

申请日：2020-08-04

Applicant: SAP SE

Inventor： Juchang Lee ,  Myunggon Park ,  Jihwan Lim ,  YoungSeok Hwang

IPC: G06F11/00 ,  G06F11/34 ,  G06F16/17 ,  G06F16/185

Abstract: Methods, systems, and computer-readable storage media for receiving a capture file, the capture file including data representative of a workload executed in a source database system, and processing the capture file to provide a replay file, the replay file being in a format that is executable by a replayer to replay the workload in a target database system, processing the capture file including: processing the capture file to provide a set of intermediate files, and processing the set of intermediate files using in-memory merge sort operations to generate a set of replay files.

公开(公告)号：US11468062B2

公开(公告)日：2022-10-11

申请号：US16801039

申请日：2020-02-25

Applicant: SAP SE

Inventor： Nosub Sung ,  Myunggon Park ,  Taehyung Lee ,  Chui 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.

公开(公告)号：US20200183929A1

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

申请号：US16715882

申请日：2019-12-16

Applicant: SAP SE

Inventor： Chul Won Lee ,  Juchang Lee ,  Myunggon Park ,  Wonyoung Kwak ,  Jeong Hee Won ,  Ki Hong Kim ,  Kyu Hwan Kim ,  Beomsoo Kim

IPC: G06F16/2453 ,  G06F16/21 ,  G06F16/17 ,  G06F16/13 ,  G06F16/11

Abstract: Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.

公开(公告)号：US11709752B2

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

申请号：US16838113

申请日：2020-04-02

Applicant: SAP SE

Inventor： Myunggon Park ,  Wonyoung Kwak ,  YoungSeok Hwang ,  Jihun Kang

IPC: G06F11/34 ,  G06F11/30 ,  G06F16/14 ,  G06F16/182

CPC classification number: G06F11/3414 ,  G06F11/3034 ,  G06F11/3466 ,  G06F16/144 ,  G06F16/156 ,  G06F16/182 ,  G06F2201/80

Abstract: Methods, systems, and computer-readable storage media for receiving a capture file, the capture file holding data representative of a workload executed in a source database system, processing the capture file to provide a replay file, the replay file being in a format that is executable by a replayer to replay the workload in a target database system, the workload including a set of requests represented within the replay file, providing a set of tags associated with the replay file, the set of tags including one or more tags, each tag associated with a request in the set of requests, and during replay of the workload in the target database system: pausing replay of the workload in response to a tag, executing a request associated with the tag, providing replay results specific to the request, and selectively resuming replay of the workload in the target database system.

公开(公告)号：US20220179860A1

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

申请号：US17678720

申请日：2022-02-23

Applicant: SAP SE

Inventor： Chul Won Lee ,  Juchang Lee ,  Myunggon Park ,  Wonyoung Kwak ,  Jeong Hee Won ,  Ki Hong Kim ,  Kyu Hwan Kim ,  Beomsoo Kim

IPC: G06F16/2453 ,  G06F16/11 ,  G06F16/13 ,  G06F16/17 ,  G06F16/21

Abstract: Technologies are described for facilitating data workload capture, workload replay, and comparing the performance of a plurality of database systems. A plurality of requests for database operations are received from one or more database clients. The requests for database operations are executed. For the plurality of requests for database operations, execution context information is generated for a plurality of execution contexts. For the plurality of requests for database operations, a plurality of performance measures are generated. The execution context information and the performance measures are stored in a workload capture store, such as a file. The workload capture file is useable to replay the captured workload at a second database system using at least a portion of the execution context information and at least a portion of the performance measures.