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
Describe log based recovery The most usably structure for recording data base modification is the LOG the log is a sequence of log records recording all the update activities i

What is a database? Database - Basically in simple terms A database is a collection of inter related data and/or information stored so which it is available to several users

what is file organization? what are file organization techniques.explain in detail? explain random file organization technique, multikey file organization technique?what is indexin

What is a hashing function?  What are the properties of a good hashing function?  Describe the folding technique for hashing functions.      Ans:  Hashing function is a method

Describe the two types of methods for retrieving rows in Python? Fetchone()- Returns the next row as a sequence Fetch all()- Returns the entire result set like a strin

Question: (a) Use the following business rules to produce the E-R diagram. You should clearly show all the minimum and maximum cardinality constraint on each side of the relati

Explain degree of relation? Degree of a Relation - The degree or arity of a relation is the number of attributes n of its relation schema.

Determine Which is not a consequence of concurrent operations? Ans: Update anomaly.

Mention the type of constraints we can specify in the CREATE command of DDL. The type of constraints that can be specified are as follows:- PRIMARY KEY, NOT NULL, UNIQUE, FOR

Define Signal. It allows methods to respond to events triggered by themselves or by other processes. Each signal corresponds to an exacting event. A signal is represented in Sy