Figure 1: Isolation
is a property in transaction.
Database in-memory technology is improving year after year; therefore, isolation techniques are modified for better performance. Where you see below is to explain what data anomaly, relating to concurrency are; and how, isolation techniques help user to maintain an acceptable level of control over these data anomalies. In part two of this article we will discuss row versioning, rowlock, and deadlock each of these isolation methods utilize.