Schedules in dbms


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.


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.