DZone

The SQL phenomena (or anomalies) are:

• Dirty reads
• Non-repeatable reads
• Phantom reads
• Dirty writes
• Read skews
• Write skews
• Lost updates

As their names suggest, these phenomena represent a set of data integrity anomalies that may occur when a developer tries to squeeze performance from transaction concurrency by relaxing the SERIALIZABLE isolation level in favor of another transaction isolation level.

Source: DZone