Question
Databases System. The complete book: Exercise 18.3.3 For each of the following schedules: a) r 1 (A); r2 (A); r3 (B); w 1 >i(A); r2
Databases System. The complete book: Exercise 18.3.3 For each of the following schedules:
a) r1(A); r2 (A); r3 (B); w1>i(A); r2 (C); r2 (B); w2 (B); W1(C);
b) r1(A); W1(B); r2(B): w2 (C); r3 (C); w3 (A);
d) r1(A); r2 (A); w1(B); w2 (B); r1 (B ); r2(B); w2 (C); w1(D).
Assume that each transaction takes a lock on each database element immediately before it reads or writes the element, and that each transaction releases its locks immediately after the last time it accesses an element. Question: Tell what the locking scheduler would do with each of these schedules; i.e., what requests would get delayed, and when would they be allowed to resume?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started