ACID Properties (Atomicity, Consistency, Isolation, and Durability)
- Atomic Transaction
- An atomic transaction is a series of database operations such that either all occur, or nothing occurs. Example: Airline Ticket Booking
- Consistency
- The guarantee that database constraints are not violated, particularly once a transaction commits.
- Isolation
- Isolation determines how transaction integrity is visible to other users and systems.
- Serializable
- Repeatable Reads
- Read Committed
- Read Un-Committed
- Isolation determines how transaction integrity is visible to other users and systems.
- Durability
- Guarantees that transactions that have committed will survive permanently.
- For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.
- Durability can be achieved by flushing the transaction’s log records to non-volatile storage before acknowledging commitment.