Framework for Re-Writing Database Queries

摘要

Embodiments relate to re-writing database query plans, and visualizing such re-written query plans. A query re-write framework includes a query normalization engine in communication with a rule catalog comprising query re-write rules in the form of rule classes. The framework receives as input, a query plan graph to be re-written. Based upon the engine's application of re-write rules from the catalog, the framework produces a re-written query plan graph as output. An interface component of the framework may provide a visualization of the re-written query plan graph as part of a dashboard. A user may access the framework to enable/disable existing rules in the catalog, add new rules to the catalog, and/or control a sequence and a precedence in which rules are applied to re-write the query plan. A user may interact with the visualization of the re-written query plan for purposes of de-bugging, re-write optimization, and/or query development.

主权项

1. A computer-implemented method comprising:
providing an engine in communication with a rule catalog comprising a plurality of query plan re-write rules; causing the engine to receive a query plan as an input; causing the engine to reference the rule catalog to generate a re-written query plan by applying a first query plan re-write rule to the query plan; and causing the engine to store the re-written query plan in a non-transitory computer readable storage medium.