What is it
Atomicity, Consistency, Isolation, and Durability (ACID)
Used to ensure that a database transaction is completed in a timely manner
Atomicity
- database transactions can be broken down to smaller parts
- atomicity refers to the integrity of the entire database transaction, not just a component of it.
- In other words, if one part of a transaction doesn't work like it's supposed to, the other will fail as a result.
Consistency
- Only data which follows those rules is permitted to be written to the database.
Isolation
- Huge amount of data will simultaneously interact with the database.
- Isolation refers to the ability to concurrently process multiple transaction in a way that one does not affect another
Durability
- All technology fail from time to time...the goal is to make those failures invisible to the end-user.
- In a database that possess durability, data is saved once a transaction is completed, even if a power outage or system failure occurs