ACID properties of transaction
September 13, 2016
Categorised in: Database Management System
- Atomicity : Either all operations are executed or none of the operations are executed.
- Consistency : All the data must be in a consistent state. There should be no transaction that has adverse effect on data residing in database.
- Isolation : If more than 1 transactions are executing simulataneously then every transaction should be executed as if no other transaction is running.
- Durability: The database system should be able to sustain the updates. Even if the system fails or restarts, the updates should be applied.