Increased parallelism-data replication, Database Management System

Increased parallelism: Since the replicated date has several copies a query can be distributed or can be answered from the smallest loaded site. Also, with more replicas you have greater chances that the required data is found on the site where the transaction is implementing. Hence, data replication can minimise movement of data among sites.

Posted Date: 3/13/2013 8:29:54 AM | Location : United States

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

Write discussion on Increased parallelism-data replication
Your posts are moderated
Related Questions
One-way Associations When an association is traversed only in the one direction, then it is implemented as a pointer attribute which contains an object reference. If mu

Explain view in RDBMS? View - A view is a relation (virtual rather than base) and could be used in query expressions, which is, queries can be written by using the view as a re

Describe the algorithm to draw the dependency graph?   Ans: Algorithm to draw Precedence Graph is like this: a.  For every transaction T i participating in schedule S, make

Sparse and Dense Indexes These indexes in principle are the similar as that of indexes used at the back of the book. The key facts of the indexes are: They are arranged

What are the advantages of having an index structure?      Ans: The index structures commonly provide secondary access paths, which offer alternative ways of accessing the reco

Define tuple variable? Tuple variables are used for comparing two tuples in the same relation. The tuple variables are explained in the from clause by way of the as clause.

What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage

Explain the integrity constraints: Not Null,  Unique, Primary Key with an example each. Is the combination 'Not Null, Primary Key' a valid combination. Justify. Not Null - Shou

external and internal mapping with examples

client server architeutre