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:
Apr. 07, 2026

Filed:

Oct. 27, 2021
Applicant:

Sap SE, Walldorf, DE;

Inventors:

Qingwei Ren, Xian, CN;

Zhe Qu, Xian, CN;

Zhilong Hao, Xian, CN;

Weimin Qi, Xian, CN;

Long Zhang, Xian, CN;

Jiaxin Liu, Xian, CN;

Xiaoke Liu, Xian, CN;

Xiaolong Yang, Xian, CN;

Assignee:

SAP SE, Walldorf, DE;

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/903 (2019.01); G06F 16/901 (2019.01);
U.S. Cl.
CPC ...
G06F 16/90335 (2019.01); G06F 16/9017 (2019.01);
Abstract

A method for processing a query may include evaluating a query on a database table to identify a time based function included in the query. One or more partitions of the database table may be pruned from the query based at least on the partitions being associated with a first time range that does not overlap with a second time range associated with the time based function. An execution plan for the query may be generated to include a sequence of operations that avoids accessing the one or more partitions pruned from the query. The query may be executed based at least on the execution plan by at least accessing a second partition of the database table but not the first partition of the database table pruned from the query. Related systems and articles of manufacture are also provided.


Find Patent Forward Citations

Loading…