Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-04-03
2007-04-03
Gaffin, Jeffrey (Department: 2161)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
10274469
ABSTRACT:
An enhanced method of reorganizing a relational database is provided. The method uses batch processing to perform the steps of providing an online database having a plurality of authoritative data stored there within; running the online database in an archive log mode for storing archival data capable of restoring all online database activity since running the online database in the archival mode; creating an off-line database by copying the plurality of authoritative data stored within the online database to the off-line database; performing a maintenance operation on the off-line database; taking the online database offline upon completion of the performance of the maintenance operation; copying the plurality of archival data from the online database to the off-line database when the online database is taken offline; recovering the off-line database by applying the copied plurality of archival data copied from the online database; and converting the off-line database to an online database.
REFERENCES:
patent: 6035412 (2000-03-01), Tamer et al.
patent: 6411964 (2002-06-01), Iyer et al.
patent: 6578041 (2003-06-01), Lomet
patent: 6658589 (2003-12-01), Taylor
patent: 6732123 (2004-05-01), Moore et al.
patent: 6820098 (2004-11-01), Ganesh et al.
patent: 6957221 (2005-10-01), Hart et al.
patent: 2002/0103816 (2002-08-01), Ganesh et al.
patent: 2003/0005120 (2003-01-01), Mutalik et al.
patent: 2003/0093443 (2003-05-01), Huxoll
patent: 2003/0115145 (2003-06-01), Lee et al.
patent: 2003/0135478 (2003-07-01), Marshall et al.
patent: 2003/0172158 (2003-09-01), Pillai et al.
patent: 2004/0003003 (2004-01-01), McCartney et al.
Chiang Ta-Jen
Lin Chun-Ching
Gaffin Jeffrey
Nguyen Cindy
Taiwan Semiconductor Manufacturing Co. Ltd.
Thomas Kayden Horstemeyer & Risley
LandOfFree
System and method to enhance availability of a relational... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method to enhance availability of a relational..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method to enhance availability of a relational... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3807442