Isolation Level

Definitions

1. The transaction setting that defines how visible one transaction's intermediate or committed changes are to other concurrent transactions. Levels such as Read Uncommitted, Read Committed, Repeatable Read, and Serializable trade consistency guarantees against concurrency and performance.

   In plain English: It is the rulebook that controls how much one database action can see of another action happening at the same time.

   Example: "We had phantom reads in the report job, so we bumped the isolation level for that transaction."

Related Terms

• MVCC
• normalization
• connection pool
• ACID
• graph database
• Partition Key
• Row-Level Security
• Transaction Log
• Unit of Work