Patent · US Active

Evaluation of duplicated filter predicates

US11372927B2 · kind B2 · utility

0Cited by

3References

17Claims

0Family size

Assignee

SAP SE · DE

Inventors

Oliver Horn · Munich, DE
Till Merker · Sandhausen, DE
Paul Willems · Heidelberg, DE

Key dates

Filing date	Apr 4, 2019
Grant date	Jun 28, 2022
Priority date	—
Expiry date	Feb 5, 2040

Classification

Technology area (CPC G)Physics
CPC primaryG06F2212/60
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A method, a system, and a computer program product for executing a query in a database system. A query plan for execution of a query is generated. The query requires access to at least one table stored in a database system. One or more occurrences of one or more duplicate predicates is detected in the query plan. In response to detecting a first occurrence of the duplicate predicates, one or more intermediate query execution results responsive to the duplicate predicates are generated. The generated intermediate query execution results are cached. Query execution results incorporating cached intermediate query execution results being responsive to each occurrence of the duplicate predicates subsequent to the first occurrence of the duplicate predicates in the query plan are generated.

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