Atomic Consistent Isolated Durable (ACID) Transaction

From GM-RKB
(Redirected from ACID)
Jump to navigation Jump to search

An Atomic Consistent Isolated Durable (ACID) Transaction is a data transaction that is an atomic transaction, a consistent transaction, an isolated transaction and a durable transaction.



References

2023

2020

  • (Wikipedia, 2020) ⇒ https://en.wikipedia.org/wiki/ACID Retrieved:2020-6-3.
    • In computer science, ACID (atomicity, consistency, isolation, durability) is a set of properties of database transactions intended to guarantee validity even in the event of errors, power failures, etc. In the context of databases, a sequence of database operations that satisfies the ACID properties (and these can be perceived as a single logical operation on the data) is called a transaction. For example, a transfer of funds from one bank account to another, even involving multiple changes such as debiting one account and crediting another, is a single transaction.

      In 1983, Andreas Reuter and Theo Härder coined the acronym ACID as shorthand for atomicity, consistency, isolation, and durability, building on earlier work by Jim Gray who enumerated atomicity, consistency, and durability but left out Isolation when characterizing the transaction concept. These four properties describe the major guarantees of the transaction paradigm, which has influenced many aspects of development in database systems. According to Gray and Reuter, IMS supported ACID transactions as early as 1973 (although the term ACID came later).


2018

  • https://geeksforgeeks.org/acid-properties-in-dbms/
    • QUOTE: A transaction is a single logical unit of work which accesses and possibly modifies the contents of a database. Transactions access data using read and write operations. In order to maintain consistency in a database, before and after the transaction, certain properties are followed. These are called ACID properties.