HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

What is meant by a blind write in a schedule?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
meantwhatblindwriteschedule

Problem

I know that every conflict-serialisable schedule is view-serialisable but the converse is not true. I read in a webpage that when a schedule is view-serialisable but not conflict-serialisable then there exist some blind writes. So what is a blind write?

Solution

If there is no read that happens prior to the first write then it is said to be a blind write.

Example. Consider the following schedule:

-
W3(X) is a blind write, as there is no read before write [R3(X) before W3(X)]

-
W2(X) is not a blind write, as a read happens before write [R2(X) before W2(X)]

Context

StackExchange Database Administrators Q#115435, answer score: 8

Revisions (0)

No revisions yet.