Systematic definition and classification of data anomalies in DBMS (English Version)

Understand

There is no unified definition of Data anomalies, which refers to the specific data operation mode that may violate the consistency of the database.

• Known data anomalies include Dirty Write, Dirty Read, Non-repeatable Read, Phantom, Read Skew and Write Skew, etc.
• In order to improve the efficiency of concurrency control algorithms, data anomalies are also used to define the isolation levels, because the weak isolation level can improve the efficiency of transaction processing systems.
• This paper systematically studies the data anomalies and the corresponding isolation levels.