发明申请
US20090049012A1 APPARATUS, SYSTEM, AND METHOD FOR ENSURING QUERY EXECUTION PLAN STABILITY IN A DATABASE MANAGEMENT SYSTEM
失效
用于在数据库管理系统中实现查询执行计划稳定性的装置,系统和方法
- 专利标题: APPARATUS, SYSTEM, AND METHOD FOR ENSURING QUERY EXECUTION PLAN STABILITY IN A DATABASE MANAGEMENT SYSTEM
- 专利标题(中): 用于在数据库管理系统中实现查询执行计划稳定性的装置,系统和方法
-
申请号: US11840703申请日: 2007-08-17
-
公开(公告)号: US20090049012A1公开(公告)日: 2009-02-19
- 发明人: Patrick D. Bossman , Frank D. Bower , John J, Campbell , You-Chin Fuh , Adarsh R. Pannu , Terence P. Purcell
- 申请人: Patrick D. Bossman , Frank D. Bower , John J, Campbell , You-Chin Fuh , Adarsh R. Pannu , Terence P. Purcell
- 申请人地址: US NY Armonk
- 专利权人: International Business Machines Corporation
- 当前专利权人: International Business Machines Corporation
- 当前专利权人地址: US NY Armonk
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
An apparatus, system, and method are disclosed for ensuring query execution plan stability in a database management system. The present invention binds a static database query to a new query execution plan (QEP) that produces the same result set as an original QEP bound to the static database query. Next, the present invention identifies one of the original QEP and the new QEP as a primary QEP and automatically collects execution statistics for the original QEP and the new QEP. Finally, the present invention automatically selects one of the original QEP and the new QEP as the primary QEP in response to completion of the automatic collection of execution statistics, the primary QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the primary QEP selected based on the execution statistics.
公开/授权文献
信息查询