Patent · US Active

Filter evaluation for table fragments

US11176133B2 · kind B2 · utility

12Cited by

0References

14Claims

0Family size

Assignee

SAP SE · DE

Inventors

Oliver Horn · Munich, DE
Lars Fricke · Worms, DE

Key dates

Filing date	Apr 4, 2019
Grant date	Nov 16, 2021
Priority date	—
Expiry date	Nov 5, 2039

Classification

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

Abstract

A method, a system, and a computer program product for analysis of query filtering mechanisms for table fragments. A query plan for execution of a query is generated. The query requires access to at least one table stored in a database system. The query includes one or more filter predicates. The table is partitioned into a plurality of fragments. A determination whether a fragment in the table is compressed and whether the fragment is associated with an index is made. A filter predicate is selected for processing the fragment. For the selected filter predicate, a filter evaluation of the selected filter predicate for the fragment is determined. The filter evaluation of the selected predicate is executed for the fragment.

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