What is Transactional Integrity – ACID Properties

1. A transaction is a sequence of activities/tasks/operations which together makes a single logical unit of work.
2. All of these task/operation must complete or fail as a single activity.
3. All the transactions must be adhered to the ACID (Atomicity, Consistency,Isolation,Durability) properties.

Atomicity:

• Transaction must be an atomic i.e.either all of the data is performed or nothing has been performed. Partial transaction should not be written to the disk.

Consistency

• Once transaction is completed, it must leave all the data in a consistent state.
• All the data integrity must be maintained.
• All the rules/constraints must be enforced.

Isolation

• Each transaction should be isolated from other transaction. i.e. each transaction must get the same set of data it started with.
• Another user should not get the rows being worked by the first user – until the transaction is completed.

Durability

• Once the transaction is completed, it must be available all the time regardless of the failure.

Happy Learning !!!