- 3 Transactions And Phenomena Say For Each Of The Following Schedules Does The Schedule Contain Phenomena Or Any Other 1 (57.3 KiB) Viewed 79 times
3. Transactions and Phenomena. Say for each of the following schedules: does the schedule contain phenomena or any other violation of the locking rules of the common scheduler? If not, give an explanation why not. If yes, say on which data object the phenomenon occurs; describe the phenomenon and using this example, explain why this phenomenon or violation of locking rules can be a problem. State the highest isolation level that the schedule can be performed on. (a) s1 : r1[z], r3[y], r2[y], c3, w2[z], w2[y], r1[z], c2, (b) s2 : r1[x], r3[y], r2[y], c3, r1[y], w2[z], w2[y], c2, r1[z], r1[y], (c) s3 : r1[x], r3[y], r2[y], c3, r1[y], w2[z], w2[y], c2, r1[z], r1[x] c1. w1[x], c1. w1[x], w1[y], c1. [12 marks]