公开(公告)号：US11803545B1

公开(公告)日：2023-10-31

申请号：US17849446

申请日：2022-06-24

Applicant: SAP SE

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

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

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

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.

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

公开(公告)号：US20180336245A1

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

申请号：US15596905

申请日：2017-05-16

Applicant: SAP SE

Inventor： Di Wu ,  Ki Hong Kim ,  Stefan Baeuerle ,  Steffen Weinstock ,  Daniel Hutzel ,  Zhi Qiao

IPC: G06F17/30

CPC classification number: G06F16/24535 ,  G06F16/212 ,  G06F16/245 ,  G06F16/24537

Abstract: A method for propagating a structure query language (SQL) association can include determining, based at least on a syntax of a SQL create view statement, that a SQL association requires propagation to a SQL view associated with the SQL create view statement. The SQL association can combine data from at least a first data model and a second data model at a database. The SQL view can comprise at least a portion of the combined data. An association information data structure can be generated for storing information corresponding to a definition of the SQL association. The SQL create view statement can be executed based on the association information data structure. Related systems and articles of manufacture, including computer program products, are also disclose.

公开(公告)号：US20200311081A1

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

申请号：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/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.

公开(公告)号：US10599650B2

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

申请号：US15208736

申请日：2016-07-13

Applicant: SAP SE

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

IPC: G06F7/00 ,  G06F17/30 ,  G06F16/2453 ,  G06F16/22

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.

公开(公告)号：US10275508B2

公开(公告)日：2019-04-30

申请号：US14946757

申请日：2015-11-19

Applicant: SAP SE

Inventor： Christian Bensberg ,  Norman May ,  Alexander Boehm ,  Juchang Lee ,  Sung Heun Wi ,  Jeong Ae Han ,  Ki Hong Kim ,  Kyu Hwan Kim ,  Chul Won Lee ,  Andreas Kemmler ,  Christoph Glania ,  Armin Risch ,  Kai Morich

IPC: G06F17/30

Abstract: A method may include receiving a query for data to be provided by a database server, wherein the query includes an indication of a maximum lag. The method may further include determining whether a hint is available to apply to the query, wherein the hint affects an execution of the query. When no hint is available, a baseline database server may be selected to be the database server. When the hint is available, a replication server or a cache server may be selected to be the database server based on the hint and the maximum lag. The query may be processed at the selected database server.

公开(公告)号：US10997174B2

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

申请号：US14947927

申请日：2015-11-20

Applicant: SAP SE

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

IPC: G06F16/24 ,  G06F16/2453

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.

公开(公告)号：US20200320069A1

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

申请号：US16372652

申请日：2019-04-02

Applicant: SAP SE

Inventor： Taeyoung Jeong ,  Chanho Jeong ,  Ki Hong Kim

IPC: G06F16/242 ,  G06F16/9038 ,  G06F16/2455 ,  G06F16/2453 ,  G06F16/2452

Abstract: Implementations of the present disclosure include providing a parse tree including a declarative portion and an imperative portion, dividing the parse tree to provide a first parse sub-tree and a second parse sub-tree, compiling the first parse sub-tree using a declarative compiler to provide a query execution plan (QEP) including an imperative script operator to prompt execution of the imperative portion, compiling the second parse sub-tree using an imperative compiler to provide one or more script execution plans, executing, by an execution engine, the QEP until encountering an imperative script operator, and, in response to encountering the imperative script operator, initiating execution of the one or more script execution plans to provide an imperative result, and providing a query result at least partially including the imperative result.

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

公开(公告)号：US20170147639A1

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

申请号：US14946745

申请日：2015-11-19

Applicant: SAP SE

Inventor： Jane Jung Lee ,  Taehyung Lee ,  Jiyoung Yoo ,  Sung Heun Wi ,  Ki Hong Kim

IPC: G06F17/30

CPC classification number: G06F17/30463

Abstract: In one aspect there is a method. The method may include associating a query received from an application with a hint, wherein the hint modifies an execution of the query. The method may further include an optimizer to compile the query according to the hint to produce a second query plan. When no hint is associated with the query, the optimizer may produce a first query plan. The method may further include storing the hint in a persistent table to enable state preservation during a database restart or binary upgrade, and/or executing the query using the second query plan.