Query processing visualization system and method of visualizing query processing

• US 8,122,050 B2
• Filed: 04/16/2008
• Issued: 02/21/2012
• Est. Priority Date: 04/16/2008
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Mordvinov, Vladimir, Azizi, Soufiane
• Primary Examiner(s): Mofiz, Apu
• Assistant Examiner(s): PYO, MONICA M
• Application Number:
  US12/104,108
• Publication Number:
  US 20090265324A1
• Time in Patent Office: 1,406 Days
• Field of Search: 707/999.003, 707/999.004, 707/769, 707/773
• US Class Current: 707/769
• CPC Class Codes: G06F 16/245 Query processing

Abstract

A query processing visualization system comprises a visualization module. The visualization module visualizes logging information of query processing events occurring during processing of a client query requesting data from one or more data sources by analyzing the logging information to identify dependency of the query processing events, formatting visual presentation components representing the logging information in a hierarchy to reflect the dependency of the query processing events, and presenting the visual presentation components in the context of the hierarchy of the visual components as formatted.

Claims

1. A query processing visualization system comprising:

a computer;

a visualization module executable by the computer for visualizing logging information of query processing events occurring during processing of a client query requesting data from one or more data sources, the visualization module comprising;

a logging information analyzer to analyze the logging information to identify one or more dependencies of the query processing events, analyze logging information of method calls corresponding to main query processing events, identify one or more dependencies of the method calls, and identify at least one recursive dependency of the method calls;

an event sequence formatter to format visual presentation components representing the logging information in a hierarchy to reflect the one or more dependencies of the query processing events, format the visual presentation components in the hierarchy to reflect the one or more dependencies of the method calls, and format the visual presentation components representing recursively called method calls as collapsible components; and

a method call presentation handler to present the visual presentation components in a context of the hierarchy of the visual components as formatted by the event sequence formatter, present the visual presentation components that represent method calls in the context of the hierarchy of the visual presentation components, and present the collapsible components such that methods at a given calling depth are visually presented.

2. The query processing visualization system as recited in claim 1, wherein the event sequence formatter includes a transforming method call handler that allows opening a tree of macro operations representing a method that has transformed a structure of the tree.

3. The query processing visualization system as recited in claim 1, wherein

the logging information analyzer extracts logging information including event process information of a method call;

and

the method call presentation handler includes a process information adder for adding the process information to a visual component representing the method call.

4. The query processing visualization system as recited in claim 3, wherein the process information includes at least one of an elapse time and memory consumption of the method call.

5. The query processing visualization system as recited in claim 3, wherein the process information adder highlights the process information in the presentation.

6. The query processing visualization system as recited in claim 1, wherein the method call presentation handler comprises a component label handler to label a presentation component representing a method call by a name of the method, name of a container object and name of a service provider that provides a processing service of the method.

7. The query processing visualization system as recited in claim 1, wherein

the logging information analyzer extracts logging information including parameter information of a method call;

and

the method call presentation handler includes a parameter information adder to add to a visual component representing the method call an access to the parameter information of the method call.

8. The query processing visualization system as recited in claim 7, wherein the parameter information adder adds at least one of an input parameter access, an output parameter access, and a return parameter access.

9. The query processing visualization system as recited in claim 7, wherein the parameter information handler includes a macro operation tree handler to present a tree of macro operations that represents a parameter containing a query framework query, the query framework query being executable by one or more query processing service providers of a query framework that processes the client query.

10. The query processing visualization system as recited in claim 9, wherein the macro operations include at least one of a query result definition, query and provider query.

11. The query processing visualization system as recited in claim 9, wherein the method call presentation handler includes an execute option handler to allow execution of the query framework query and to present a view containing query results of the execution.

12. The query processing visualization system as recited in claim 9, wherein the macro operation tree handler includes a macro operation details handler to expose a structure of the macro operations that completes definition of the macro operations in a format.

13. The query processing visualization system as recited in claim 1, wherein

the logging information analyzer extracts logging information of a query execution plan which is generated as a result of a query planning process, the query execution plan including macro operations that are executable by query processing service providers;

the event sequence formatter formats visual presentation components representing the executable macro operations to represent the query execution plan; and

the method call presentation handler presents the visual presentation components for validation of the execution plan.

