Derived horizontal fragmentation, Database Management System

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 in processing the join. In this type of cases, it may be more appropriate to make sure that the relations or fragments of relations that are joined together are at the similar location. We can get this using derived horizontal fragmentation.

After Reading the basis of concepts relating to distributed database systems, let us outline the process of design of distributed database systems.

 

 

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







Related Discussions:- Derived horizontal fragmentation, Assignment Help, Ask Question on Derived horizontal fragmentation, Get Answer, Expert's Help, Derived horizontal fragmentation Discussions

Write discussion on Derived horizontal fragmentation
Your posts are moderated
Related Questions
What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.

Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

In a Hierarchical model of data records are organized ? In the hierarchical model of data records are organized as Tree structure.

CREATE TABLE prodtrans ( pno number (4) ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5) FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);

What is 2NF? A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.

What is Collation Collation is a kind of sort order. There are majorly 3 types of sort orders, namely: i.) Dictionary case insensitive ii.)Dictionary - case sensitive

sir, could anybody help me in getting complete information about the mentioned topic

What is an Index? An index is a small table having only two columns. The first column has a copy of the primary or candidate key of a table and the second column having a set o

Create a view emp_dep containing e_name and number of dependents from the tables employee and dependent of (i) CREATE VIEW emp_dept AS SELECT ename, COUNT(*) FROM employee, dep

A table joined with itself is called ? A table joined with itself is known as self join table. Normal 0 false false false EN-IN X-NONE X-NONE