Questions tagged [dirty-write]
2 questions
6
votes
1 answer
Isolation level: Difference between dirty write and lost update
I'm reading A Critique of ANSI SQL Isolation Levels
and get confused by the two definitions:
Dirty write
w1[x]...w2[x]...((c1 or a1) and (c2 or a2) in any order)
Lost update
r1[x]...w2[x]...w1[x]...c1
Doesn't the history definition of lost…
Patrick
- 555
- 1
- 6
- 25
3
votes
3 answers
What are dirty writes? What happens if they are not allowed?
I read about database isolation levels and transactional phenomena.
Dirty reads are obvious but I don't understand dirty writes.
All descriptions of dirty write say something like:
A dirty write is when a process save[s to] a file data that has…
Bert Speckels
- 357
- 2
- 4
- 14