ACID Principles
Atomicity, Consistency, Isolation, Durability (ACID) are principles that exist to provide guidance for developing data systems that create complete transactions and reject partial transactions from being recorded.
- data is validated to ensure completeness
- typically applies to relational databases
4 Principles
- Atomicity
- Atomicity guarantees either all of the transaction succeeds or none of it does
- all or nothing
- will not create partial records or transactions
- if one part of the transaction fails, the whole transaction fails
- Consistency
- ensures that all data is consistent
- data will be valid based on all the defined rules for that data
- If a field has properties with rules, the transaction will not save until it matches those specified rules
- Isolation
- means that all transactions occur isolated from other transactions
- one transaction can’t be impacted by another
- a transaction can’t read data from any other transaction that isn’t completed
- Durability
- confirms that once a transaction is committed, it will remain in the system