What is "acid"

ACID

It is a set of properties that ensure that database transactions are processed reliably. This means that an ACID-compatible database server must ensure that it has not violated any restrictions, even when a transaction has not been completed.

Most SQL-based systems are intended to be ACID-compatible.

  • Atomicity

    A transaction is completely executed, or if a part of the transaction fails, no changes are made.

  • Consistency

    The database must have a transaction terminated in a consistent state, that is, it must respect all rules imposed in the database for all those involved in the transaction.

  • Isolation

    One transaction cannot interfere with another while it is in operation. Only after your conclusion will your result become available for other transactions.

  • Durability

    At the end of the transaction the result must remain in the data bank, whatever happens.

Reading Recommendations