Question: Consider the database transactions listed below. T 1 a = read ( x ) b = read ( y ) write ( z , a
Consider the database transactions listed below.
T
a readx
b ready
writezab
commit
T
a readx
writeya
commit
T
c readx
writexc
writezc
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 T and T that is NOT
conflict serializable.
Prove that the execution is NOT conflict serializable.
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
