Method and System for Storing Trace Events in a Database Table

• US 20080016500A1
• Filed: 07/17/2006
• Published: 01/17/2008
• Est. Priority Date: 07/17/2006
• Status: Active Grant

• Current Assignee: CA, Inc. (d/b/a CA Technologies) (Broadcom, Inc.)
• Original Assignee: Computer Associates Think Inc. (Broadcom, Inc.)
• Inventors: Morrison, Charles, Hinkley, Paul A.
• Granted Patent: US 8,413,121 B2
• Time in Patent Office: Days
• US Class Current: 717/128
• CPC Class Codes: G06F 11/3476 Data logging G06F11/14, G06F11/2205 take precedence
• CPC Class Codes: G06F 2201/86 Event-based monitoring

Abstract

According to one embodiment, a method for storing trace events in a database table includes reading a group of parameters from the table. The group of parameters includes parameters indicative of the maximum number of records, the most recently added record, and the total number of records in the table. The method further includes receiving a trace event. The method also includes storing the trace event as a record in the table based on the group of parameters. The method further includes updating the group of parameters before receiving the next trace event.

Claims

1. A method for storing trace events in a database table, comprising:

reading a plurality of parameters from the table, the plurality of parameters comprising a parameter indicative of the maximum number of records, a parameter indicative of the most recently added record, and a parameter indicative of the total number of records;

receiving a first trace event;

generating a record number based on the plurality of parameters;

storing the first trace event as a record in the table at the record number based on the plurality of parameters;

updating the plurality of parameters before receiving a second trace event; and

displaying a plurality of records corresponding to a selected type of trace information and a selected time range.

2. A method for storing trace events in a database table, comprising:

reading a plurality of parameters from the table, the plurality of parameters comprising a parameter indicative of the maximum number of records in the table, a parameter indicative of the most recently added record in the table, and a parameter indicative of the total number of records in the table;

receiving a first trace event;

storing the first trace event as a record in the table based on the plurality of parameters; and

updating the plurality of parameters before receiving a second trace event.

3. The method of claim 2, wherein storing the first trace event as a record comprises:

generating a record number based on the parameter indicative of the most recently added record in the table; and

adding the record to the table at the record number.

4. The method of claim 2, wherein storing the first trace event as a record comprises:

generating a record number based on the parameter indicative of the maximum number of records in the table and the parameter indicative of the most recently added record in the table; and

replacing an existing record with the record at the record number.

5. The method of claim 2, further comprising resizing the table by updating the parameter indicative of the maximum number of records in the table.

6. The method of claim 2, further comprising displaying a plurality of records corresponding to a selected type of trace information and a selected time range.

7. The method of claim 2, further comprising clearing the table by updating the parameter indicative of the maximum number of records in the table.

8. The method of claim 2, wherein the database table comprises a relational database table with standardized I/O routines.

9. A computer system, comprising:

a processor; and

a storage device readable by the computer system, embodying a program of instructions executable by the processor to perform method steps for storing trace events in a database table, the method steps comprising;

reading a plurality of parameters from the table, the plurality of parameters comprising a parameter indicative of the maximum number of records in the table, a parameter indicative of the most recently added record in the table, and a parameter indicative of the total number of records in the table;

receiving a first trace event;

storing the first trace event as a record in the table based on the plurality of parameters; and

updating the plurality of parameters before receiving a second trace event.

10. The computer system of claim 9, wherein the step of storing the first trace event as a record in the table comprises:

generating a record number based on the parameter indicative of the most recently added record in the table; and

adding the record to the table at the record number.

11. The computer system of claim 9, wherein the step of storing the first trace event as a record in the table comprises:

generating a record number based on the parameter indicative of the maximum number of records in the table and the parameter indicative of the most recently added record in the table; and

replacing an existing record with the record at the record number.

12. The computer system of claim 9, wherein the method steps further comprise resizing the table by updating the parameter indicative of the maximum number of records in the table.

13. The computer system of claim 9, wherein the method steps further comprise displaying a plurality of records corresponding to a selected type of trace information and a selected time range.

14. The computer system of claim 9, wherein the method steps further comprise clearing the table by updating the parameter indicative of the maximum number of records in the table.

15. Logic encoded in media, the logic being operable to:

read a plurality of parameters from the table, the plurality of parameters comprising a parameter indicative of the maximum number of records in the table, a parameter indicative of the most recently added record in the table, and a parameter indicative of the total number of records in the table;

receive a first trace event;

store the first trace event as a record in the table based on the plurality of parameters; and

update the plurality of parameters before receiving a second trace event.

16. The logic of claim 15, wherein the logic operable to store the first trace event as a record in the table comprises the logic operable to:

generate a record number based on the parameter indicative of the most recently added record in the table; and

add the record to the table at the record number.

17. The logic of claim 15, wherein the logic operable to store the first trace event as a record in the table comprises the logic operable to:

generate a record number based on the parameter indicative of the maximum number of records in the table and the parameter indicative of the most recently added record in the table; and

replace an existing record with the record at the record number.

18. The logic of claim 15, further operable to resize the table by updating the parameter indicative of the maximum number of records in the table.

19. The logic of claim 15, further operable to display a plurality of records corresponding to a selected type of trace information and a selected time range.

20. The logic of claim 15, further operable to clear the table by updating the parameter indicative of the maximum number of records in the table.