Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

8. The following transactions execute under a optimistic concurrency control: T1: ReadSet:{B, E}, WriteSet: {C, E, F } T2: ReadSet: {F}, WriteSet: {A,B} T3: ReadSet:

8. The following transactions execute under a optimistic concurrency control:

T1: ReadSet:{B, E}, WriteSet: {C, E, F } T2: ReadSet: {F}, WriteSet: {A,B} T3: ReadSet: {A}, WriteSet:{C}

T4: ReadSet: {A,C}, WriteSet: {B,D}

T5: ReadSet: {F }, WriteSet: {C, D} Consider the following sequence of events:

1. T1 initiates Read phase 2. T2 initiates Read phase 3. T2 initiates Validation phase 4. T1 initiates Validation phase 5. T3 initiates Read phase 6. T2 completes Validation phase 7. T4 initiates Read phase 8. T5 initiates Read phase 9. T4 initiates Validation phase

10. T1 completes Validation phase 11. T5 Initiates Validation Phase 12. T3 Initiates Validation Phase 13. T4 completes Validation phase 14. T3 completes Validation phase 15. T5 completes Validation phase

Assume that for each transaction the Read phase ends exactly before the beginning of the validation phase of that transaction. For instance, 4 T1 initiates Validation phase implicitly means that T1 completes the Read phase before this event and after the previous event (event #3). And for each transaction the Write phase is completed immediately after the completion of the validation phase of that transaction (if the validations is successful). For instance, 10 T1 completes Valida- tion phase implicitly means that T1 completes the Write phase immediately after completing the Validation phase of T1 and before the beginning of the next event (event #11).

Which of these five transactions (T1, T2, T3, T4 and T5) validate successfully? For the transactions failed to validate explain the reason.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Sham Navathe

4th Edition

0321122267, 978-0321122261

More Books

Students also viewed these Databases questions