0
Serial Schedule
Non-Serial Schedule
A serial schedule is a sequence of operation by a set of concurrent transaction that preserves the order of operations in each of the individual transactions.
A non-serial schedule is a schedule where the operations of a group of concurrent transactions are interleaved.
Transactions are performed in serial order.
Transactions are performed in non-serial order, but result should be same as serial.
No interference between transactions
Concurrency problem can arise here.
It does not matter which transaction is executed first, as long as every transaction is executed in its entirely from the beginning to end.
The problem we have seen earlier lost update, uncommitted data, inconsistent analysis is arise if scheduling is not proper.
A serial schedule gives the benefits of concurrent execution without any problem
In this schedule there is no any benefit of concurrent execution.
Serial schedule that does interleaved the actions of different transactions.
Where non-serial schedule has no only fix actions of any transaction.
EXAMPLE:
If some transaction T is long, the other transaction must wait for T to complete all its operations.
EXAMPLE:
In this schedule the execution of other transaction goes on without waiting the completion of T.
If we consider transaction to be independent serial schedule is correct based on (property ACID) above assumption is valid.
The objective behind serializability is to find the non-serial schedule that allows transactions to execute concurrently without interfering one another.
Still curious? Ask our experts.
Chat with our AI personalities
Maxine
Fran
DevinAdd your answer:
Earn +20 pts
What is the difference between SCSI and SAS?
SCSI uses a parellel communication chain and SAS uses serial Point to Point communication
What is the difference between Serial and Parallel data transfer?
With a Microcontroller look at it serial would be better than parallel when you have very few I/O pins or when you want to reserve extra I/O pins for other purposes.A cost-of-wire approach would prove that serial is better because the fewer wires would have a lower cost then that of parallel communicationComputer case airflow would also indicate that serial can be better. With multiple harddrives in a computer sata cables will not disrupt the airflow as much as their much larger PATA flat cable counterparts. Although depending on where components are located and what type of cooling is used would be factors for this argument.
What is a sentence for serial?
Example sentence - The machine had a serial number engraved on it.
Could you use serial in a sentence?
The production date of a piece of machinery can be identified by the serial number.
What is the advantage of serial bus compared with parallel bus?
serial buses take up much less space seeing as though they only need 2 lines (send & return)
