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
Express the ways provided by MySQL for Pattern Matching? MySQL provides two kinds of pattern matching. 1) One is based on SQL patterns 2) Regular expressions.

Question: Using the data model express the following queries in SQL. (a) Create the Table named "Cinema" and make the cinema_code to be the primary key of the relation and

create an er diagram for production management in film industry

FDs in Relationships:  Enrols Relationship: None as it is many to many Teaches Relationship : Course code → Instructor Instructor → Course code The next question is:


Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

Define cardinality and participation constraints on a relationship type, completeness constraint on generalization.        Ans: Cardinality defines the number of entities to wh

Define the terms  1) physical schema 2) logical schema.  Physical schema:  The physical schema explains the database design at the physical level, which  is  the  lowest  lev

#question.what is mapping constraints and types?.

What is indexed sequential file organization? What are the applications of this organization?  Ans: An index file can be employed to effectively overcome the problem of storing