Editing Isolation (database systems) (section)

==Isolation levels vs read phenomena==

{|class="wikitable"
! {{diagonal split header|Isolation level|Read phenomenon}} !! Dirty read !! Non-repeatable read !! Phantom read
|-
| Serializable || {{good|no}} || {{good|no}} || {{good|no}}
|-
| Repeatable read || {{good|no}} || {{good|no}} || {{bad|yes}}
|-
| Read committed || {{good|no}} || {{bad|yes}} || {{bad|yes}}
|-
| Read uncommitted || {{bad|yes}} || {{bad|yes}} || {{bad|yes}}
|}

Anomaly serializable is not the same as serializable. That is, it is necessary, but not sufficient that a serializable schedule should be free of all three phenomena types.<ref name="sql-isolation"/>