Utilizing pseudotables as a method and mechanism providing database monitor information
First Claim
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.
0 Assignments
0 Petitions
Accused Products
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.
-
Citations
20 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. - View Dependent Claims (2, 3, 4, 5)
-
-
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. - View Dependent Claims (7, 8)
-
-
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. - View Dependent Claims (10)
-
-
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. - View Dependent Claims (12, 13, 14, 15)
-
-
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. - View Dependent Claims (17, 18)
-
-
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. - View Dependent Claims (20)
-
Specification