Visualizing transaction isolation, anomalies, and concurrency control in modern databases.
The four key properties that guarantee database transactions are processed reliably.
Occurs when a transaction reads data that has not yet been committed by another transaction.
A row is retrieved twice and the values within the row differ between reads.
Two identical queries are executed, but the collection of rows returned is different.
Two or more transactions are waiting for each other to release locks, blocking forever.
The highest isolation level. Transactions behave as if they executed one after another.