in Databases edited by
4,304 views
0 votes
0 votes
Which of the following is false?

a)All the schedules which are allowed under basic time stamp ordering protocols are also allowed under Thomas write rule.

b)Schedules which are allowed under Thomas write rule are also allowed under multi-version timestamp ordering protocol.

c)All the schedules which are not allowed Thomas write rule are also not allowed in a multi-version timestamp ordering protocol.

d)None.
in Databases edited by
4.3k views

3 Answers

0 votes
0 votes

The hierarchy is like this :

$I$ is $false,$ Some allowed under basic timestamp are not allowed under thomas write rule

$II$ is $false,$ Some allowed under thomas write rule are not allowed under multiversion timestamp ordering protocol

$III$ is $false,$ Some not allowed under thomas are allowed under multiversion

4 Comments

can you please mention the source from where you have referred the pic?
0
0
actually i created this on my own. I remember this from a solution of a question from testbook test, basic timestamp and thomas write relation can be easily seen, I don't know about multi-version, though I am sure testbook would not be wrong in this solution. If I find a source i will post it here.
0
0

https://gateoverflow.in/217350/understanding-multiversion-timestamp-ordering-protocol 

i have referred the above link in which it is mentioned that multiversion timestamp ordering is superset of thomas write rule. So according to this the option B is true and option C is false and from this link and korth https://www.geeksforgeeks.org/dbms-concurrency-control-protocol-thomas-write-rule/  they have mentioned that all the possible scheules under basic timestamp are also allowed in thomas write rule. So option A is true.

1
1
A is correct as schedule accepted by Thomas Write are superset of basic time stamp ordering.

B is correct.

I have no idea about option C.
0
0
0 votes
0 votes
A is correct as schedule accepted by Thomas Write are superset of basic time stamp ordering.

B is correct.

I have no idea about option C.
0 votes
0 votes

answer is C 

Multi version timestamp ordering protocol

every thing is same like time stamp with Thomas write rule

with an addition of condition

TS(Ti)>R−timestamp(Qk) , it creates a new version of Q

It means  if transaction time is more than read time then we will create a new version of Q

Related questions