Tracking table and index partition usage in a database

Details Tracking table and index partition usage in a database Tracking table and index partition usage in a database

2008-08-07

2011-11-01

Chen, Susan (Department: 2154)

Data processing: database and file management or data structures

Data integrity

Index maintenance

C707S688000, C707S711000, C715S721000

Reexamination Certificate

active

08051055

ABSTRACT:
Apparatus, methods and computer-readable medium for displaying information related to performance of a given database statement which accesses a plurality of multi-partition objects during a time interval. In some embodiments, the method comprises: a) determining, for a given database statement that accesses a plurality of index or table partitions during the time interval, for each accessed partition of a plurality of partitions, a respective aggregate wait time associated with said accessed partition; b) in accordance with the determined wait times for the given database statement, presenting, to a user, a description of performance of the database during the time interval.

REFERENCES:
patent: 7376682 (2008-05-01), Ramacher et al.
patent: 7673291 (2010-03-01), Dias et al.
patent: 2004/0169654 (2004-09-01), Walker et al.
patent: 2005/0086246 (2005-04-01), Wood et al.
patent: 2007/0118730 (2007-05-01), Platt

Affiliated with

Also associated with

Rating

Tracking table and index partition usage in a database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Tracking table and index partition usage in a database, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Tracking table and index partition usage in a database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4261934