SQL query problem determination tool
US7765200B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 25, 2005 |
| Grant date | Jul 27, 2010 |
| Priority date | — |
| Expiry date | Sep 17, 2026 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F11/362
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and system for query problem determination have been disclosed. The method includes receiving a database query; creating a query execution plan for the database query comprising a plurality of query plan operators; and executing the query execution plan, wherein a progress indicator is displayed for each query plan operator. The system includes a query progress monitor, which collects progress information for each query plan operator during the execution of the query execution plan. This progress information is then communicated to a query progress visualizer and a query progress analyzer, which graphically displays the progress information as a progress indicator for each query plan operator and performs debugger type operations, respectively. In this manner, information concerning the progress of the query execution is provided at a query operator level, such that the information may be used to more efficiently debug any problems with the query.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.