Question #152822
Let T1 transfer $500 from A to B, and T2 transfer 30% of the balance from A to B. Taking this scenario as example, explain the following
a. Serial Schedule ( T1 followed by T2)
b. Serial Schedule ( T2 followed by T1)
C. List out the advantages and limitations of serial scheduling in transaction processing
1
Expert's answer
2020-12-26T03:06:34-0500

As per the given question,

T1T_1 transfers $500 from A to B and T2T_2 transfers 30% of the balance from A to B

a) T1T_1 followed by T2T_2

Transaction T1T_1

read(A)

A:=A-500

write (A)

read(B)

B:=B+500

write(B)

Transaction T2T_2

read(A)

temp:=A*0.3

A:=A-temp

write(A)

read(B)

B:=B+temp

write(B)

b) Serial schedule T2T_2 followed by T1T_1

Transaction (T1T_1)

read(A)

A:=A-500

write(A)

Transaction (T2)(T_2) :

read(A)

temp:=A*0.3

A:=A-temp

write(A)

Transaction (T1T_1)

read(B)

B:=B+500

write(B)

Transaction (T2)(T_2) :

read(B)

B:=B+temp

write(B)

c) The main advantages of serial scheduling, it gives the guarantee for data consistency.

It have the high average waiting time, low response time and low throughput could be possible.


Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!
LATEST TUTORIALS
APPROVED BY CLIENTS