Parallel programming of in memory database utilizing extensible skeletons

摘要

An execution framework allows developers to write sequential computational logic, constrained for the runtime system to efficiently parallelize execution of custom business logic. The framework can be leveraged to overcome limitations in executing low level procedural code, by empowering the system runtime environment to parallelize this code. Embodiments employ algorithmic skeletons in the realm of optimizing/executing data flow graphs of database management systems. By providing an extensible set of algorithmic skeletons the developer of custom logic can select the skeleton appropriate for new custom logic, and then fill in the corresponding computation logic according to the structural template of the skeleton. The skeleton provides a set of constraints known to the execution environment, that can be leveraged by the optimizer and the execution environment to generate parallel optimized execution plans containing custom logic, without the developer having to explicitly describe parallelization of the logic.

主权项

1. A computer-implemented method comprising:
in a design time environment,
providing compute logic for data management to a parallelization engine as a first input, wherein the parallelization engine is a calculation engine of a single in-memory database;providing a skeleton template to the parallelization engine as a second input, the skeleton template selected from a given set of existing skeleton templates and including a constraint matching the compute logic, andcausing the parallelization engine to reference the skeleton template to transform the compute logic into an instantiation of a skeleton describing the compute logic; and in a run time environment, causing the parallelization engine to embed the instantiation into a parallel execution plan for execution of SQL operations in parallel on data of the in-memory database.