Question: Consider the database transactions listed below. T 1 a = read ( x ) b = read ( y ) write ( y , a
Consider the database transactions listed below.
T
a readx
b ready
writeyab
commit
T
e readz
writeye
writexe
commit
Assume that the initial values of the persistent data items x y and z are the following:
x y and z
Show a sample concurrent execution of the transactions T and T that is view
serializable and it is NOT conflict serializable.
Prove that the execution is view serializable and it is NOT conflict serializable.
To prove that the execution is view serializable and it is NOT conflict serializable use a
technique of twodimensional diagrams
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
