Method for restoring a database after I/O error employing write-

Details Method for restoring a database after I/O error employing write- Method for restoring a database after I/O error employing write-

1988-04-08

1990-07-31

Lee, Thomas C.

Boots, shoes, and leggings

3642834, 3642655, 3642665, 3642469, G06F 1100, G06F 1540

Patent

active

049454749

ABSTRACT:
Method for reducing data loss during I/O errors and power failure during non-atomic writes to media in a transaction management system using write-ahead logging protocol. A recovery log is written during forward processing. On system restart processing, the log is traversed and a REDO executed. Recovery is effected from detected incomplete log writes or log write failures and uncommitted transactions are undone. A technique is provided in which files having I/O errors are identified, whereby subsequent restart operations are prevented from accessing these files. In one embodiment index files with such error are renamed, serving to indicate that corresponding original files contain errors, and the error index files are automatically rebuilt whereby I/O error on the files causes no data loss. The index file rebuild does not invalidate access plans related to the failed index.

REFERENCES:
patent: 3736566 (1973-05-01), Anderson et al.
patent: 4044337 (1977-08-01), Hicks et al.
patent: 4498145 (1985-02-01), Baker et al.
patent: 4507751 (1985-03-01), Gawlick et al.
patent: 4648031 (1987-03-01), Jenner
patent: 4686620 (1987-08-01), Ng
patent: 4697266 (1987-09-01), Finley
patent: 4751639 (1988-06-01), Corcoran et al.
patent: 4814971 (1989-03-01), Thatte
patent: 4815028 (1989-03-01), Saitoh
patent: 4819156 (1989-04-01), DeLorme et al.
"Data Recovery in IBM Database 2", R. Crus, IBM Systems Journal, vol. 23, No. 2, 1984, pp. 178-188.
"Minimizing Logging to Facilitate Recovery of Tablespace", IBM Technical Disclosure Bulletin, vol. 29, No. 8, Jan. 1987.

Affiliated with

Also associated with

Rating

Method for restoring a database after I/O error employing write- does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for restoring a database after I/O error employing write-, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for restoring a database after I/O error employing write- will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1402453