ACID <TAG1> is a set of properties that guarantee the reliability of transactions in databases. Each transaction is the main building block of data work, and ACID ensures that it is executed correctly and without data loss even in the event of a failure.
ACID <TAG1> is acronym created from the words:
A - Atomicity (atomicity)
C - Consistency (sequence)
I - Isolation (insulation)
D - Durability (durability)
First principle, atomicity(more details about atomic transactions I wrote earlier), ensures that the transaction is executed completely or not executed at all. If an error occurs, all changes made during this transaction are canceled, returning the database to its previous state. For example, if you make a payment and a network failure occurs, it will not happen that the money was not debited from the sender and was credited to the recipient due to the failure
Sequence means that each transaction translates the database from one correct state to another. Even if there are difficult conditions or dependencies between records, the result of the transaction will always be correct.
Isolation transactions ensure that they do not interfere with each other. If two transactions are executed simultaneously, the result of their execution will be the same as if they were executed sequentially. This is important when many actions are performed with the base at the same time.
Last principle, durability, ensures that once the transaction is complete, its results are preserved even in the event of a system failure. If the data was recorded, it will not be lost when the system is rebooted.
Спрощена схема концепції ACID
ACID — is a fundamental principle that ensures reliability, consistency and security of working with transactions in databases, regardless of external conditions.