A company maintains the stock of six produ Initial stock was as follows: a = 8, b = 32, c = 15, d = 23, e = 8, f = 6. Now consider the following schedule having two transactions T1 and T2: T1: r(a); r(b); T2: r(c); c:= c+10; w(c); T1: (c) r(d); T2: r(d); d:= d-10; w(d); commit; T1: r(e); r(f) Suppose T1 is responsible to calculate the total stock of the company.

Operations Research : Applications and Algorithms
4th Edition
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Wayne L. Winston
Chapter17: Markov Chains
Section: Chapter Questions
Problem 3RP
icon
Related questions
Question
A company maintains the stock of six products.
Initial stock was as follows: a = 8, b = 32, c = 15,
d = 23, e = 8, f = 6.
Now consider the following schedule having
two transactions T1 and T2:
T1: (a); r(b);
T2: r(c); c:= c+10; w(c);
T1: r(0); r(d);
T2: r(d); d:= d-10; w(d); commit;
T1: r(e); r(f)
Suppose T1 is responsible to calculate the total
stock of the company.
i) Identify the problem (lost update / dirty
read/ incorrect summary) of the schedule.
Justify your answer with proper logic.
ii) Solve the problem of the schedule by using
2PL.
(Assume data value iff it is missing/needed]
Transcribed Image Text:A company maintains the stock of six products. Initial stock was as follows: a = 8, b = 32, c = 15, d = 23, e = 8, f = 6. Now consider the following schedule having two transactions T1 and T2: T1: (a); r(b); T2: r(c); c:= c+10; w(c); T1: r(0); r(d); T2: r(d); d:= d-10; w(d); commit; T1: r(e); r(f) Suppose T1 is responsible to calculate the total stock of the company. i) Identify the problem (lost update / dirty read/ incorrect summary) of the schedule. Justify your answer with proper logic. ii) Solve the problem of the schedule by using 2PL. (Assume data value iff it is missing/needed]
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Lease Option
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole