Categories: All - backup - failure - techniques - durability

by Thu Tran 13 years ago

119

bai 13 mon thu 4

Databases require robust recovery mechanisms to maintain durability and integrity in the face of various failures, such as media failures, software issues, system crashes, natural disasters, unintentional destruction, and sabotage.

bai 13 mon thu 4

Database Recovery

Recovery Facilities

Reovery manager
Flush
Fetch
Backup
Logging
Information update

checkpoint records

Transaction records

After immedia

Before immedia

Main memory
Actions

Write

Read

Begin

Checkpoint

Failure cause

Media failure
Software failure
Unitentional destruction
Sabotage
Natural disasters
System Crashes

Transaction

Recovery manager
Durability
Automic

Recovery techniques

Shadow paging
Deferred update
Immedia (in place) update

Database types

Stable
Volatile