Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Logging/Recovery Subsystem

  • Andreas ReuterEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_680


Audit trail; Log component; Log manager; Recovery manager


The logging/recovery subsystem (LRS) of a DBMS is responsible for implementing the fault tolerance mechanisms needed to support database transactions. The log component stores the information needed to undo the updates performed by a transaction in case it has to be rolled back, either to an internal save point or to the beginning. It also stores information needed to re-apply the updates of committed transactions to the database in case they are (partially) lost due to a system crash or after a storage media failure. In addition, the log component keeps track of all relevant state transitions such as begin-transaction, prepare, commit, abort, checkpoint, etc. The log is the first resource that is activated when restarting the database after a crash [1]. The recovery component orchestrates the activities needed to repair the database, depending on the situation. For example, after a crash, it first locates...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Gray J, Reuter A. Transaction processing – concepts and techniques. San Mateo: Morgan Kaufmann; 1993.zbMATHGoogle Scholar
  2. 2.
    Härder T, Reuter A. Principles of transaction oriented database recovery – a taxonomy. ACM Comput Surv. 1983;15(4):287–317.CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Heidelberg Laureate Forum FoundationSchloss-Wolfsbrunnenweg 33HeidelbergGermany

Section editors and affiliations

  • Anastasia Ailamaki
    • 1
  1. 1.Informatique et CommunicationsEcole Polytechnique Fédérale de LausanneLausanneSwitzerland