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. An apparatus comprising:
at least one processor; a memory coupled to the at least one processor; a database residing in the memory; a query engine residing in the memory and executed by the at least one processor, the query engine querying the database; a query execution data structure residing in the memory and executed by the query engine, the query execution data structure comprising a plurality of object oriented nodes, wherein each node includes an object oriented monitor method that enables collection of monitored data from the node and an object oriented dump method that outputs the monitored data; and a monitor and debug mechanism residing in the memory and executed by the at least one processor, wherein the monitor and debug mechanism receives the monitored data from at least one dump method in the query execution data structure and displays to a user a graphical representation of the query execution data structure that allows the user to enable monitoring of the plurality of object oriented nodes on a node-by-node basis, to view information dumped from the query execution data structure as the query engine executes the query execution data structure, and to perform query debug functions using the monitored data.