Utilizing pseudotables as a method and mechanism providing database monitor information

• US 5,953,715 A
• Filed: 11/03/1997
• Issued: 09/14/1999
• Est. Priority Date: 08/12/1994
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Li, Margaret H., Schiefer, K. Bernhard, Cincinatus, Michael J., Boivin, Serge, Hedges, Richard W.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Coby, Frantz
• Application Number:
  US08/999,920
• Time in Patent Office: 680 Days
• Field of Search: 707/1, 707/3, 707/4, 707/5
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

Abstract

A method for externalizing database monitor information, and a database management system incorporating the method, which utilizes the database system'"'"'s own data manipulation and retrieval system is disclosed. Monitor information is logically available in pseudotable form which may be accessed as any other data. However pseudotables do not actually exist; rather the result set is constructed when a request is made to select from a pseudotable. A predefined format for each pseudotables is stored in the database catalog tables and is used in constructing the tuples from existing internal data structures which are constantly updated with monitor data.

Claims

1. A method of providing a requesting application with monitor information which is automatically tracked by a database management system in internal data structures, said database management system having data manipulating components, comprising the steps of:

providing a query for said monitor information;

accessing access information on how to retrieve said monitor information, said access information including a predefined format for organizing said monitor information;

utilizing said access information to construct tuples of monitor information, according to said predefined format, from said internal data structures, said step of utilizing comprising the steps of;

creating a temporary table for holding said tuples, said temporary table being organized according to said predefined format;

reading said monitor information from said internal data structures;

organizing said monitor information into tuples according to said predefined format; and

inserting each tuple into said temporary table.

2. The method as claimed in claim 1 further comprising the step of utilizing said database management system'"'"'s data manipulating components for outputting and manipulating said constructed tuples.

3. The method as claimed in claim 2 wherein said database management system further comprises a relational layer for manipulating tuples, and said step of utilizing the database management system'"'"'s data manipulating components for outputting and manipulating said constructed tuples comprises the steps of:

fetching each one of said tuples from said temporary table and returning each one of said tuples to said relational layer;

ensuring said tuples satisfy said query; and

returning said tuples to said requesting application which provided said query.

4. The method as claimed in claim 2 wherein said database management system further comprises a relational layer for manipulating tuples, and said step of utilizing the database management system'"'"'s data manipulating components for outputting and manipulating the constructed tuples comprises the steps of:

fetching each one of said tuples from said temporary table and returning each one of said tuples to said relational layer;

processing said returned tuples to ensure said returned tuples satisfy said query; and

returning said processed tuples to said requesting application which provided said query.

5. The method as claimed in claim 1, wherein said query is in the form of a select from a pseudotable, said pseudotable being an entry in the database management system catalog tables, wherein said access information for said pseudotable provides information on a location and a predefined format for said pseudotable, and wherein said step of accessing access information comprises the step of searching said system catalog tables for said entry for said pseudotable.

6. A database management system capable of providing monitor information in table form to a requesting application, said database management system comprising:

means for storing and updating said monitor information in internal data structures;

means for processing a query from said requesting application;

catalog means for storing access information on how to access said monitor information, said access information including a predefined format for organizing said monitor information;

means for searching said catalog means for said access information;

relational means for processing tuples and returning said tuples to said requesting application comprising means for using said access information to formulate a tuple request, said tuple request including said predefined format for said tuples to be returned and their location;

internal data structures which said database management system updates with said monitor information;

data manager means for building and managing temporary tables; and

database monitor means for generating a result set which satisfies said tuple request comprising;

means for reading said monitor information from said internal data structures, and

means for organizing aid monitor information into tuples according to said predefined format, said database monitor means further comprising means for utilizing said data manager means to construct and store said temporary tables which are filled with tuples constructed by said database monitor means.

7. The database management system as claimed in claim 6 wherein said relational means further comprises interface means for fetching tuples from said database monitor means, and wherein said database monitor means is adapted to interface with both said relational means and said data manager means in response to a fetch for a tuple generated by said interface means.

8. The database management system as claimed in claim 6 wherein said relational means comprises interface means for fetching tuples directly from said data manager means.

9. A monitoring mechanism for providing monitor information in table form for use with a database management system having means for accepting and processing queries, catalog tables, and internal data structures which said database management system updates with monitor information and for use with a database management system which further includes a relational layer for processing tuples and returning said tuples to a requesting application, and a data manager means for constructing and managing temporary tables, said monitoring mechanism comprising:

means for updating said catalog tables to provide access information for tables of monitor information, including a predefined format for said tables;

means for updating said relational layer to interface with a database monitor means, by sending tuple requests, which include said predefined format, to said database monitor means, upon execution of a query for said monitor information; and

said database monitor means, which utilizes said access information for organizing said monitor information in table form, said database monitor means further comprising;

means for reading said monitor information from said internal data structures;

means for organizing said monitor information into tuples according to said predefined format;

means for interfacing with said relational layer, including means for accepting said tuple requests; and

