Invention Grant
- Patent Title: Selectively allowing query optimization in query processing
-
Application No.: US16371276Application Date: 2019-04-01
-
Publication No.: US11360977B2Publication Date: 2022-06-14
- Inventor: Johannes Merx , Taehyung Lee , Sung Heun Wi , Jin Uk Bae , Ki Hong Kim , Stefan Baeuerle , Florian Scheid
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fish & Richardson P.C.
- Main IPC: G06F16/00
- 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.
Public/Granted literature
- US20200311081A1 SELECTIVELY ALLOWING QUERY OPTIMIZATION IN QUERY PROCESSING Public/Granted day:2020-10-01
Information query