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 ...
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 ...
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. ...