Patent Number: 7,765,200

Title: SQL query problem determination tool

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.

Inventors: Kandil; Mokhtar (Toronto, CA), Markl; Volker Gerhard (San Jose, CA)

Assignee: International Business Machines Corporation

International Classification: G06F 7/00 (20060101); G06F 17/30 (20060101)

Expiration Date: 7/27/12018