Monitoring and debugging query execution objects

摘要

Nodes in a query execution data structure have monitor and dump methods defined. The monitor method enables the collection of information from the node. The dump method outputs the monitored information from each node. A monitor and debug mechanism of the preferred embodiments includes a graphical user interface that allows a user to graphically examine a query execution tree, to enable monitoring of the nodes on a node-by-node basis, and to view information dumped from the query execution data structure as the query is executed or after the query is executed. The result is a powerful tool that allows efficiently monitoring and debugging a query implemented in an object oriented query execution data structure.

主权项

1. A computer-implemented method for displaying information regarding a query to a user in a graphical user interface, the method comprising the steps of:
executing the query, wherein the query comprises an object oriented query execution data structure that comprises a plurality of object oriented nodes, wherein each node includes a monitor method that enables collection of monitored data from the node and a dump method that outputs the monitored data; invoking the monitor method on a first node to enable collection of a minimal set of monitored data from the first node; invoking the monitor method on a second node to enable collection of a larger set of monitored data from the second node that includes a minimal set of monitored data for the second node; invoking the dump method on the first node to output the minimal set of monitored data for the first node to a file; invoking the dump method on the second node to output the larger set of monitored data from the second node to the file; receiving the monitored data for the first and second nodes from the object oriented query execution data structure by reading the file; displaying information corresponding to the monitored data to the user in the graphical user interface, wherein the graphical user interface is part of a monitor and debug mechanism for debugging the query as the query executes; examining the monitored data as the query executes; and performing query debug functions using the monitored data.