发明申请
- 专利标题: Interactive Query Plan Visualization and Optimization
- 专利标题(中): 交互式查询计划可视化和优化
-
申请号: US13323563申请日: 2011-12-12
-
公开(公告)号: US20130151505A1公开(公告)日: 2013-06-13
- 发明人: Yongsik Yoon , Chanho Jeong , Sang Kyun Cha
- 申请人: Yongsik Yoon , Chanho Jeong , Sang Kyun Cha
- 申请人地址: DE Walldorf
- 专利权人: SAP AG
- 当前专利权人: SAP AG
- 当前专利权人地址: DE Walldorf
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
A computer system affords a user the ability to interactively formulate, visualize, and modify query plans that are to be posed to a database. The computer system provides query visualization in the form of decision trees having nodes selectable/deselectable to search for alternative query plans with lower or minimum execution time. The estimated cost and/or the execution time of a subtree of a query plan may be mapped according to a rectangle area metaphore, with the area of a rectangle enclosed by a larger rectangle representing a parent node in the plan tree. Query plans may be saved by the system in order to facilitate their visualization, optimization, and/or modification at a later date.
公开/授权文献
- US08838578B2 Interactive query plan visualization and optimization 公开/授权日:2014-09-16
信息查询