Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a . In a certain concurrent schedule S 1 , we have three transactions T 1 , T 2 , and T 3 . These

a. In a certain concurrent schedule S 1, we have three transactions T1,T2, and T 3. These transactions operate on data items A,B and C . The interleaving of operations of these transactions in S 1 is given below.
Schedule S1:
{r2(B);r3(A);w3(A);r3(B);r1(C);r2(C);w1(C);w3(A);r2(A);w2(B);r1(A);w1(A);}
Note: Here, r2(A); - means that the transaction-2 reads data item A
w2(A); means that the transaction-2 updates data item A
Check if the above schedule is conflict serializable, by drawing a precedence graph.
Note: For the correct graph you get 2 Marks and for the correct final answer mentioning conflict serializable or not 1 mark. 3 Marks 1
(b) In a certain concurrent schedule S2, we have three transactions T1,T2, and T 3. These transactions operate on data items A,B, and C . The interleaving of operations of these transactions in S2 is given below.
Schedule S2 :
{r1(A);r1(B);w1(B);r2(B);w2(B);r2(A);r3(B);w3(B);C3;r2(C);C2;r1(C);w1(C);C1;}
Note: Here, ,r2(A); - means that the transaction-2 reads data item A
w2(A); - means that the transaction-2 updates data item A
C2;- means transaction T 2 commits.
Now, check S 2 is recoverable or not. Give your reason.
Marks
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database And Transact SQL

Authors: Lucy Scott

1st Edition

1974679985, 978-1974679980

More Books

Students also viewed these Databases questions