Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-08-29
2006-08-29
Alam, Shahid (Department: 2167)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C714S016000
Reexamination Certificate
active
07099897
ABSTRACT:
A system and an associated method selectively process log files for enhancing performance of tablespace recovery by processing only those log files required, and for selecting which log file to process during recovery for both redo and rollback phases of recovery. The system and method skip the processing of log files that do not contain records of interest for the tablespace being recovered and determines whether a log file contains anything that needs to be played, in particular for the recovery of a subsystem in the database, such as a tablespace. Pre processing of the log files is not done, rather including tablespace ID correlated with log file ID information is collected while the log files are created. The cross-correlated information is used during tablespace recovery to selectively determine which of the log files to process. Some log files may be skipped in cases where not all of the database system is being recovered. A sub set of the database can be recovered, such as a tablespace, and which log files to process is determined based on a lock instruction.
REFERENCES:
patent: 5638508 (1997-06-01), Kanai et al.
patent: 5850508 (1998-12-01), Lee et al.
patent: 5974425 (1999-10-01), Obermarck et al.
patent: 5983361 (1999-11-01), Lee et al.
patent: 6052695 (2000-04-01), Abe et al.
patent: 6078999 (2000-06-01), Raju et al.
patent: 6144999 (2000-11-01), Khalidi et al.
patent: 6175732 (2001-01-01), McDaniel et al.
patent: 6178427 (2001-01-01), Parker
patent: 6182241 (2001-01-01), Ngai et al.
patent: 6185577 (2001-02-01), Nainani et al.
patent: 6289355 (2001-09-01), Haderle et al.
patent: 6295610 (2001-09-01), Ganesh et al.
patent: 6578041 (2003-06-01), Lomet
patent: 2002/0007363 (2002-01-01), Vaitzblit
patent: 2361780 (2001-10-01), None
patent: 9319638 (1997-12-01), None
patent: 2000207265 (2000-07-01), None
Mohan et al., “Aries-RRH: Restricted Repeating of Hisotyr in the Aries Transaction Recovery Method,” Data Engineering, 7th int'l. Coference, IEEE, pp. 718-727.
Margo Seltzer, “Transaction Support in a Log-Structured File System,” Proceedings Ninth International Conference on Data Engineering, Apr. 19-23, 1993, Vienna, Austria, pp. 503-510.
Huras Matthew Albert
McInnis Dale Murray
Ofar Effi
Winer Michael Jeffrey
Zheng Roger LQ.
Alam Shahid
International Business Machines - Corporation
Kassatly Samuel A.
Koc Tarik
LandOfFree
System and method for discriminatory replaying of log files... 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 for discriminatory replaying of log files..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for discriminatory replaying of log files... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3656147