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.
Wiki User
∙ 11y ago
Add 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)
What is the difference between serial and serializable schedule?
A serial schedule is when all the operations of one transactions appear together (not mixed with the operations of any other transactions on the schedule). A serializable schedule is a weaker term -- it is a schedule where the operations of different transactions may be mixed together on the schedule, so long as they are conflict-equivalent to some serial schedule.
Serial schedule differs serializable schedule in dbms?
Serial schedules are the schedules during which all statements in a transaction are executed consecutively. Serializable schedule is a schedule that is equivalent to a serial schedule
What is difference between 25pin and 9pin serial port?
16
Difference between serial and parallel multiplier?
telidu nana...
What is the difference between serial and series?
A Serial is a story with multiple chapters. A Series is a group or collection of independent stories with something in common.
What is the difference between a serial and a sata hard drive?
A serial hard drive is the same as a SATA hard drive. SATA is Serial ATA, and PATA is Parallel ATA.
What is the difference between serial and non-serial printers?
Serial printers are connected via the serial (COM) port of the computer. "Non-serial" printers are connected through another interface, such as the parallel port, USB, ADB. FireWire, etc...
What is the difference between Serial and Parallel Adder?
Some key differences between a Serial and Parallel Adder are that a Serial Adder is slower, a Parallel adder is a combinational circuit and the time required for addition depends on the number of bits in a Serial, but not a Parallel. A Serial Adder is a sequential circuit while a Parallel is a combinational circuit.
What is the difference between serial robots and parallel robots?
series and parallel are different types of circuits that a robot can contain
What is the difference between a serial number a v.i.n. and a car's id number?
Automotive speaking, they are all one and the same.
What is the difference between serial and parallel data transmission?
one bit at a time vs. a group of several bits at a time.
How do you tell the difference between Savage Arms 32 cal pistols from 1907 and 1915 where the serial numbers overlap?
Features
