Selective replication-data replication, Database Management System

Selective replication: This is a combination of generating small fragments of relation and replicating them rather than a entire relation. The data should be fragmented on require basis of several sites, as per the frequency of use, or else data is kept at a centralised site. The aim of this strategy is to have just the benefits of the other approach but none of the drawbacks. This is the most commonly used strategy as it gives flexibility.

 

Posted Date: 3/13/2013 8:32:04 AM | Location : United States







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

Write discussion on Selective replication-data replication
Your posts are moderated
Related Questions
The Locking Protocol: To manage concurrency related problems we use locking. A lock is mainly a variable that is associated with a data item in the database. A lock can be located

State the definition of association An association is a structural relationship which specifies that objects of one thing are connected with objects of another. In UML, asso

find the name of supplier who supply some red part

why data in an RDMS need to be normalised

Define weak and strong entity sets?  Weak entity  set:  entity  set  that  do not  have  key  attribute  of  their  own are  known as weak entity sets.  Strong entity set

Explain the Relational Completeness Codd described the term relational completeness to consider to a language that is complete with respect to first-order predicate calculus ex

HOW TO SOLVE THE LP Problems by simplex method?z=x1+-3x2+2x3

The First Normal Form (1NF) Let us first describe 1NF: Definition: A relation (table) is in 1NF if 1.      There are no duplicate tuples or rows in the relation. 2.

Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server

Foreign Keys and NULL Let us take the relation:                 DEPT DEPT ID DNAME BUDGET D1 M