Recovery control

Recovery control

1. ACID

   • Atomicity
   • Consistency
   • Isolation
   • Durability

2. Transactions

3. Schedules

   • Recoverable
   • Cascadeless

4. Storage types

   • Volatile
   • Non volatile
   • Stable

5. Indempotent

6. Buffer management

   • Input
   • Output

7. Logging

   • Immediate
   • Deferred

8. Log record

   • <tid,start>
   • <tid,item,old,new>
   • <tid,commit> Actual commit time
   • <tid,rollback>

9. Shadow paging

10. Checkpoint

    • fuzzy

11. Operations

    • Redo
    • Undo