QUERY PROCESSING VISUALIZATION SYSTEM AND METHOD OF VISUALIZING QUERY PROCESSING

• US 20090265324A1
• Filed: 04/16/2008
• Published: 10/22/2009
• Est. Priority Date: 04/16/2008
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: Cognos ULC (International Business Machines Corporation)
• Inventors: AZIZI, SOUFIANE, MORDVINOV, VLADIMIR
• Granted Patent: US 8,122,050 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• 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 visualization module 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 for analyzing the logging information to identify dependency of the query processing events;

an event sequence formatter for formatting visual presentation components representing the logging information in a hierarchy to reflect the dependency of the query processing events; and

a method call presentation handler for presenting the visual presentation components in a context of the hierarchy of the visual components as formatted by the event sequence formatter.

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

the logging information analyzer analyzes logging information of method calls corresponding to main query processing events and identifies dependency of the method calls;

the event sequence formatter formats the visual presentation components in a hierarchy to reflect the dependency of the method calls; and

the method call presentation handler presents the visual presentation components that represents method calls in a context of the hierarchy of the visual presentation components.

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

the logging information analyzer analyzes the logging information to identify recursive dependency of the method calls;

the event sequence formatter comprises a recursive dependency handler for formatting the visual presentation components representing recursively called method calls as collapsible components; and

the method call presentation handler presents the collapsible components so that the methods at a given calling depth are visually presented.

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

5. The query processing visualization system as recited in claim 2, wherein

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

and

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

6. The query processing visualization system as recited in claim 5, wherein the process information includes an elapse time and/or memory consumption of the method call.

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

8. The query processing visualization system as recited in claim 2, wherein the method call presentation handler comprises a component label handler for labeling 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.

9. The query processing visualization system as recited in claim 2, wherein

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

and

the method call presentation handler has a parameter information adder for adding to a visual component representing the method call an access to the parameter information of the method call.

10. The query processing visualization system as recited in claim 9, wherein the parameter information adder adds an input parameter access, an output parameter access, and/or a return parameter access.

11. The query processing visualization system as recited in claim 9, wherein the parameter information handler has a macro operation tree handler for 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.

12. The query processing visualization system as recited in claim 11, wherein the macro operations include a query result definition, query and/or provider query.

13. The query processing visualization system as recited in claim 11, wherein the method call presentation handler has an execute option handler for allowing execution of the query framework query and for presenting a view containing query results of the execution.

14. The query processing visualization system as recited in claim 11, wherein the macro operation tree handler has a macro operation details handler for exposing a structure of the macro operations that completes definition of the macro operations in a predetermined format.

15. 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 consisting of 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.

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

an event capturer for capturing query processing events occurring during the processing of the client query;

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

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

17. A method of visualizing query processing, the method comprising the steps of:

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 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 a context of the hierarchy of the visual components as formatted by the formatting step.

18. The method as recited in claim 17, wherein

the analyzing step analyzes logging information of method calls corresponding to main query processing events and identifies dependency of the method calls;

the formatting step formats the visual presentation components in a hierarchy to reflect the dependency of the method calls; and

the presenting step presents the visual presentation components that represents method calls in a context of the hierarchy of the visual components.

19. The method as recited in claim 18, wherein

the analyzing step identifies recursive dependency of the method calls;

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

the presenting step presents the collapsible components so that the methods at a given calling depth are visually presented.

20. The method as recited in claim 18, wherein the presenting step allows opening a tree of macro operations representing a method that has transformed a structure of the tree.

21. The method as recited in claim 18, wherein

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

and

the presenting step adds the process information to a visual component representing the method call.

22. The method as recited in claim 21, wherein the presenting step adds an elapse time and/or memory consumption of the method call.

23. The method as recited in claim 18, wherein the formatting step labels 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.

24. The method as recited in claim 18, wherein

the analyzing step extracts logging information including parameter information of a method call;

and

the presenting step adds to a visual component representing the method call an access to the parameter information of the method call.

25. The method as recited in claim 24, wherein the parameter information adding step presents 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.

26. The method as recited in claim 25, wherein the macro operation tree presenting step provides an execute option for allowing execution of the query framework query and for presenting a view containing query results of the execution.

27. The method as recited in claim 17, wherein

the analyzing step obtains 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;

the formatting step formats visual presentation components representing the executable macro operations to represent the query execution plan; and

the presenting step presents the visual presentation components for validation of the execution plan.

28. The method as recited in claim 17 further comprising the step of 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.

29. A computer readable medium containing computer executable instructions that can be read and executed by a computer for caring out a method of visualizing query processing, the method comprising the steps of:

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 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 a context of the hierarchy of the visual components as formatted by the formatting step.