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 collection of a same kind of entities is known as an Entity Set or entity type. Example: For the COLLEGE database defines earlier objects of concern are Students, Faculty,

FDs in Entities : Student entity :                                                Enrolment number →  Student name, Address Course Entity :


While using extract datasets it is required to have a special workarea for interface False.  It is not required to have a special workarea for interface

Increased parallelism : Since the replicated date has several copies a query can be distributed or can be answered from the smallest loaded site. Also, with more replicas you have

what do you mean by consistency in rdbms?

how oracle can be used

Which is a valid SQL type? A valid SQL Should be in CHARACTER it is should be NUMERIC and FLOAT.

What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on

What are the different approaches for database design? There are two basic approaches for database design which are as follows: Attribute driven: It compiles a list of att