Problem 1
Discuss the different types of transaction failures. What is meant by catastrophic failure?
Problem 3
(Review from Chapter 17 ) What is the system log used for? What are the typical kinds of entries in a system log? What are checkpoints, and why are they important? What are transaction commit points, and why are they important?
Problem 5
What are the before image (BFIM) and after image (AFIM) of a data item? What is the difference between in-place updating and shadowing, with respect to their handling of BFIM and AFIM?
Problem 6
What are UNDO-type and REDO-type log entries?
Problem 7
Describe the write-ahead logging protocol.
Problem 9
What is meant by transaction rollback? What is meant by cascading rollback? Why do practical recovery methods use protocols that do not permit cascading rollback? Which recovery techniques do not require any rollback?
Problem 10
Discuss the UNDO and REDO operations and the recovery techniques that use each.
Problem 11
Discuss the deferred update technique of recovery. What are the advantages and disadvantages of this technique? Why is it called the NO-UNDO/REDO method?
Problem 13
Discuss the immediate update recovery technique in both single-user and multi user environments. What are the advantages and disadvantages of immediate update?
Problem 14
What is the difference between the UNDO/REDO and the UNDO/NO-REDO algorithms for recovery with immediate update? Develop the outline for an UNDO/NOREDO algorithm.