Design of Main Memory Database System/Recovery

• Checkpointing
• Fault Tolerance
• Preventing Data Corruption

Recovery in DBMS means recovering the database. That is restoring the database to a state that is known to be consistent after some failure that makes the database inconsistent.

There are many things which can go wrong in a database environment. The following sections discuss about most important failure modes

1. Hard Disk Failure
2. Process Failure - software errors
3. System Failure - power loss