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
There are three main sources of utilities and applications for a DBMS: a. Vendor applications and utilities are given for working with or maintaining the database, and generally

What are the two integrity rules?  Ans:  The two integrity rules are: Entity Integrity Rule & Referential Integrity Rule.   Entity Integrity Rule - If the attribute A of rel

The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced

Illustrate the class diagram for class room scheduling system If in any college, the number of classrooms are limited which have to be allocated to various classes and instruct

prototype of a distributed information system for a national car part retail outlet chain.

How nulls are treated in comparison operator? Along with comparison (relational) operators, the null values are ignored as we cannot derive the relation along with the given op


Differentiate between horizontal & mixed horizontal fragmentation?

Explain nested relations? Nested relations The assumption of INF is a natural one in the bank examples we have considered. However, not all applications are best modelled

What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among