Communication optimization for parallel execution of user-defined table functions
US7577637B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Aug 15, 2005 |
| Grant date | Aug 18, 2009 |
| Priority date | — |
| Expiry date | Nov 5, 2026 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99942
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
While generating an execution plan for a database statement that includes a user-defined table function that requires partitioning of input data to the function, it is determined whether the partitioning of output data from an operation that feeds the function is compatible with the partitioning required by the function. If the partitioning of output data from the operation that feeds the function is compatible with the partitioning required by the function, then the execution plan is constructed to specify execution of both (1) the function and (2) the operation that feeds the function, by a same set of processes. For example, the operation that feeds the function and the function itself are clumped into the same sub-plan or sub-tree, which is scheduled and run in parallel on a set of parallel execution slaves.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.