ACID in Database
Atomicity :
- It means transaction will succeed, as one unit
- Failure of any single task within the transaction leads to the overall transaction failure and rollback. Atomicity guarantees that the transaction is all or none
Consistency
- It means the transaction will not affect the database consistency by complying with all database rules, such as foreign keys and constraints, defined on the columns. Only valid data is saved
Isolation
- It means each transaction is executed cocurrently and is independent of each other Transactions do not affect each other
Durability
- Results are written permanently to the database will not be lost even in the case of any abnormal system failure or termination Written data will not be lost
Source of image is here