Patent · US Active

Optimization of parallelization of user-defined functions with flexible partitioning

US9454571B2 · kind B2 · utility

21Cited by

2References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Philipp Grosse · Frankfurt, DE
Wolfgang Lehner · Dresden, DE
Norman May · Karlsruhe, DE

Key dates

Filing date	Jun 26, 2014
Grant date	Sep 27, 2016
Priority date	—
Expiry date	Jan 14, 2035

Classification

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

Abstract

Technologies are disclosed for generating query execution plans optimized for parallel execution for programs having both core database relational functions and user-defined functions. A variety of optimization strategies can be employed to improve performance in a parallel execution scenarios. A flexible range of permitted partition arrangements can be specified as acceptable to parallelized instances of the user-defined function. The optimizer can leverage such information when constructing an optimized query execution plan. Partitioning arrangements or other properties can be leveraged to avoid additional or unnecessary processing.

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