14. The query processing visualization system as recited in claim 1 further comprising a logging module that comprises:

an event capturer to capture query processing events occurring during the processing of the client query;

a method call identifier to identify, as method calls, main query processing events among the captured query processing events; and

a logging element handler to log each method call as being represented by a logging element.

15. A method of visualizing query processing, the method comprising:

analyzing logging information of query processing events occurring during processing of a client query requesting data from one or more data sources so as to identify one or more dependencies of the query processing events;

analyzing logging information of method calls corresponding to main query processing events so as to identify one or more dependencies of the method calls and at least one recursive dependency of the method calls;

formatting visual presentation components representing the logging information of the query processing events in a hierarchy to reflect the one or more dependencies of the query processing events;

formatting the visual presentation components representing the logging information of the method calls in a hierarchy to reflect the one or more dependencies of the method calls;

formatting the visual presentation components representing recursively called method calls as collapsible components;

presenting the visual presentation components representing the logging information of the query processing events in a context of the hierarchy of the visual components;

presenting the visual presentation components that represent the method calls in the context of the hierarchy of the visual components; and

presenting the collapsible components such that methods at a given calling depth are visually presented,

wherein one or more of the analyzing, formatting, and presenting are performed by a computer.

16. The method as recited in claim 15, wherein presenting the visual presentation components that represent the method calls comprises allowing opening a tree of macro operations representing a method that has transformed a structure of the tree.

17. The method as recited in claim 15, wherein

analyzing the logging information of the method calls comprises extracting logging information including event process information of a method call;

and

presenting the visual presentation components that represent the method calls comprises adding the process information to a visual component representing the method call.

18. The method as recited in claim 17, wherein presenting the visual presentation components that represent the method calls comprises adding at least one of an elapse time and memory consumption of the method call.

19. The method as recited in claim 15, wherein formatting the visual presentation components representing the logging information of the method calls comprises labeling a presentation component representing a method call by a name of method, name of container object and name of a service provider that provides a processing service of the method.

20. The method as recited in claim 15, wherein

analyzing the logging information of the method calls comprises extracting logging information including parameter information of a method call;

and

presenting the visual presentation components that represent the method calls comprises adding an access to the parameter information of the method call to a visual component representing the method call.

21. The method as recited in claim 20, wherein adding the access to the parameter information comprises presenting a tree of macro operations that represents a parameter containing a query framework query, the query framework query being executable by one or more query processing service providers of a query framework that processes the client query.

22. The method as recited in claim 21, wherein presenting the tree of macro operations comprises providing an execute option to allow execution of the query framework query and to present a view containing query results of the execution.

23. The method as recited in claim 15, wherein

analyzing logging information of query processing events comprises obtaining logging information of a query execution plan which is generated as a result of a query planning process, the query execution plan consisting of macro operations that are executable by query processing service providers;

formatting the visual presentation components representing the logging information of query processing events comprises formatting visual presentation components representing the executable macro operations to represent the query execution plan; and

presenting the visual presentation components representing the logging information of the query processing events comprises presenting the visual presentation components representing the logging information of the query processing events for validation of the execution plan.

24. The method as recited in claim 15 further comprising obtaining the logging information by:

capturing query processing events occurring during the processing of the client query;

identifying, as method calls, main query processing events among the captured query processing events; and

logging each method call as being represented by a logging element.

25. A computer readable memory comprising instructions executable by a computer to:

analyze logging information of query processing events occurring during processing of a client query requesting data from one or more data sources so as to identify one or more dependencies of the query processing events;

analyze logging information of method calls corresponding to main query processing events so as to identify one or more dependencies of the method calls and at least one recursive dependency of the method calls;

format visual presentation components representing the logging information of the query processing events in a hierarchy to reflect the one or more dependencies of the query processing events;

format the visual presentation components representing the logging information of the method calls in a hierarchy to reflect the one or more dependencies of the method calls;

format the visual presentation components representing recursively called method calls as collapsible components;

present the visual presentation components representing the logging information of the query processing events in the context of the hierarchy of the visual components

present the visual presentation components that represent the method calls in the context of the hierarchy of the visual components; and

present the collapsible components such that methods at a given calling depth are visually presented.