The most compelling feature of relational database systems is ACID(Atomicity Consistency Isolation Durability). Isolation is achieved using transactions. Isolation is needed to avoid race conditions when concurrent actors act upon the same row. SQL standard defines isolation with different levels. Every isolation level offers certain guarantees and possible anomalies that can occur.
