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
explain three types of internet risks to the consummers whent he business system is data dependent. how can we minimise these risks

write on the various type of relationalkey

List any two significant differences between a file processing system and a DBMS. File Processing System vs. DBMS Data Independence - Data independence is the capacity t

Define query optimization. Query optimization refers to the process of search the lowest -cost method of evaluating a given query.

Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.

Q.   Why would you choose a database system instead of simply storing data in operating system file? Define  at a base concept in details. Sol. Advantages of Database over Fil

What is a primary index? A primary index is an index whose search key also explains the sequential order of the file.

Describe relational model? Structure of relational data base Basic structure Database schema Keys Schema diagram Query languages

Data Definition Language It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL? Th

Describe a technique for direct search? Explain how data is stored within a file so which direct searching can be performed. For a file of unordered fixed length records by u