Assignment 4 Q1 Check The Below Schedules For Recoverable Cascadeless And Strict You Must Explain Why S1 R1 B R1 1 (52.66 KiB) Viewed 29 times
Assignment 4: Q1) Check the below schedules for recoverable, Cascadeless and Strict? You must explain why? S1: R1(b) R1(x) R2(Y) R3(Y) W2(X) W3(Y) R1(x) commit1 commit 3 commit 2 S2: R2(2) R1(A) W1(A) R2(A) W2(A) R2(B) W2(B) commit2 R1(B) W1(B) commit1 S3: R1(b), R1(A) W2(A) W1(A) a2 cl R3(A) W3(A) commit3 S4: R1(b), R1(A) W1(A) al W2(A) R3(A) W3(A) commit2 commit3 S5: R1(b), R1(x) R2(X) R2(Y) W2(Y) c2 W1(X) R3(x) R1(Y) Abort] commit3
Q2) Use the below schedule to check the concurrency control problems: Temporary Update Problem, Incorrect Summary Problem and Lost Update Problem. Explain your answer: T1 T2 sum = 0 read_item(A) sum = sum + A read_item(x) X = X-N write_item(x) read_item(x) sum = sum + x read_item(Y) sum = sum +YI read_item(Y) Y = Y +N write_item(Y)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!