answersLogoWhite

0

Concurrent Execution in DBMSDatabase Management systems usually allow multiple transaction to run concurrently even though it causes a lot of complications with consistency of data. Ensuring consistency when multiple transactions execute concurrently, requires extra effort. It is much simpler to allow only one transaction to run at a time but concurrent execution of transactions has its own advantages:
  • Improved throughput and resource utilization :Concurrent execution means that CPU doesn't have to be idle while it is waiting for I/O activity to complete. This is because transactions can run in parallel on CPU along with I/O activities. This means that resources can be utilized effectively by having multiple transaction run concurrently.
  • Less waiting time : Without concurrency, a short transaction might need to wait for a long transaction to finish causing delay in its execution. With multiple transactions running on the system, new transactions have to wait for less time before getting executed.
User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

The execution of a user program which interacts with the distributed DBMS ia called?

Transaction


What is View Serializable in DBMS?

View Serializable is a correctness criterion in database management systems that ensures that the final result of executing concurrent transactions is the same as if they were executed one after the other. This property helps maintain data consistency and ensures that the database remains in a consistent state despite concurrent transaction execution. Transactions are said to be view serializable if their interleaved execution produces the same results as if they were executed sequentially.


What are the three most common concurrent transaction execution problems?

The three most common concurrent transaction executive problems are uncommitted data, lost updates, and inconsistent retrievals. It is believed that concurrency control can help these problems.


How do you start and finish a transaction in DBMS?

How do you start and finish a transaction in DBMS?


How does DBMS handle concurrent updates in MySQL?

MySQL is an RDBMS.


What is transaction system in dbms?

any change in database is called transaction.


What allows concurrent access by multiple users in a database?

Primarily it's based on rules about when changes to data are posted in a transaction and read by other users, which are part of the record-locking features of the DBMS. Some DBMS's manage this with undo and redo logs, which support snapshotting the data before the updates were started, so that other users can access the records before the update transaction was started.


Meant of transaction and important limits in DBMS?

Transactions' Importance:Users can submit transaction and can think of each transaction as executing by itself.A transaction might commit after completing all its actions, or it could abort(or be aborted by the DBMS) after executing some actions.


What is control techniques?

several problems can occur when concurrent transaction execute in an uncontrolled manner.


What is set of steps completed by a dbms to accomplish a single user task?

transaction


What is the basic requirement for execution of concurrent process?

the ability to enforce mutual exclusion


Which two file are used during the operation of dbms?

data dictionary and transaction log