1. Consider the schedule given below in Table below. R(·) and W(·) stand for 'Read' and 'Write', respectively. T stands for transactions and t stands for time stamps. | | t1 | t2 | t3 | t4 | t5 | t6 | t7 | t8 | t9 | t10 | |---|---|---|---|---|---|---|---|---|---|---| | T1 | | | W(B) | | R(H) | R(I) | W(A) | | R(K) | | | T2 | R(A) | | W(D) | W(E) | | W(F) | | W(J) | | | | T3 | | R(C) | | | W(G) | R(D) | W(H) | R(B) | R(E) | R(G) | i. Give the dependency graph of this schedule. ii. Is this schedule conflict serializable? If you answer "yes", provide the equivalent serial schedule. If you answer "no", briefly explain why. iii. Is this schedule possible under 2PL?
Added by Mario W.
Close
Step 1
- T1: W(B), R(H), R(I), W(A), R(K) - T2: R(A), W(D), W(E), W(F), W(J) - T3: R(C), W(G), R(D), W(H), R(B), R(E), R(G) Show more…
Show all steps
Your feedback will help us improve your experience
Aarya B and 82 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Consider two Transactions $T_{1}$ and $T_{2}$ and four schedules: $S_{1}, S_{2}, S_{3}$ and $S_{4}$ of $T_{1}$ and $T_{2}$ : $T_{1}: r_{1}(x), w_{1}(x), w_{1}(y)$ $T_{2}: r_{2}(x), r_{2}(y), w_{2}(y)$ $S_{1}: r_{1}(x), r_{2}(x), r_{2}(y), w_{1}(x), w_{1}(y), w_{2}(y)$ $S_{2}: r_{1}(x), r_{2}(x), r_{2}(y), w_{1}(x), w_{2}(y), w_{1}(y)$ $S_{3}: r_{1}(x), w_{1}(x), r_{2}(x), w_{1}(y), r_{2}(y), w_{2}(y)$ $S_{4}: r_{2}(x), r_{2}(y), r_{1}(x), w_{1}(x), w_{1}(y), w_{2}(y)$ Which schedules are conflict serializable in the given schedules? (A) $S_{1}$ and $S_{2}$ (B) $S_{1}$ and $S_{3}$ (C) $S_{2}$ and $S_{3}$ (D) $S_{1}$ and $S_{4}$
Databases
Transaction and Concurrency
Consider the given schedules $S_{1}$ and $S_{2}$ $S_{1}: r_{1}(x), r_{1}(y), r_{2}(x), r_{2}(y), w_{2}(y), w_{1}(x)$ $S_{2}: r_{1}(x), r_{2}(x), r_{2}(y), w_{2}(y), r_{1}(y), w_{1}(x)$ Which schedule is conflict serializable? (A) $S_{1}$ (C) $S_{1}$ and $S$, (B) $S_{2}$ (D) None of these
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD