Database system providing self-tuned parallel database recovery

Details Database system providing self-tuned parallel database recovery Database system providing self-tuned parallel database recovery

2004-08-09

2008-11-04

Vo, Tim (Department: 2168)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C718S100000, C718S104000

Reexamination Certificate

active

07447710

ABSTRACT:
A database system providing self-tuned parallel database recovery is described. In one embodiment, for example, in a database system, a method is described for performing recovery operations using an optimal number of recovery threads, the method comprises steps of: (a) spawning an initial recovery thread to perform recovery operations; (b) measuring I/O (input/output) performance with the initial recovery thread; (c) spawning a subsequent recovery thread to perform recovery operations; (d) measuring I/O performance with the subsequent recovery thread; and (e) as long as I/O performance does not degrade beyond a preselected percentage, repeating steps (c) and (d) for spawning a desired number of additional recovery threads. In another embodiment, the database system auto-tunes the cache during performance of database recovery operations to optimize the performance of recovery operations.

REFERENCES:
patent: 5280611 (1994-01-01), Mohan et al.
patent: 5414840 (1995-05-01), Rengarajan et al.
patent: 5446884 (1995-08-01), Schwendemann et al.
patent: 5499367 (1996-03-01), Bamford et al.
patent: 5530855 (1996-06-01), Satoh et al.
patent: 5553303 (1996-09-01), Hayashi et al.
patent: 5561795 (1996-10-01), Sarkar
patent: 5561798 (1996-10-01), Haderle et al.
patent: 5581750 (1996-12-01), Haderle et al.
patent: 5596706 (1997-01-01), Shimazaki et al.
patent: 5668991 (1997-09-01), Dunn et al.
patent: 5682527 (1997-10-01), Cooper et al.
patent: 5717921 (1998-02-01), Lomet et al.
patent: 5721918 (1998-02-01), Nilsson et al.
patent: 5778387 (1998-07-01), Wilkerson et al.
patent: 5857180 (1999-01-01), Hallmark et al.
patent: 5933838 (1999-08-01), Lomet
patent: 5956504 (1999-09-01), Jagadish et al.
patent: 5974425 (1999-10-01), Obermarck et al.
patent: 6018746 (2000-01-01), Hill et al.
patent: 6065017 (2000-05-01), Barker
patent: 6065018 (2000-05-01), Beier et al.
patent: 6078930 (2000-06-01), Lee et al.
patent: 6081906 (2000-06-01), Nishizawa et al.
patent: 6151607 (2000-11-01), Lomet
patent: 6161198 (2000-12-01), Hill et al.
patent: 6185699 (2001-02-01), Haderle et al.
patent: 6202071 (2001-03-01), Keene
patent: 6208918 (2001-03-01), Ando et al.
patent: 6247023 (2001-06-01), Hsiao et al.
patent: 6377959 (2002-04-01), Carlson
patent: 6411968 (2002-06-01), Bamford et al.
patent: 6449623 (2002-09-01), Bohannon et al.
patent: 6457142 (2002-09-01), Klemm et al.
patent: 6490594 (2002-12-01), Lomet
patent: 6507853 (2003-01-01), Bamford et al.
patent: 6526417 (2003-02-01), Perry
patent: 6567928 (2003-05-01), Lyle et al.
patent: 6594676 (2003-07-01), Moore
patent: 6609136 (2003-08-01), Bamford et al.
patent: 6618822 (2003-09-01), Loaiza et al.
patent: 6651073 (2003-11-01), Lyle et al.
patent: 6651077 (2003-11-01), East et al.
patent: 6658589 (2003-12-01), Taylor
patent: 6684225 (2004-01-01), Huras et al.
patent: 6721739 (2004-04-01), Mende et al.
patent: 6732123 (2004-05-01), Moore et al.
patent: 6751636 (2004-06-01), Mende et al.
patent: 6769074 (2004-07-01), Vaitzblit
patent: 6799189 (2004-09-01), Huxoll
patent: 6820217 (2004-11-01), Mock et al.
patent: 6886021 (2005-04-01), Pal et al.
patent: 6889159 (2005-05-01), Klotz et al.
patent: 7007200 (2006-02-01), Salem
patent: 7028303 (2006-04-01), Lahey et al.
patent: 7047309 (2006-05-01), Baumann et al.
patent: 7207043 (2007-04-01), Blythe et al.
patent: 7237242 (2007-06-01), Blythe et al.
patent: 2003/0177179 (2003-09-01), Jones et al.
patent: 2004/0015762 (2004-01-01), Klotz et al.
patent: 2004/0024921 (2004-02-01), Peake et al.
Schmidt et al, “Alleviating Priority Inversion and Non-determinism in Real-time CORBA ORB Core Architectures”, IEEE Realtime Technology and Applications Symposium (RTAS), Denver, Colorado, Jun. 3-5, 1998.
American National Standards Institute, Information Technology—Database languages—SQL (Ch 4), American National Standard ANSI/ISO/IEC 9075; 1992.
Date, C.J., An Introduction to Database Systems, Ch 1: Overview of Database Management, vol. 1, 5th Ed., 1990.

Affiliated with

Also associated with

Rating

Database system providing self-tuned parallel database recovery does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database system providing self-tuned parallel database recovery, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database system providing self-tuned parallel database recovery will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4037356