| 发明名称 |
REGRESSION TESTING OF SQL EXECUTION PLANS FOR SQL STATEMENTS |
| 摘要 |
A first execution plan for a first version of a structured query language statement can be requested from a database management system. The first execution plan for the first version of the structured query language statement can be loaded into a first directed graph tree structure comprising a plurality of nodes. The first directed graph tree structure can be scanned to determine whether a full table scan for accessing requested data is represented by at least a one of the plurality of nodes of the directed graph tree structure. Responsive to determining that the full table scan for accessing the requested data is represented by the at least one of the plurality of nodes of the directed graph tree structure, a first indicator that indicates a fault condition can be output. |
| 申请公布号 |
US2015254174(A1) |
申请公布日期 |
2015.09.10 |
| 申请号 |
US201414494907 |
申请日期 |
2014.09.24 |
| 申请人 |
International Business Machines Corporation |
发明人 |
Harding Jonathan M. |
| 分类号 |
G06F11/36;G06F17/30 |
主分类号 |
G06F11/36 |
| 代理机构 |
|
代理人 |
|
| 主权项 |
1. A method, comprising:
requesting from a database management system a first execution plan for a first version of a structured query language statement; loading the first execution plan for the first version of the structured query language statement into a first directed graph tree structure comprising a plurality of nodes; scanning, using a processor, the first directed graph tree structure to determine whether a full table scan for accessing requested data is represented by at least a one of the plurality of nodes of the directed graph tree structure; and responsive to determining that the full table scan for accessing the requested data is represented by the at least one of the plurality of nodes of the directed graph tree structure, outputting a first indicator that indicates a fault condition. |
| 地址 |
Armonk NY US |
