In computer science, in the field of databases, write–read conflict, also known as reading uncommitted data, is a computational anomaly associated with interleaved execution of transactions.

Given a schedule S

T2 could read a database object A, modified by T1 which hasn't committed. This is a dirty or inconsistent read.

Write–read conflict

T1 may write some value into A which makes the database inconsistent. It is possible that interleaved execution can expose this inconsistency and lead to an inconsistent final database state, violating ACID rules.

Write–read conflict

Strict 2PL overcomes this inconsistency by locking T2 out from performing a Read/Write on A. Note however that Strict 2PL can have a number of drawbacks, such as the possibility of deadlocks.

Write–read conflict

See also

Concurrency control

Read–write conflict

Write–write conflict

References

Data management

Transaction processing