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

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

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