Search your topic here

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.