CHAPTER 6 Isolation Levels

• • Dirty reads: A transaction reads data that has been written by another transaction that has not been committed yet.

  • Non repeatable reads: A transaction rereads data it has previously read and finds that another committed transaction has modified or deleted the data.

  • Phantom reads:

ANSI (American National Standards Institute) defined the following isolation levels between transactions in SQL 92 standard.