发明名称 |
Framework for visualizing re-written queries to database |
摘要 |
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. |
申请公布号 |
US9477724(B2) |
申请公布日期 |
2016.10.25 |
申请号 |
US201414311670 |
申请日期 |
2014.06.23 |
申请人 |
SAP SE |
发明人 |
Song Sang Il;Kim Won Seok;Choi Sanghyun;Yoon Yongsik |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
Fountainhead Law Group P.C. |
代理人 |
Fountainhead Law Group P.C. |
主权项 |
1. A computer-implemented method comprising:
providing an engine in communication with a re-written query plan and with an interface, the re-written query plan resulting from application of a query plan re-write rule to a previous query plan; causing an engine to reference the re-written query plan in order to generate a visualization comprising a graph including an operation node and a table node; and causing the engine to communicate the visualization to the interface for display in a dashboard, wherein the dashboard further includes a change log separate from the graph and reflecting changes to the re-written query plan in a format comprising an identifier of the operation node, an operation type, an updated parent node identifier, and an identifier of the query plan re-write rule. |
地址 |
Walldorf DE |