Query monitor playback mechanism for post-mortem performance...

Details Query monitor playback mechanism for post-mortem performance... Query monitor playback mechanism for post-mortem performance...

2005-09-13

2005-09-13

Robinson, Greta (Department: 2177)

Data processing: database and file management or data structures

Database design

Data structure types

Reexamination Certificate

active

06944614

ABSTRACT:
A method, apparatus, article of manufacture, and a memory structure for monitoring an executed query comprising at least one execution thread is disclosed. The method comprises the steps of executing the query; and while executing the query, storing an execution trace record for each execution thread in at least one execution log file. The execution trace record comprises execution trace information including a thread ID and a time stamp for the execution thread. The execution trace information can be recalled from the execution log file and presented to a user after execution of the query to allow post mortem analysis of the query. The article of manufacture comprises a program storage device tangibly embodying instructions for performing the method steps described above. The apparatus comprises a data server for executing the execution thread and for storing an execution trace record for the executed execution thread, the execution trace record having execution trace information including a thread identifier and a time stamp; a query coordinator for storing an execution plan having a time stamp and for retrieving and synchronizing the execution trace record and the execution plan; and a client process for displaying the retrieved execution trace information to a user after execution of the query.

REFERENCES:
patent: 4772966 (1988-09-01), Sharples et al.
patent: 5613113 (1997-03-01), Goldring
patent: 5625815 (1997-04-01), Maier et al.
patent: 5726913 (1998-03-01), Grimsrud
patent: 5857180 (1999-01-01), Hallmark et al.
patent: 5926813 (1999-07-01), Chaudhuri et al.
patent: 5978928 (1999-11-01), Rust
patent: 6021434 (2000-02-01), Pizano
patent: 6185575 (2001-02-01), Orcutt
patent: 6243702 (2001-06-01), Bamford et al.
patent: 6282701 (2001-08-01), Wygodny et al.
“Opt++: An Object-Oriented Design for Extensible Database Query Optimization” with David DeWitt, The VLDB Journal, vol. 8, Issue 1, Jan. 1999.

Affiliated with

Also associated with

Rating

Query monitor playback mechanism for post-mortem performance... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Query monitor playback mechanism for post-mortem performance..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Query monitor playback mechanism for post-mortem performance... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3390344