What is ACID compliance in a database?

ACID stands for:

• Atomicity: Ensures that all operations in a transaction are completed successfully, or

none are. If one part of a transaction fails, the whole transaction fails.

• Consistency: Guarantees that the database is always in a valid state, adhering to all

rules, including constraints, after a transaction.

• Isolation: Ensures that transactions are executed in isolation from each other, so

one transaction does not interfere with another.

• Durability: Ensures that once a transaction is committed, it is permanent, even in the

case of system failures.