March 2022
Intermediate to advanced
682 pages
22h 58m
English
Regardless of the care with which a database is designed and created, it can be easily damaged or destroyed unless proper concurrency controls and recovery techniques are in place. Database recovery is the process of restoring the database to a correct state in the event of a failure. Concurrency control is the ability to manage simultaneous processes involving the database without having them interfere with one another. Both are needed to protect the database from data contamination or data loss.
The notion of a transaction is central to an understanding of both recovery and concurrency control. A transaction can be thought of as a logical unit of work that contains one or more SQL statements. A logical ...