set of properties of database transactions intended to guarantee validity even in the event of errors, power failures, etc.
ACID is an abbreviation. It stands for
- Atomicity - A change to the data in the database is either done completely, or not done at all. The process of doing it is not visible to users of the database. Users (people and programs) only see the result.
- Consistency - A database can have rules about its data. Consistency means that the data always follows those rules. When a transaction (a change in the data) occurs, it can not break the rules. Rules are usually about integrity, such as what is allowed and what is not allowed in certain locations of the database.
- Isolation - There can be more than one transaction occurring at the same time. Isolation means that one transaction can only see the changes of another transaction at the right time. Sometimes isolation means that transactions happening at the same time would do the same thing if they were done one after another.
- Durability - When a transaction is done, if the result is unwanted it can be rolled back, which means it is made to go away as if it never happened. If the result of a transaction is still wanted, it can be committed, which makes the change permanent. After a transaction is committed, the change it made will still be there even if the database is shut down.
- "What are the ACID properties? | Data Basecamp". 2022-07-02. Retrieved 2022-07-07.