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 a dataset? A dataset is an in-memory database that is disconnected from any regular database, but has all the significant characteristics of a regular database. Dataset

What is a SELECT operation? The select operation selects tuples that please a given predicate. We use the lowercase letter σ to denote selection.

A domain is a set of permissible values that can be given to an attribute. So each attribute in a table has a definite domain. Values to these attributes cannot be assigned outside

Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a

What are composite objects? Objects that have other objects are known as complex objects or composite objects.

Submit the table creation statements (including constraints) for the Database Model. Submit them all in a single script file. Also submit a document explaining what test data yo

construct a b-tree for the following set of key values 2,3,5,7,11,17,19,23,29,31.assume that the tree is initial empty and the values are added in ascending order

Transactions And Concurrency Management  Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

Explain concurrency control? Concurrency control Oracles multiversion concurrency control varies from the concurrency mechanism used by some other data base vendors. Read

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