The Concurrent Transactions

 Almost every commercial DBMS support multi-user environment. Therefore, allowing multiple transactions to proceed concurrently. The DBMS must make sure that two or more transactions do not obtain into each other's way, i.e., transaction of one user doesn't effect the transaction of other or even the transactions issued by the similar user should not get into the way of each other. Be advised that concurrency related problem may happen in databases only if two transactions are contending for the similar data item and at least one of the concurrent transactions wishes to update a data value in the database. In this, the concurrent transactions only read similar data item and no updates are done on these values, then it does NOT create any concurrency related difficulty. Now, let us talk about why you require a mechanism to control concurrency.

Consider a banking application dealing with saving and checking accounts. A Banking Transaction T1 for Mr. Sharma moves Rs.100 from his checking account balance X to his savings account balance Y, using the transaction T1:

Transaction T1:

A:  Read X

Subtract 100

Write X

B:   Read Y

 Add 100

Write Y

Let us assume an auditor wants to know the total assets of Mr. Sharma. He implements the following transaction:

Transaction T2:

Read X Read

Y Display

X+Y

Assume both of these transactions are issued concurrently, and then the implement of these instructions can be combined in many ways. This is also known as the Schedule. Let us describe this term in more detail.

A schedule S is described as the sequential ordering of the operations of the 'n' interleaved transactions. A schedule keeps the order of operations within the individual transaction.

 

                      

                   One possible schedule for interleaved execution of TA and TB

Posted Date: 3/11/2013 5:36:08 AM | Location : United States

Ask an Expert

Related Discussions:- The concurrent transactions, Assignment Help, Ask Question on The concurrent transactions, Get Answer, Expert's Help, The concurrent transactions Discussions

Write discussion on The concurrent transactions
Your posts are moderated

Write your message here..

Related Questions

Ways to suggest the dba, a)  Suppose we updated the catalog tables in real ... a)  Suppose we updated the catalog tables in real time, that is, after every update, insert, or delete SQL statement were executed-rather than only running RUNSTATS once every few

Increased overheads on update-data replication, Increased overheads on upda... Increased overheads on update : On the drawbacks side, it will need the system to ensure that all replicas of a relation are consistent. This shows that all the replicas of the rel

What is trigger, What is Trigger? Trigger: A database trigger is proced... What is Trigger? Trigger: A database trigger is procedural code which is automatically executed in response to specific events on a particular table in a database. Triggers can

What are the drawbacks of shadow-paging technique, What are the drawbacks o... What are the drawbacks of shadow-paging technique? The drawbacks of shadow paging is:- a) Commit Overhead b) Data fragmentation c)  Garbage collection

I want a professional with strong it background, I want a professional with... I want a professional with strong IT background who provide me timely assignments Project Description: I want a professional who can do my assignments for my major i.e. Infor

Keys, #questiontypes of keys examples.. #questiontypes of keys examples..

What is repository?, Problem 1 Why are the operational system keys not ... Problem 1 Why are the operational system keys not recommended for forming data warehouse primary keys? Give any two examples 2 Explain the following performance tuning techn

Express the queries in relational algebra, Question: This question refe... Question: This question refers to the database schema. a) Express the following queries in SQL: (i) Write the SQL code that will create the table Company. Your answer sh

How to deal with the authentication problem, Most computer systems authenti... Most computer systems authenticate users by asking them for the user name and password. However, the user names and passwords often can be guessed by hackers. Suggest an automated,

Weak entity, Entity types that do not have any key attribute, and therefore... Entity types that do not have any key attribute, and therefore cannot be identified independently, are known as weak entity types. A weak entity can be recognized uniquely only by