#DBMS #Transcation #Concurrency Transaction Schedules in DBMS | Serial Schedule |Concurrent schedule
Channel: Tech Educators
Date: 2021-03-29

#DBMS #Transcation #Concurrency Transaction Schedules in DBMS | Serial Schedule |Concurrent schedule
What is a schedule?
When multiple transactions are running concurrently then there needs to be a sequence in which the operations are performed because at a time only one operation can be performed on the database. This sequence of operations is known as Schedule.

Serial Schedule: 
In Serial schedule, a transaction is executed completely before starting the execution of another transaction. In other words, you can say that in serial schedule, a transaction does not start execution until the currently running transaction finished execution. This type of execution of transaction is also known as non-interleaved execution. The example we have seen above is the serial schedule.

Concurrent Schedule: 
A schedule is said to be concurrent in case the instructions of the transactions get executed preemptively. When the database system executes several transactions concurrently, the corresponding schedule no longer needs to be serial.  With multiple transactions, the CPU time is shared among all the transactions.