The Gateway to Computer Science Excellence
0 votes
57 views
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 by Junior (745 points)
edited by | 57 views

1 Answer

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

by Loyal (5.4k points)
0
can you please mention the source from where you have referred the pic?
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.
+1

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.

Related questions

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,235 comments
104,917 users