System and method for specifying custom qualifiers for explain tables

• US 6,493,700 B2
• Filed: 03/31/2000
• Issued: 12/10/2002
• Est. Priority Date: 10/14/1997
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Couch, Tanya, Lea, Joseph Davis III, Lai, Theresa Hsing, Drummond, Catherine Elizabeth Wuebker, Oberstadt, David Harold, Hughes, Virginia Walbridge Jr.
• Primary Examiner(s): ROBINSON, GRETA LEE
• Application Number:
  US09/540,838
• Publication Number:
  US 20020049700A1
• Time in Patent Office: 984 Days
• Field of Search: 707/1, 707/2, 707/4, 707/102, 707/104, 707/104.1
• US Class Current: 707/802
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A system and method for specifying custom qualifiers for explain tables allows a user to designate selected explain tables for which the user wishes to view statements. A query explain program is provided and configured with an explain table qualifier designation module for receiving a user designation of a query explain table to reference. The user selects a function of the query explain program to perform and then designates the qualifier of the query explain table to be referenced. The function is then performed in conjunction with the contents of the selected query explain table.

Claims

1. A method of accessing a user-selectable query explain table, the method comprising:

providing a query explain program configured to supplement a relational database management system (RDBMS) by providing a user with a further clarification of query explain data generated by an explain function of the RDBMS;

receiving within the query explain program a user selection of a high level qualifier; and

responding to the user selection of the high level qualifier by referencing query explain data associated with the high level qualifier without requiring the user to be logged in under the high level qualifier.

2. The method of claim 1, further comprising generating a query explain table and allowing a user to assign to the query explain table the high level qualifier.

3. The method of claim 1, wherein the query explain data is located within a query explain table selected from the group consisting of a plan table, a statement table, and a function table.

4. The method of claim 1, wherein referencing the query explain data comprises automatically referencing a query explain table in order to achieve a function of the query explain program.

5. The method of claim 4, wherein the function comprises graphically displaying query access path data to the user in order to make a query path more readily understandable to the user.

6. The method of claim 1, further comprising generating a graphical user interface (GUI) window accessible from the query explain program, the GUI window comprising a control mechanism for receiving the user selection of a high level qualifier.

7. The method of claim 1, wherein receiving a user selection of a high level qualifier comprises receiving a high level qualifier uniquely identifying a selected query explain table.

8. The method of claim 7, wherein the high level qualifier designates a maker of the query explain table.

9. An article of manufacture comprising a program storage medium readable by a processor and embodying one or more instructions executable by the processor to perform a method of accessing a user-selectable query explain table, the method comprising:

providing a query explain program configured to supplement a relational database management system (RDBMS) by providing a user with a further clarification of query explain data generated by an explain function of the RDBMS;

receiving within the query explain program a user selection of a high level qualifier; and

responding to the user selection of the high level qualifier by referencing query explain data associated with the high level qualifier without requiring the user to be logged in under the high level qualifier.

10. The article of manufacture of claim 9, further comprising generating a query explain table and allowing a user to assign to the query explain table the high level qualifier.

11. The article of manufacture of claim 9, wherein the query explain data is located within a query explain table selected from the group consisting of a plan table, a statement table, and a function table.

12. The article of manufacture of claim 9, wherein referencing the query explain data comprises automatically referencing a query explain table in order to achieve a function of the query explain program.

13. The article of manufacture of claim 9, wherein the method further comprises generating a graphical user interface window accessible from the query explain program, the window comprising a control mechanism for receiving the user designated high level qualifier.

14. The article of manufacture of claim 9, wherein receiving a user selection of a high level qualifier comprises receiving a high level qualifier uniquely identifying a selected query explain table.

15. The article of manufacture of claim 9, wherein the high level qualifier designates a maker of the query explain table.

16. A system for accessing a user-selectable query explain table, the system comprising:

a query explain program configured to operate remote to a relational database management system (RDBMS) and to assist a user in understanding query explain data generated by the RDBMS, the query explain program further configured to access one or more query explain tables generated by the RDBMS; and

an explain table qualifier designation module within the query explain program, the explain table qualifier designation module configured to receive a user designation of a selected query explain table to be accessed by the query explain program.

17. The system of claim 16, further comprising an explain table access module configured to access the selected query explain table in response to the user designation.

18. The system of claim 16, wherein the user designation of the selected query explain table comprises the designation of a high level qualifier uniquely identifying the selected query explain table.

19. The system of claim 18, wherein the high level qualifier identifies a maker of the explain table.

20. The system of claim 16, wherein the explain table qualifier designation module comprises a window accessible from the query explain program, the window comprising a control mechanism for receiving the user designation of a selected query explain table.

21. The system of claim 16, wherein the query explain table is selected from the group consisting of a plan table, a statement table, and a function table.

22. The system of claim 16, wherein the query explain table is configured to be accessed by the query explain program for a plurality of different functions, including graphically displaying query access path data to the user.