Transactions
Let T1 transfer $50 from A to B, and T2 transfer 10% of the balance from A to B. And example of a serial schedule in which T1 is followed by T2 is shown below:
T1 | T2 |
---|---|
read(A) | |
A:=A-50 | |
write(A) | |
read(B) | |
B:=B+50 | |
write(B) | |
commit | |
read(A) | |
temp:=A*0.1 | |
write(A) | |
read(B) | |
B:=B+temp | |
write(B) | |
commit |
Show a CONCURRENT execution of T1 and T2 that produces a SERIALIZABLE schedule in a table just like the one above.
Solved 1 Answer
See More Answers for FREE
Enhance your learning with StudyX
Receive support from our dedicated community users and experts
See up to 20 answers per week for free
Experience reliable customer service
Solution: There are basically serial and non serial schedules in databases. The non serial schedules have two types. They are serializable and non serializable schedules. Serializable Schedules: These are used to maintain the consistency in the database. This allows concurrent transactions to happen at the same time. For the given schedule, the concurrent execution of the transactions T1 and T2 can be as shown in the screenshot attached below. Please follow it.   ...