Method and apparatus for displaying instrumentation parameters in a database system

• US 6,978,272 B1
• Filed: 11/29/1999
• Issued: 12/20/2005
• Est. Priority Date: 11/29/1999
• Status: Expired due to Term

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation (NCR Voyix Corporation)
• Inventors: Ellmann, Curtis J., Yu, Jie-Bing
• Primary Examiner(s): Wong, Leslie
• Application Number:
  US09/450,463
• Time in Patent Office: 2,213 Days
• Field of Search: 707/2, 707/3, 707/202, 707/4, 707/101, 707/102, 707/203, 714/38, 717/4, 700/29, 700/108, 702/123
• US Class Current: 1/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

An instrumentation system for a database. A database management system contains instrumentation code which monitors behavior of the system, and stores parameters indicative of the behavior. Those stored parameters are copied into a second database, which is organized according to the same schema as the database itself. Both databases are searchable using the same query language, so that a system administrator can locate (1) data within the database and (2) diagnostic information about the system using a single search tool.

Claims

1. Apparatus, comprising:

a) a computer system which stores a main database, the main database being organized according to a schema;

b) database management software which

i) runs queries on the main database, and

ii) contains instrumentation code which

A) performs examinations of the computer system, the main database, or both, and

B) generates status data, based on the examinations;

c) a status database which

i) stores the status data, and

ii) is organized according to said schema,

wherein the database management software is able to run queries against both the main database and the status database;

wherein said status data includes information identifying pinned records; and

wherein a pinned record contains a pointer to another record, and the system does not delete a pinned record without saving the pointer.

2. Apparatus according to claim 1, wherein

d) the computer system includes multiple computers, each running a type of software;

and

e) the instrumentation code derives status data for one, or more, types of the software, which status data includes one or more of the following items of information;

i) instance number of the software,

ii) version number of the software,

iii) date of issue of the software, and

iv) serial number of the software.

3. Apparatus according to claim 1, wherein the status data includes one or more of the following types of information:

d) number of pinned records in the main database; and

e) a list of pinned records.

4. Apparatus according to claim 1, wherein the status data includes information indicating whether data contained in buffers in the system are consistent with copies of the data located outside buffers.

5. Apparatus according to claim 1, wherein

d) the main database is stored in permanent storage, and copies of some, or all, of the main database is loaded into volatile memory during use;

c) the status data is not stored in permanent storage, but only in volatile memory.

6. Apparatus according to claim 1, wherein

d) the instrumentation code performs examinations at different times, thereby generating a set of status data for each time;

and

e) each set of status data is assigned a time stamp, and stored in permanent storage.

7. Apparatus according to claim 6, wherein each time stamp occupies a period field, thereby allowing the database management system to retrieve a set of status data, based on a time stamp.

8. Method, comprising:

a) maintaining a computer system and a main database stored therein, the main database being organized according to a schema;

b) maintaining database management software

i) which runs queries on the main database, and

ii) which contains instrumentation code which

A) performs examinations of the computer system, the main database, or both, and

B) based on the examinations, generates status data;

c) maintaining a status database which

i) stores the status data, and

ii) is organized according to said schema,

wherein the database management software is able to run queries against both the main database and the status databases

wherein said status data includes information identifying pinned records; and

wherein a pinned record contains a pointer to another record, and the system does not delete a pinned record without saving the pointer.

9. Method according to claim 8, wherein

d) the computer system includes multiple computers, each running a type of software;

and

e) the instrumentation code derives status data for one, or more, types of the software, which status data includes one or more of the following information;

i) instance number of the software,

ii) version number of the software,

iii) date of issue of the software, and

iv) serial number of the software.

10. Method according to claim 8, wherein the status data includes one or more of the following types of information:

d) number of pinned records in the main database;

e) a list of pinned records.

11. Method according to claim 8, wherein the status data includes information indicating whether data contained in buffers in the system are consistent with copies of the data located outside buffers.

12. Method according to claim 8, wherein

d) the main database is stored in permanent storage, and copies of some, or all, of the main database is loaded into volatile memory during use;

c) the status data is not stored in permanent storage, but only in volatile memory.

13. Method according to claim 8, wherein

d) the instrumentation code performs examinations at different times, thereby generating a set of status data for each time;

and

e) each set of status data is assigned a time stamp, and stored in permanent storage.