Utilizing pseudotables as a method and mechanism providing database monitor information

Claim 3

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.

Claim 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 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.

Claim 5

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.

Claim 6

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.

Claim 7

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.

Claim 8

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.

Claim 9

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.

Claim 10

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.

Claim 11

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.

Claim 12

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.

Claim 13

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.

Claim 14

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.

Claim 15

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.

Claim 16

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.

Claim 17

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.

Claim 18

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.

Claim 19

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.

Claim 20

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.

Claim 21

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.

Claim 22

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.

Claim 23

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.

Claim 24

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.

Claim 25

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.

Claim 26

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.