snapshot isolation

RU: snapshot isolation

A concurrency control method where each transaction reads from a consistent snapshot taken at its start, seeing only committed data from before that point. Prevents dirty reads, non-repeatable reads, and phantom reads, but is susceptible to write skew — a beyond-standard anomaly not listed in the SQL specification — because two transactions can read overlapping data and write non-overlapping rows without conflict.