Schedules in dbms

SCHEDULES

Schedules – sequences that indicate the chronological order in which instructions of concurrent transactions are executed
A schedule for a set of transactions must consist of all instructions of those transactions
A schedule must preserve the order in which the instructions appear in each individual transaction.

Example Schedules:

See in this schedule:


Let T1 transfer $50 from A to B, and T2 transfer 10% of the balance from A to B.  The following is a serial schedule, in which T1 is followed by T2.



















Let T1 and T2 be the transactions defined previously.  The following schedule  is not a serial schedule but is equivalent to above schedule.

LEAVE A REPLY










Related topics

Please use contact page in this website if you find anything incorrect or you want to share more information about the topic discussed above.