Deutsch: Säure / Español: Acido / Português: Acido / Français: Acide / Italiano: Acido
Acid refers to a chemical solution with an pH less than 7.
ACID is a term in the database context.
In the context of quality management, the term 'ACID' refers to a set of properties that ensure the reliability and consistency of transactions in databases and computer systems. The acronym stands for:
-
Atomicity: All changes to data are treated as a single, indivisible unit of work. Either all changes are made, or none are, and the database remains in a consistent state.
-
Consistency: The transaction brings the database from one valid state to another.
-
Isolation: Transactions are executed as if they were executing serially, i.e., one after the other, and their effects are not visible to other transactions until the transaction is committed.
-
Durability: Once a transaction has been committed, its effects are permanent and survive future system failures.
Examples of systems that support the ACID properties include relational databases such as Oracle, MySQL, and PostgreSQL, as well as NoSQL databases such as Apache Cassandra, Amazon DynamoDB, and MongoDB.