ACID Properties

ACID properties (Atomicity, Consistency, Isolation, Durability) ensure reliable processing of transactions in a database.

  • Atomicity: Ensures that a transaction is either fully completed or not executed at all.
  • Consistency: Ensures data remains valid before and after a transaction.
  • Isolation: Ensures transactions do not interfere with each other.
  • Durability: Ensures committed transactions persist even in case of a system failure.

Example: A bank transfer must withdraw and deposit money together (Atomicity), ensure correct balances (Consistency), prevent interference from other transactions (Isolation), and remain stored permanently (Durability).