ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties that guarantee that database transactions are processed reliably.

learn more… | top users | synonyms

2
votes
1answer
550 views

row locking within ACID transaction innodb

I have a financial transaction that looks something like this (pseudo): begin select record for update update record(same record as selected) insert another record into another table ...
8
votes
2answers
3k views

Consistency in ACID and CAP theorem, are they the same?

From my understanding, the consistency in ACID is ensuring the data integrity. However, the consistency in CAP means the data can appear quickly in distributed system. Does that mean: they are not ...
0
votes
1answer
37 views

Transaction atomicity implies consistency

Transactions are said to need both atomicity and consistency. But, what is the point of consistency? Once you ensure that you either update both accounts on money transfer, you are consistent. ...