What is the relationship between ACID and database transaction?
Does ACID give database transaction or is it the same thing?
Could someone enlighten this topic.
9 Answers
ACID Properties in Databases:
- Atomicity : Transactions are all or nothing
- Consistency: Only valid data is saved (database from one state that is consistent to another state that is also consistent.)
- Isolation: Transaction do not effect each other (Multiple transactions can run at the same time in the system. Executing multiple transactions in parallel must have the same results as running them sequentially.)
- Durability: Written data will not be lost (even if the database crashes immediately or in the event of a power loss.)
Credit
Related