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

Ask an Expert

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

Write your message here..

Related Questions

I want to get database of a website, Project Description: I would like t... Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering

List the armstrong axioms for functional dependencies, List the Armstrong's... List the Armstrong's axioms for functional dependencies.  What do you understand by soundness and completeness of these axioms?      Ans: The Armstrong's axioms are: F1:

The internal or physical level in dbms, The Internal or Physical Level ... The Internal or Physical Level The collection of files permanently stored on secondary storage devices is called as the physical database. The internal or physical level is t

How to rearrange the execution order for efficiency, Rearrange the Executio... Rearrange the Execution Order for Efficiency  Rearranging execution order for efficiency means executing such job that requires less execution time. By rearranging the object

Which two files are used during operation of the dbms, Which two files are ... Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.

Define instance and schema, Define instance and schema? Instance: Colle... Define instance and schema? Instance: Collection of data stored in the data base at a certain moment is Schema: The overall design of the data base is known as the data base

Database, How many physical thing? How many physical thing?

Tables, does tables are called relations does tables are called relations

Er diagram, a publishing company produce scientific books on various subjec... a publishing company produce scientific books on various subjects. the books are written by authors who specialize in one particular subject. the company employs editors who, not n

Determine the object-oriented design process, An object-oriented design pro... An object-oriented design process  1. Define the context and modes 2. Designs the system architecture 3. Identifies the principal system objects 4. Identifies concurrency in