Reference Work Entry

Encyclopedia of Database Systems

pp 1643-1644

Logging and Recovery

  • Erhard RahmAffiliated withUniversity of Leipzig, Leipzig


Failure handling; Rollback; Undo; Redo; Checkpoint; Backup; Dump


Logging and recovery ensure that failures are masked to the users of transaction-based data management systems by providing automatic treatment for different kinds of failures, such as transaction failures, system failures, media failures and disasters. The main goal is to guarantee the atomicity (A) and durability (D) properties of ACID transactions by providing undo recovery for failed transactions and redo recovery for committed transactions. Logging is the task of collecting redundant data needed for recovery.

Key Points

The ACID concept requires that no data changes of failed transactions remain in the database. Failed transactions thus have to be rolled back by undoing all their changes (undo recovery). On the other hand, data changes of successfully ended (committed) transactions must not be lost but have to survive possible failures. Failure treatment thus implies a redo ...

This is an excerpt from the content