Multilevel transaction recovery in a database system which loss

Details Multilevel transaction recovery in a database system which loss Multilevel transaction recovery in a database system which loss

1991-07-11

1994-02-15

Lee, Thomas C.

Boots, shoes, and leggings

395425, 3642821, 3642814, 364974, 364DIG1, G06F 1540

Patent

active

052875016

ABSTRACT:
When a subtransaction (46) of a higher-level transaction (50) commits during the operation of a database (10), the database enters into its operation log a record (FIG. 6 ) that acts both as a commit record for the subtransaction (46) and as an update record for the higher-level transaction and includes a field (74) that identifies a higher-level "undo" transaction whereby the subtransaction can be undone without individually undoing its constituent operations. By logging operations in this manner, the database can handle multi-level recovery with very few restrictions on the timing of its updates and log entries.

REFERENCES:
patent: 4648031 (1987-03-01), Jenner
patent: 4819159 (1989-04-01), Shipley et al.
patent: 4868744 (1989-09-01), Reinsch et al.
patent: 4945474 (1990-07-01), Elliott et al.
patent: 5043866 (1991-08-01), Myre et al.
patent: 5095421 (1992-03-01), Freund
patent: 5155678 (1992-10-01), Fukumoto et al.
Shin, Dong C. and Moon, Song C., "An Efficient Log-Based Crash Recovery Scheme for Nested Transactions", Microprocessing and Microprogramming, vol. 31, Nos. 1-5, Apr. 1991, pp. 99-104.
Rothermel, K. and Mohan, C., "ARIES/NT: A Recovery Method Based on Write-Ahead Logging for Nested Transactions", Proceedings of the Fifteenth International Conference on Very Large Data Bases, Amsterdam, 1989.
Weikum, Gerhard; Hasse, Christof; Broessier, Peter; Muth, Peter, "Multi-Level Recovery", Proc. 9th Symposium on Principles of Database Systems (1990).
Pu, Calton and Noe, Jerre D., "Design and Implementation of Nested Transactions in Eden", IEEE, 1987.
Tripathi, Anand R. and Wang, Pong-Sheng, "An Object-Oriented Design Model for Reliable Distributed Systems", Proc. 3rd Symposium on Reliability in Distributed Software and Database Systems (Clearwater Beach, Oct. 17-19, 1983).

Affiliated with

Also associated with

Rating

Multilevel transaction recovery in a database system which loss does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Multilevel transaction recovery in a database system which loss , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Multilevel transaction recovery in a database system which loss will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1215087