Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-11-12
2009-02-17
Chace, Christian P. (Department: 2165)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
07493304
ABSTRACT:
In an embodiment, a problem record associated with a query is saved to a log if the query encountered a problem. The amount of data in the record is increased if an access plan associated with the query has changed within a threshold amount of time and decreased if the access plan has not changed. In various embodiments, the problem is that the query executes longer than a historical average for the query, the query executes longer than a threshold, or the query encounters a functional error. In an embodiment, a benchmark record is also saved to the log, the problem record is compared to the benchmark record, and the difference is presented. In various embodiments, an oldest record is periodically removed from the log, or an oldest record is removed from the log if the associated query has more than a threshold number of records.
REFERENCES:
patent: 5857188 (1999-01-01), Douglas
patent: 6092099 (2000-07-01), Irie et al.
patent: 7127456 (2006-10-01), Brown et al.
patent: 7185000 (2007-02-01), Brown et al.
patent: 7194451 (2007-03-01), Chaudhuri et al.
patent: 2002/0198867 (2002-12-01), Lohman et al.
patent: 2003/0065648 (2003-04-01), Driesch et al.
patent: 2003/0088579 (2003-05-01), Brown et al.
patent: 2004/0049423 (2004-03-01), Kawashima et al.
patent: 2004/0122925 (2004-06-01), Offermann
Day Paul Reuben
Muras Brian Robert
Ryg Anne Marie
Chace Christian P.
Gamon Owen J.
Hoang Son T
International Business Machines - Corporation
LandOfFree
Adjusting an amount of data logged for a query based on a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Adjusting an amount of data logged for a query based on a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Adjusting an amount of data logged for a query based on a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4117665