In order to measure the consistency of database, the concurrency control of transaction is considered seriously to
Fantastic news! We've Found the answer you've been seeking!
Question:
In order to measure the consistency of database, the concurrency control of transaction is considered seriously to increase the performance. The best practices are serialization or Un serialization of transaction schedules.
- Suppose that a database with objects A, B, X and Y. Assume that there are two transactions T1 and T2 performing R (read) and W (write) operations before they C (commit). Given are two example schedules. Identify them as serializable or not serializable. Also explain with reason(s). If any of the schedule(s) is identified as not serializable then show with proof that strict 2PL disallows this schedule. [6]
a) R1[A] → W1[A] → R2[B] → W2[B] → R2[A] → W2[A] → R1[C] → W1[C] → C1 → C2
b) R1[X] → R1[Y] → R2[X] → W2[X] → R2[Y] → W1[X] → W1[Y] → W2[Y] → C1 → C2
Related Book For
Mathematical Statistics with Applications in R
ISBN: 978-0124171138
2nd edition
Authors: Chris P. Tsokos, K.M. Ramachandran
Posted Date: