The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Date of Patent:
Jun. 28, 2022

Filed:

Apr. 04, 2019
Applicant:

Sap SE, Walldorf, DE;

Inventors:

Oliver Horn, Nussloch, DE;

Till Merker, Sandhausen, DE;

Paul Willems, Heidelberg, DE;

Assignee:

SAP SE, Walldorf, DE;

Attorney:
Primary Examiner:
Assistant Examiner:
Int. Cl.
CPC ...
G06F 16/24 (2019.01); G06F 16/903 (2019.01); G06F 12/0802 (2016.01); G06F 16/2455 (2019.01);
U.S. Cl.
CPC ...
G06F 16/90335 (2019.01); G06F 12/0802 (2013.01); G06F 16/24568 (2019.01); G06F 2212/60 (2013.01);
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.


Find Patent Forward Citations

Loading…