开发者

Why does a DBMS interleave the actions of the different transactions instead of executing transactions one after another?

I Am trying to learn the RDBMS. I have question for you guys. Why does a DBMS interleave t开发者_如何学JAVAhe actions of the different transactions instead of executing transactions one after another?


A DBMS is typically shared among many users. Transactions from these users can be interleaved to improve the execution time of users’ queries. By interleaving queries, users do not have to wait for other user’s transactions to complete fully before their own transaction begins. Without interleaving, if user A begins a transaction that will take 10 seconds to complete, and user B wants to begin a transaction, user B would have to wait an additional 10 seconds for user A’s transaction to complete before the database would begin processing user B’s request.


It is to increase the transaction throughput. Assume that there are five billing machines in a super market and all these machines are connected to a database server. If the server handles transactions in serial order, ie., one after the other, then the use of 5 billing machines is a mere waste. If many transactions are able to be executed simultaneously by the server, then we could add even more billing machines and we are able to generate many bills.

For more information on transaction management and concepts please visit here.


The transaction can be defined as the group of tasks or the program unit which after execution changes the contents of a database. To decrease waiting time of users DBMS uses concurrent transactions. DBMS Transactions

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