Modern Database Management: Chapter 11 Review Question 25

 

Question

List and briefly explain the ACID properties of a database transaction.

Answer

Organizations today expects the highest level of data integrity during data transaction processing. The transaction in the database management system must follow all four attributes to ensure the integrity of the transaction. They are:

• Atomic
• Consistent
• Isolated
• Durable

These four are called ACID properties. Their details are as follows:

Atomic

Subdivided transactions are not allowed; transactions must be fully processed. The database should be updated only when the transaction is successful. If any transaction fails during the transaction, no changes to the database are allowed.

Consistent

The constraint in the database must be consistent before and after the transaction process.

Isolated

The database should be updated only when the transaction process is successfully committed. During transaction processing, changes to the database should not be disclosed to users, and should only be made public after the transaction is completed.

Durable

The changes made in the database should be permanent. Once a transaction process is committed after the changes, the transaction cannot be reversed when a failure occurs.