초록 ▼

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 an

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.

대표청구항 ▼

[ What is claimed is:] [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 fro

[ What is claimed is:] [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; anddatabase monitor means for generating a result set which satisfies said tuple request comprising:means for reading said monitor information from said internal data structures, andmeans 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.