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

公开(公告)号：US11360977B2

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

申请号：US16371276

申请日：2019-04-01

Applicant: SAP SE

Inventor： Johannes Merx ,  Taehyung Lee ,  Sung Heun Wi ,  Jin Uk Bae ,  Ki Hong Kim ,  Stefan Baeuerle ,  Florian Scheid

IPC: G06F16/00 ,  G06F16/2453

Abstract: Implementations of the present disclosure include receiving, by a query processing server, a first query, the first query including a syntax indicating that precision loss is allowed, processing, by the query processing server, the first query to provide a first QEP, optimization of which would result in precision loss in a generated query result, determining that the syntax is provided, and in response, optimizing the first QEP to provide an optimized QEP, executing the optimized QEP to generate a query result that includes data stored within a database system, the query result having reduced accuracy relative to a query result that would be generated based on the first QEP, and providing the query result as output from the database system.

公开(公告)号：US20200311078A1

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

申请号：US16368448

申请日：2019-03-28

Applicant: SAP SE

Inventor： Zhi Qiao ,  Stefan Baeuerle ,  Ki Hong Kim ,  Florian Scheid ,  Timm Falter ,  Andreas Balzar ,  Di Wu

IPC: G06F16/2453 ,  G06F16/22 ,  G06F9/54

Abstract: Implementations of the present disclosure include receiving a query, the query including an expression macro (EM), processing the query to provide a raw parse tree, the raw parse tree including an initial node representative of the EM, retrieving metadata corresponding to the EM, the metadata including a definition string, replacing the initial node with a node based on the definition string to provide a consumable parse tree, and executing the query within the database system using the consumable parse tree to provide a query result.

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

公开(公告)号：US20180293276A1

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

申请号：US15483690

申请日：2017-04-10

Applicant: SAP SE

Inventor： Jin Uk Bae ,  Stefan Baeuerle ,  Christian Bensberg ,  Steffen Geissinger ,  Ki Hong Kim ,  Taehyung Lee ,  Jaeyun Noh ,  Di Wu ,  Long Zhang

IPC: G06F17/30

Abstract: A method can include: generating a query execution plan for a query including a plurality of operations that operate on data from a relational database and data from a non-structured query language (NoSQL) database, the generating comprising optimizing the query by: identifying a first operation that operate on data from the relational database and an intermediate result output by a second operation, the second operation outputting the intermediate result by operating on the data from the NoSQL database; and determining a fixed datatype for the intermediate result, an indication of the fixed datatype being included in the query execution plan; and executing, based on the query execution plan, the query, the executing of the query comprising converting the intermediate result to the fixed datatype, the converting enabling the first operation to operate on the intermediate result output by the second operation along with the data from the relational database.

公开(公告)号：US20180018368A1

公开(公告)日：2018-01-18

申请号：US15208736

申请日：2016-07-13

Applicant: SAP SE

Inventor： Stefan Baeuerle ,  Bjoern Mielenhausen ,  Daniel Hutzel ,  Ki Hong Kim ,  Di Wu ,  Long Zhang

IPC: G06F17/30

CPC classification number: G06F16/24544 ,  G06F16/22 ,  G06F16/24535

Abstract: A system, medium, and method to define a database table and view based on a database model using a database language statement, the database language statement including a statement to create the table and a forward-declared JOIN statement that names the table and view, respectively and includes information regarding a relationship between at least two entities of the database.

公开(公告)号：US20170147645A1

公开(公告)日：2017-05-25

申请号：US14947927

申请日：2015-11-20

Applicant: SAP SE

Inventor： Sang Il Song ,  Junhee Woo ,  Taehyung Lee ,  Sung Heun Wi ,  Ki Hong Kim ,  Yongsik Yoon

IPC: G06F17/30

CPC classification number: G06F16/24544

Abstract: Methods and apparatus, including computer program products, are provided for a case join. In one aspect, there is provided method, which may include receiving a query for a predefined view that is configured to inhibit modification; detecting whether the predefined view includes a database table extended to include an additional column; and generating, in response to the query, a view based on a case join, when the predefined view includes the database table extended to include the additional column. Related apparatus, systems, methods, and articles are also described.

公开(公告)号：US20240012814A1

公开(公告)日：2024-01-11

申请号：US18473752

申请日：2023-09-25

Applicant: SAP SE

Inventor： Jaehyok Chong ,  Young Goo Cho ,  Ki Hong Kim

IPC: G06F16/2453 ,  G06F16/22 ,  G06F16/28 ,  G06F16/2457

CPC classification number: G06F16/24542 ,  G06F16/2246 ,  G06F16/284 ,  G06F16/24573

Abstract: A computer implemented method can execute a first query plan for a query, obtain statistics for internal nodes of a first query tree representing the first query plan, receive a second query tree representing a second query plan for the query, search for a matching internal node of the first query tree for a selected internal node of the second query tree, and responsive to finding the matching internal node of the first query tree, apply the statistics for the matching internal node of the first query tree to the selected internal node of the second query tree for estimating cost of the second query plan during query optimization of the query. Related systems and software for implementing the method are also disclosed.

公开(公告)号：US20230048391A1

公开(公告)日：2023-02-16

申请号：US17561104

申请日：2021-12-23

Applicant: SAP SE

Inventor： Taeyoung Jeong ,  Kisung Park ,  Chanho Jeong ,  Ki Hong Kim ,  Young-Koo Lee ,  Md Mostofa Kamal Rasel

IPC: G06F16/2453

Abstract: In some embodiments, a method receives a statement graph for a procedure that is used to access data and determines a set of producer statements and a set of consumer statements in the statement graph. A producer statement produces a variable for a consumer statement, and the consumer statement consumes the variable from the producer statement. The method optimizes the statement graph to generate an optimized procedure by moving an operator from a consumer statement to a producer statement or by moving an operator from a producer statement to a consumer statement. The optimized procedure is output based on the optimized statement graph.

公开(公告)号：US11416485B2

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

申请号：US16368448

申请日：2019-03-28

Applicant: SAP SE

Inventor： Zhi Qiao ,  Stefan Baeuerle ,  Ki Hong Kim ,  Florian Scheid ,  Timm Falter ,  Andreas Balzar ,  Di Wu

IPC: G06F16/2453 ,  G06F9/54 ,  G06F16/22

Abstract: Implementations of the present disclosure include receiving a query, the query including an expression macro (EM), processing the query to provide a raw parse tree, the raw parse tree including an initial node representative of the EM, retrieving metadata corresponding to the EM, the metadata including a definition string, replacing the initial node with a node based on the definition string to provide a consumable parse tree, and executing the query within the database system using the consumable parse tree to provide a query result.