What is ACID?

ACID is an acronym describing a set of properties that guarantee the reliability of transactions in database management systems (DBMS).

• Atomicity: The transaction is either fully completed or not executed at all. No intermediate states.
• Consistency: The transaction transforms the database from one consistent state to another. Integrity constraints are maintained.
• Isolation: Concurrent transactions do not affect each other. The result is identical to sequential execution.
• Durability: After a successful transaction, changes are saved even in case of system failures.

These properties are fundamental for ensuring data integrity in critical applications.