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
What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet

What are the two types of serializability? The two types of serializability is a)      Conflict serializability b)      View serializability

What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC

I am going to develop a web site to present decision tree structure. For this, I want a web application with AJAX technology to connect the database and prepare the decision tree's

First Normal Form and second normal form First Normal Form (1NF) A relation is said to be in 1NF if it having no non-atomic values and each row can give a unique combinat

Derived horizontal fragmentation: Some applications may include a join of two or more relations. If the relations are stored at dissimilar locations, there may be a major overhead

Concatenation operator Example : Printing name and job as one string as column name employees: SELECT ENAME||JOB "EMPLOYEES" FROM EMP;

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

Deletion Anomalies: Loss of important Information: In some cases, useful information may be lost when a tuple is deleted. For instance, if we delete the tuple corresponding to stu

Normal 0 false false false EN-US X-NONE X-NONE