Schedules In DBMS - Serial & Non Serial Schedule In Database

Schedules In DBMS Explain, What Is Schedule Database Management System, Serial And Non Serial Schedule In DBMS, What Is Serial & Non Serial Schedule In Database 

Schedule

When  transactions are executing concurrently in an interleaved fashion, then the order of execution of operation from the various transactions is known as a schedule.
a schedule for a set of transactions must consist of all instructions of those transactions.
must preserve the order in which the instructions appear in each individual transaction.
A transaction that successfully completes its execution will have a commit instructions as the last statement.
A transaction that fails to successfully complete its execution will have an abort instructions as the last statement.

Serial And Non Serial Schedule In DBMS  
A schedule S is serial if, for every transaction T participating in the schedule, all the operations of T, are executed consecutively in the schedule, otherwise the schedule is called NONSERIAL.

Tweet