Rule-Based Extendable Query Optimizer

摘要

A query is received which causes an initial data flow graph that includes a plurality of nodes that are used to execute the query is generated. Thereafter, the initial data flow graph is optimized using a model optimizer that includes an optimizer framework and an application programming interface (API). The optimizer framework provides logic to restructure the initial data flow graph and a rules engine for executing one or more optimization rules. The API allows for registration of new optimization rules to be executed by the rules engine. Execution of the query is then initiated using the optimized data flow graph. Related apparatus, systems, techniques and articles are also described.

主权项

1. A method comprising:
receiving, via an application programming interface of a model optimizer having an optimizer framework, data comprising at least one optimization rule; registering the at least one optimization rule for execution by a rules engine of the optimizer framework; receiving a query; generating an initial data flow graph comprising a plurality of nodes for executing the query; optimizing the initial data flow graph using the rules engine; and initiating executing of the query using the optimized data flow graph.