11.1 ACID Properties of Transactions
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 ...
Get Databases Illuminated, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
