⊿ Point. {R} Glossary. ◢ Keyword: A. ▰ Sources. 〓 Books [B] ◥ University. {q} PhD. ⏫ THEMES. ⏫ Big Data. [B] Big Data. ⚫ USA. ↂ EndNote. ☝️ BD Dummies. ACID. Set of properties of database transactions According to Gray and Reuter, the IBM Information Management System supported ACID transactions as early as 1973 (although the acronym was created later).[3] Characteristics[edit] The characteristics of these four properties as defined by Reuter and Härder are as follows: Atomicity[edit] An example of an atomic transaction is a monetary transfer from bank account A to account B. Consistency (Correctness)[edit] Isolation[edit] Durability[edit] Examples[edit] The following examples further illustrate the ACID properties. CREATE TABLE acidtest (A INTEGER, B INTEGER, CHECK (A + B = 100)); Atomicity[edit] Atomicity is the guarantee that series of database operations in an atomic transaction will either all occur (a successful operation), or none will occur (an unsuccessful operation).
Consistency failure[edit] Consistency is a very general term, which demands that the data must meet all validation rules. Isolation failure[edit] Combined, there are four actions: