Transactions and concurrency management, Database Management System

Transactions And Concurrency Management

 Introduction

One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it between multiple users. Various users access the database or perform transactions at the similar time. What if a user's transactions try to access a data item that is being used /modified by another transaction? This unit attempts to give details on how concurrent transactions are implemented under the control of DBMS. Though, in order to describe the concurrent transactions, first we must explain the term transaction.

Concurrent implementation of user programs is essential for good performance of DBMS, as concurrent running of various user programs keeps utilizing CPU time efficiently, as disk accesses are frequent and are relatively slow in case of DBMS. Also, a user's program may carry out a lot of operations on the data returned from DB, but DBMS is only concerned about what data is being written from / read / into the database.

 

Posted Date: 3/11/2013 5:16:52 AM | Location : United States







Related Discussions:- Transactions and concurrency management, Assignment Help, Ask Question on Transactions and concurrency management, Get Answer, Expert's Help, Transactions and concurrency management Discussions

Write discussion on Transactions and concurrency management
Your posts are moderated
Related Questions
A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of Ame

Hashed File Organisation Hashing is the most common form of purely random access to a database or file. It is also used to access columns that do not have an index as an optimi

What does conceptual design work? A conceptual design involves modelling independent of the DBMS.

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

(a) Explain briefly the three parts of a relational Model. (b) Contrast the following terms with an appropriate example: (i) stored attribute v/s derived attribute (ii) en

Describe the nested-loop join and block-nested loop join.   Ans:   The block nested- loop join algorithm is as described below:     for every block B r of relation R do beg

what is difference between circular inked lust and grunded linked list

Sub query in the UPDATE command : Example :  //Double  the  commission  for  employees,  who  have  got  at  least  2 increments. UPDATE EMP SET COMM = COMM * 2 WHERE

What are the causes of bucket overflow in a hash file organization? What can be done to reduce the occurrence of bucket overflow? When a record is inserted, the bucket to that

Write A short note on temporary tables? Temporary Tables - Temporary tables exists solely for a particular session, or whose data persists for the duration of the transaction