Inconsistent analysis-problems of concurrent transactions, Database Management System

Inconsistent Analysis: The problem as given with transactions T1 and T2 where two transactions interleave to make incorrect result during an analysis by Audit is the instance of such a problem. This problem happens when more than one data items are being used for analysis, whereas another transaction has modified some of that value and some are yet to be modified. Therefore, an analysis transaction reads values from the inconsistent state of the database those results in inconsistent analysis.

Therefore, we can conclude that the prime reason of troubles of concurrent transactions is that a transaction reads an inconsistent state of the database that has been formed by other transaction.

But how do we ensure that implementation of two or more transactions have not resulted in a concurrency related problem?

Well one of the commonest techniques used for this purpose is to restrict access to data items that are being written or read by single transaction and is being written by another transaction. This technique is known as locking.

 

Posted Date: 3/12/2013 1:52:27 AM | Location : United States







Related Discussions:- Inconsistent analysis-problems of concurrent transactions, Assignment Help, Ask Question on Inconsistent analysis-problems of concurrent transactions, Get Answer, Expert's Help, Inconsistent analysis-problems of concurrent transactions Discussions

Write discussion on Inconsistent analysis-problems of concurrent transactions
Your posts are moderated
Related Questions
Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

Submit SQL INSERT Statements that will populate the database with sample data.  You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement

What is Data Storage? The storage structures and access methods used by database system are specified by a set of explanation in a special type of DDL called data storage-defin

Index And Tree Structure Let us talk about the data structure that is used for creating indexes. Can we use Binary Search Tree (BST) as Indexes? Let us initial reconsider

Explain Network Model in DBMS? Network Model - It was formalised within the late year of 1960s through the Database Task Group of the Conference on Data System Language (DBTG

What is the main advantage of the object model? What are its different components? The object model focuses on the logical data structures. Each object model comprises of many

Normalize the following tables upto and including the 3NF. Submit a 1 page printout of only the final set of normalized tables in Data Architect. Just use Data Architect to do the

List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view

Difference between Operating System and Database Security Security within the operating system can be executed at various levels ranging from passwords for access to system, t

client server architeutre