The Gateway to Computer Science Excellence
+3 votes
120 views
Why is Blind write necessary for a view serializable schedule that is not conflict serializable?
in Databases by (35 points)
edited by | 120 views

2 Answers

0 votes
> If it's conflict serializable then it's also view serializable.

> If not Conflict serializable then:

   {

               If there is Blind Write then check if View Serializable or not.

               If there is no Blind Write then definitely not View Serializable.

   }
by Active (1.1k points)
–1 vote
It is not necessary condition for view serializable, only if u find a schedule which is not conflict serializable u go for checking whether it is view serializable or not . If Blind write is there then it may or may not be view serializable.
by (141 points)
+1

From the textbook by Silberschatz:

Blind writes appear in any view-serializable schedule that
is not conflict serializable.

Does this mean if it is a view serializable schedule but not conflict serializable, then it must have a blind write? Is the word 'any' above replaceable by 'all' without changing the meaning of the sentence?

+1
0
Thanks, that not only cleared my doubt, but also the doubt that followed from it  :)

"Are there conflict serializable schedules that contain blind writes?" The answer is yes.
+1

Does this mean if it is a view serializable schedule but not conflict serializable, then it must have a blind write?

yes

 

Is the word 'any' above replaceable by 'all' without changing the meaning of the sentence?

yes

 

"Are there conflict serializable schedules that contain blind writes?

yes

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,737 questions
57,292 answers
198,237 comments
104,919 users