Increased overheads on update-data replication, Database Management System

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 relation require to be updated at the similar time, resulting in increased overheads. For instance, in a banking system, if account information is replicated at several sites, it is essential that the balance in a particular account should be the similar at all sites.

The problem of controlling concurrent updates by various transactions to replicated data is more difficult than the centralised approach of concurrency control. The management of replicas of relation can be simplified by deciding one of the replicas as the primary copy. For instance, in a banking system, the primary copy of an account may be the site at which the account has been opened. Likewise, in an airline reservation system, the primary copy of the flight may be related with the site at which the flight originates.

Posted Date: 3/13/2013 8:30:46 AM | Location : United States

Related Discussions:- Increased overheads on update-data replication, Assignment Help, Ask Question on Increased overheads on update-data replication, Get Answer, Expert's Help, Increased overheads on update-data replication Discussions

Write discussion on Increased overheads on update-data replication
Your posts are moderated
Related Questions
A database is a set of data. But, is the data kept in a database trustworthy? To answer that query we must first answer the question. What is integrity? Integrity simply means t

find a name whose address is erode from student table

Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

Explain the concept of QBE? Query-by-example represents a visual/graphical approach for accessing information in a database by the use of query templates called as skeleton tab

#question. acompani datdbase needs to store information about employees (identified by a social security number,with salary and phone as attributes) and departments (identified by

Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran

Describe the algorithm to draw the dependency graph?   Ans: Algorithm to draw Precedence Graph is like this: a.  For every transaction T i participating in schedule S, make

What benefits can a company gain by managing its own information infrastructure and servicea

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

Explain the Cartesian product:  The Cartesian product operation does not need relations to union-compatible.  The meaning of this is that the involved relations may have dissim