Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(b) Given the following transaction sequence, copy and paste this sequence into your answer document and clearly indicate what locks are present at each

image text in transcribedimage text in transcribed

(b) Given the following transaction sequence, copy and paste this sequence into your answer document and clearly indicate what locks are present at each of the indicated times (Time 0 to Time 34). Cell entries must have the form: S(Tn) - for a shared lock by Tn, X(Tn) - for an exclusive lock by Tn or Tn wait Tm - for a wait of Tn due to Tm (where n and m are transaction numbers). TIME TRANS ACTION A B C D E F G H 0 T1 Read A 1 T2 Read B 2 T1 Read C 3 T4 Read D 4 T5 Read A 5 T2 Read E 60 T2 Update E 7 T3 Read F 8 T2 Read F 9 T5 Update A 10 T1 Commit 11 T6 Read A 12 T5 Rollback 13 T6 Read C 14 14 T6 Update C 15 T7 Read G 16 T8 Read H 17 T9 Read G 18 T9 Update G 19 T8 Read E 20 T7 Commit 21 T9 Read H 22 T3 Read G 23 T10 Read A 24 T9 Update H 25 T6 Commit 26 T11 Read C 27 T12 Read D 28 T12 Read C 29 T2 Update F 30 T11 Update C 31 T12 Read A 32 T10 Update A 33 T12 Update D 34 T4 Read G Complete the following: (i) For each of the listed items A.. H, what wait states are present at time 34 (the last time listed). Shown the waits in the form: (ii) (!!!) Item A: T1 waiting on T5 Item B: ... etc (note this is an example ONLY) Prepare a wait for graph indicating the state of waiting locks at time 34. Your wait for graph can be prepared using any drawing package such as LucidChart or free hand drawn. Paste/insert an image of your wait for graph into your answer document below your answer to (i) above Report if deadlock exists or not, and if it does exist, list the transactions involved.

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

Human Centered And Error Resilient Systems Development Ifip Wg 13 2/13 5 Joint Working Conference 6th International Conference On Human Centered

Authors: Cristian Bogdan ,Jan Gulliksen ,Stefan Sauer ,Peter Forbrig ,Marco Winckler ,Chris Johnson ,Philippe Palanque ,Regina Bernhaupt ,Filip Kis

1st Edition

331944901X, 978-3319449012

More Books

Students also viewed these Programming questions