Patent · US Active

Selectively allowing query optimization in query processing

US11360977B2 · kind B2 · utility

1Cited by

49References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Johannes Merx · Heidelberg, DE
Taehyung Lee · Seoul, KR
Sung Heun Wi · Opo-eup, KR
Jin Uk Bae · Seoul, KR
Ki Hong Kim · Seoul, KR
Stefan Baeuerle · Walldorf, DE
Florian Scheid · Wiesloch, DE

Key dates

Filing date	Apr 1, 2019
Grant date	Jun 14, 2022
Priority date	—
Expiry date	Sep 24, 2039

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/24537
WIPO fieldComputer technology
WIPO sectorElectrical engineering

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.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.