Invention Grant
- Patent Title: Regression testing of SQL execution plans for SQL statements
- Patent Title (中): SQL语句的SQL执行计划的回归测试
-
Application No.: US14494907Application Date: 2014-09-24
-
Publication No.: US09582409B2Publication Date: 2017-02-28
- Inventor: Jonathan M. Harding
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agency: Cuenot, Forsythe & Kim, LLC
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F11/36

Abstract:
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.
Public/Granted literature
- US20150254174A1 REGRESSION TESTING OF SQL EXECUTION PLANS FOR SQL STATEMENTS Public/Granted day:2015-09-10
Information query