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
A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded where poss

Question (a) Visual Basic is governed by an event processor. Explain the meaning of this phrase. (b) Differentiate between an general procedure and event procedure. (c)

What is known as clustering file organization? In the clustering file organization, records of several dissimilar relations are stored in the similar file.

Single-Valued Dependencies A database is a collection of related information and it is therefore inevitable that some items of information in the database would depend on some

Data Handling and Research Methods: The dataset encompassing 130 participants contains several variables measuring detrimental health related behaviours referring to the use o

What are the different strategies of implementation of the Statecharts?  There are two strategies for implementation of state charts: i)   Basic Implementation Strategy

What is Conceptual Schema? Conceptual Schema - Conceptual schema elaborates the structure of the overall database for a community of users. It hides the details of physical sto

Explain What is Relation? A database relation is a predefined row or column format for storing information in a relational database. Relations are equal to tables.

The entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No o

Consider a database schema consisting of four relations, whose schemas are: Product (maker, model, type) PC (model, speed, ram, hd, price) Laptop (model, speed, ram, hd, s