公开(公告)号：US11294897B2

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

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

公开(公告)号：US10558658B2

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

申请号：US15596905

申请日：2017-05-16

Applicant: SAP SE

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

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/21 ,  G06F16/245

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.

公开(公告)号：US10552413B2

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

申请号：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: G06F16/2453 ,  G06F16/11 ,  G06F16/13 ,  G06F16/17

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.

公开(公告)号：US10303686B2

公开(公告)日：2019-05-28

申请号：US14946745

申请日：2015-11-19

Applicant: SAP SE

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

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

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.

公开(公告)号：US20170147671A1

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

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

CPC classification number: G06F17/30578 ,  G06F17/3048

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.