Patent · US Active

Query plan generation and execution based on single value columns

US11556537B2 · kind B2 · utility

0Cited by

2References

18Claims

0Family size

Assignee

SAP SE · DE

Inventors

Paul Willems · Heidelberg, DE
Christina Teflioudi · Heidelberg, DE
Till Merker · Sandhausen, DE

Key dates

Filing date	Mar 29, 2019
Grant date	Jan 17, 2023
Priority date	—
Expiry date	Aug 18, 2039

Classification

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

Abstract

Aspects of the current subject matter are directed to executing queries on tables in which one or more columns contain a single value. Upon execution of a query, columns in which a single value is contained are identified, and a pre-compiled code entry containing relevant identifying information is compiled as part of a query execution plan. The query execution plan is used for subsequent query executions, alleviating the need to access the columns during the subsequent query executions that involve the columns. A fingerprint value may be used to track if changes to relevant tables occur.

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