In
computer science
Computer science is the study of computation, automation, and information. Computer science spans theoretical disciplines (such as algorithms, theory of computation, information theory, and automation) to Applied science, practical discipli ...
, in the field of
database
In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases sp ...
s, 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 read''.
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 inconsistent final database state, violating
ACID
In computer science, ACID ( atomicity, consistency, isolation, durability) is a set of properties of database transactions intended to guarantee data validity despite errors, power failures, and other mishaps. In the context of databases, a sequ ...
rules.
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.
See also
*
Concurrency control
*
Read–write conflict
In computer science, in the field of databases, read–write conflict, also known as unrepeatable reads, is a computational anomaly associated with interleaved execution of transactions.
Given a schedule S
:S = \begin
T1 & T2 \\
R(A) & \\
& R( ...
*
Write–write conflict In computer science, in the field of databases, write–write conflict, also known as overwriting uncommitted data is a computational anomaly associated with interleaved execution of transactions.
Given a schedule S
S = \begin
T1 & T2 \\
W(A) & ...
References
{{DEFAULTSORT:Write-Read Conflict
Data management
Transaction processing