1 / 10

Database Recovery Techniques and Concepts

Learn about recovery algorithms, disk block caching, write-ahead logging, checkpoints, rollback and immediate update-based recovery techniques, and more.

frencha
Download Presentation

Database Recovery Techniques and Concepts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 19 Database Recovery Techniques

  2. Recovery Concepts • Recovery Outline and Categorization of Recovery Algorithms • Caching (Buffering) of Disk Blocks • Write-Ahead Logging, Steal/No-Steal, and Force/No-Force • Checkpoints in the System Log and Fuzzy Checkpointing • Transaction Rollback

  3. Recovery Techniques Based on Deferred Update • Recovery Using Deferred Update in a Single-User Environment • Deferred Update with Concurrent Execution in a Multiuser Environment • Transaction Actions That Do Not Affect the Database

  4. Recovery Techniques Based on Immediate Update • UNDO/REDO Recovery Based on Immediate Update in a Single-User Environment • UNDO/REDO Recovery Based on Immediate Update with Concurrent Execution

  5. Shadow Paging

  6. The ARIES Recovery Algorithm

  7. Recovery in Multidatabase Systems

  8. Database Backup and Recovery from Catastrophic Failures

  9. Summary

More Related