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
List and also explain the dissimilar stages of DDLC ?

Question: This Question refers to the database schema given in the Appendix. (a) The integrity of a database is enforced by integrity rules. Discuss what should happen on a

What is the purpose of storage manager? The storage manager is responsible for the following a) Interaction with the file manager b) Translation of DML commands in to low

What Is Sql?  Structured Query Language (SQL) is a standard query language. It is usually used with all relational databases for data manipulation and definition. All the re

Describe Application programming interface? Application Programming Interface - Commercial SQL implementations take one of the two primary techniques for involving SQL in a p


Improved Reliability: In a centralised DBMS, a server failure stops the operations of the DBMS. Though, a failure at single site of a DDBMS, or a failure of a communication link cr

Ask Write the SQL code that will create the table structure for a table named EMP _1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in

Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i

Consider the relations EMPLOYEE(emp#, name) ASSIGNED_TO(project#, emp#) PROJECT(project#, project_name, chief) Express the subsequent queries in Relational Algebra (i) Ge