means for interfacing with said data manager means in order to create a temporary table for the tuples generated by said database monitor means.

10. The monitoring mechanism as claimed in claim 9, wherein said database monitor means for interfacing with said relational layer further comprises means for returning a returned tuple to said relational layer in response to each fetch request received from said relational layer, said returned tuple obtained from said temporary table by said means for interfacing with said data manager means.

11. An article of manufacture for use in a computer system for a requesting application with database monitor information which is automatically tracked by a database management system in internal data structures, said article of manufacture comprising a computer-readable storage medium having a computer program code embodied in said medium which may cause the computer to:

provide a query for particular monitor information;

access access information on how to retrieve said monitor information, said access information including a predefined format for organizing said monitor information; and

utilize said access information to construct tuples of monitor information, according to said predefined format, from said internal data structures by causing the computer to;

read said monitor information from said internal data structures;

organize said monitor information into tuples according to said predefined format;

create a temporary table for holding said tuples, said temporary table being organized according to said predefined format;

read said monitor information from said internal data structures;

organize said monitor information into tuples according to said predefined format; and

insert each tuple into said temporary table.

12. The article of manufacture of claim 11 wherein the computer program code may cause the database management system to utilize said database management system'"'"'s data manipulating components for outputting and manipulating said constructed tuples.

13. The article of manufacture of claim 12 wherein said database management system comprises a relational layer for manipulating tuples, and wherein the computer program code may cause said system to utilize said system'"'"'s data manipulating components for outputting and manipulating said constructed tuples by causing said system to:

fetch each one of said tuples from said temporary table and return each one of said tuples to said relational layer;

ensure said tuples satisfy said query; and

return said tuples to said requesting application which provided said query.

14. The article of manufacture of claim 12 wherein said database management system further comprises a relational layer for manipulating tuples, and wherein the computer program code may cause said system to utilize said system'"'"'s data manipulating components for outputting and manipulating said constructed tuples by causing the computer to:

fetch each one of said tuples from said temporary table and return each one of said tuples to said relational layer;

process said returned tuples to ensure said returned tuples satisfy said query; and

return said processed tuples to said requesting application which provided said query.

15. The article of manufacture of claim 11 wherein said query is in the form of a select from a pseudotable, said pseudotable being an entry in the database management system catalog tables, wherein said access information for said psuedotable provides information on a location and a predefined format for said pseudotable, and wherein the computer program code may cause said system to access access information by causing said system to search said system catalog tables for said entry for said pseudotable.

16. An article of manufacture for use in a database management system capable of providing monitor information in table form to a requesting application, said article of manufacture comprising a computer-readable storage medium having a computer program code embodied in said medium which may cause said database management system to:

store and update said monitor information in internal data structures;

process a query from said requesting application;

store, in a catalog, access information on how to access said monitor information, said access information including a predefined format for organizing said monitor information;

search said catalog for said access information;

cause a relational layer to process tuples and return said tuples to said requesting application by causing the computer to use said access information to formulate a tuple request, said tuple request including said predefined format for said tuples to be returned and their location;

update internal data structures with monitor information;

generate a result set which satisfies said tuple request by causing a database monitor to read said monitor information from said internal data structures, and to organize said monitor information into tuples according to said predefined format;

build and manage temporary tables by a data manager; and

cause said database monitor to utilize said data manager to construct and store said temporary tables which are filled with tuples constructed by said database monitor.

17. The article of manufacture of claim 16 wherein the computer program code may cause the relational layer to fetch tuples from said database monitor, and wherein said database monitor is adapted to interface with both said relational layer and said data manager in response to a fetch for a tuple generated by said interface.

18. The article of manufacture of claim 16 wherein the computer program code may cause the relational layer to fetch tuples, through an interface, directly from said data manager.

19. An article of manufacture for use in a monitoring mechanism for providing monitor information in table form for use with a database management system capable of accepting and processing queries, said database management system having catalog tables and internal data structures which said database management system updates with monitor information, said database management system further including a relational layer for processing tuples and returning said tuples to a requesting application and a data manager for constructing and managing temporary tables, said article of manufacture comprising a computer-readable storage medium having a computer program code embodied in said medium which may cause the monitoring mechanism to:

update said catalog tables to provide access information for tables of monitor information, including a predefined format for said tables;

update said relational layer to interface with a database monitor, by sending tuple requests, which include said predefined format, to said database monitor, upon execution of a query for said monitor information;

and wherein said computer program may further cause the database monitor to;

utilize said access information for organizing said monitor data in table form;

read said monitor information from said internal data structures;

organize said monitor information into tuples according to said predefined format;

interface with said relational layer, including accepting said tuple requests; and

interface with said data manager in order to create a temporary table for the tuples generated by said database monitor.

20. The article of manufacture of claim 19 wherein the computer program code may cause said database monitor to interface with said relational layer to return a returned tuple to said relational layer in response to each fetch request received from said relational layer, said returned tuple obtained from said temporary table by causing the database monitor to interface with the data manager.