Concurrency control and database recovery are intertwined and both are a part of the transaction management. Recovery is required to protect the database from data inconsistencies and data loss. It ensures the atomicity and durability properties of transactions as discussed in chapter 12, Section 12.2.3. This characteristics of DBMS helps to recover from the failure and restore the database to a consistent state. It minimises the time for which the database is not usable after a crash and thus provides high availability. The recovery system is an integral part of a database system.
In this chapter, we will discuss the database recovery and examine the techniques that can be used to ensure the ...
No credit card required