What do you understand by ACID properties of database transaction?

DATABASE MANAGEMENT SYSTEM

What do you understand by ACID properties of database transaction?

Ans. To ensure the data-integrity, the database system maintains the following properties of transaction. The properties given below are termed as ACID properties-an acronym derived from the first letter of each of the properties. 

(i) Atomicity-This property ensures that either all operations of the transactions are reflected properly in the database, none are. Atomicity ensures either al-or-none operations of a transaction are carried out. 

(ii) Consistency-This property ensures that database remains in a consistent state before the start of transaction and after the transaction is over. 

(iii) Isolation-Isolation ensures that executing transaction execution in isolation i.e. is unaware of other transactions executing concurrently in the system. 

(iv) Durability-This property ensures that after the successful completion of a transaction i.e when a transaction COMMITs, the changes made by it to the database persist i. e remain in the database irrespective of other failures.