MIT OpenCourseWare, 6.830 Database Systems, Fall 2010, Prof. Carlo Curino and Prof. Michael Stonebraker. Licensed CC BY-NC-SA 4.0. Reorganized into modules by Sequence 106. No lecture videos were published for this course; each session is notes plus readings. Source · CC BY-NC-SA 4.0
Module 5 · Recovery and consistency · Activity 17 of 32
Lecture 12: Recovery
Lecture notes · Michael Stonebraker
Readings and discussion questions
In this class, we will begin discussing ARIES and recovery. The Franklin paper assigned for Lec #10 includes a good summary of the essentials of the ARIES algorithm.
- Ramakrishnan and Gehrke. Database Management Systems. Read the section about crash recovery.
- (Optional) Mohan, C., et al. “ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging.” ACM Transactions on Database Systems 17, no. 1 (1992): 94-162. In the Red Book. Read sections 1-7, and skim sections 12 and 13 (long and difficult).
Assigned by MIT for this session; links go to the papers where MIT linked them. Books: Readings in Database Systems (the Red Book, 4th ed.) and Ramakrishnan & Gehrke.