Patent · US Active

Data driven multi-provider pruning for query execution plan

US10628418B2 · kind B2 · utility

29Cited by

4References

17Claims

0Family size

Assignee

SAP SE · DE

Inventors

Christoph Weyerhaeuser · Leimen, DE
Tobias Mindnich · Walldorf, DE
Johannes Merx · Heidelberg, DE
Joerg Schad · Leimen, DE
Julian Schwing · Mannheim, DE
Daniel Patejdl · Karlsruhe, DE

Key dates

Filing date	Nov 13, 2014
Grant date	Apr 21, 2020
Priority date	—
Expiry date	Mar 24, 2036

Classification

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

Abstract

According to an aspect, a system includes a query engine configured to obtain a multi-provider query model for a query specifying a filter to be applied on provider partitions. The obtained multi-provider query model incorporates a pruning plan. The query engine includes a query optimizer configured to execute the pruning plan during optimization of the multi-provider query model. The pruning plan determines if each of the provider partitions includes content that is required to execute the filter based on pruning information. The query optimizer configured to reduce a scope of the query by excluding at least one provider partition that is determined as not required to execute the filter.

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