First “1” is sent and then “0” is sent, again “1” and so on. Say we have a byte of data “10101010” to be sent over a serial transmission channel.

Serial transmission refers to transmission of one bit at a time where the transmission is sequential. Due to various reasons, which we discuss below, serial transmission has more advantages than parallel transmission and hence today serial transmission is followed in most used interfaces such as USB, SATA and PCI Express. In parallel transmission, data is sent parallel where several bits are simultaneously transmitted using multiple wires. In serial transmission, data is sent sequentially where one bit after the other is sent through a single wire. In the computer world, data is transmitted digitally using bits.

In serial transmission it is sequential whereas, in parallel transmission, it its simultaneous. That is all for now, you may share your thoughts/ideas on this post using the comments section below.The primary difference between serial and parallel transmission is in the way the data is transmitted. Serializable Schedules:Ī schedule is said to be serializable if and only if the result of the given concurrent schedule is equivalent to one of the possible serial schedule. Hence RDBMS has implemented Concurrency control mechanism to produce serializable schedules.

It always gives guarantee for data consistency.

Low response time and low throughput could be possible.

At least one of these operations is write operation.

Both the operations are accessing the same data item.

Conflicting Operations:Ī pair of operations is said to be conflicting with each other if and only if: Thus, the number of possible schedules for a set of n transactions is much larger than n!.Ĭoncurrent schedules might get affected with conflicting operations and hence does not give guaranty for data consistency. In general, it is not possible to predict exactly how many instructions of a transaction will be executed before the CPU switches to another transaction. Several execution sequences are possible, since the various instructions from both With multiple transactions, the CPU time is shared among all the transactions. If two transactions are running concurrently, the operating system may execute one transaction for a little while, then perform a context switch, execute the second transaction for some time, and then switch back to the first transaction for some time, and so on. When the database system executes several transactions concurrently, the corresponding schedule no longer needs to be serial. A schedule is said to be concurrent in case the instructions of the transactions get executed preemptively.

Advantage of serial processing