Relational databases provide the atomicity, consistency, isolation, and durability of ACID [1] properties to maintain the integrity of the database. ACID is a powerful abstraction that simplifies complex interactions with the data and hides many anomalies (like dirty reads, dirty writes, read skew, lost updates, write skew, and phantom reads) behind a simple transaction abort.


Let’s discuss ACID in detail:

Also Read

  1. ↩︎

Thoughts 🤔 by Soumendra Kumar Sahoo is licensed under CC BY 4.0