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
How to create a table from existing table? Create table as e.g, To create a new table ‘N_emp' with employee names and their identification numbers only from employee ta

how to solve the C type problems?

What is called query processing? Query processing refers to the range of activities included in extracting data from a database.

What Command You Use What Day of the week were you born

What is called as recursive partitioning? The system repeats the splitting of the input unless each partition of the build input fits in the memory. Such partitioning is known

What are the two main goals of parallelism? Load -balance multiple small accesses, so that the  throughput of such accesses enhances. Parallelize large accesses so that the res

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

Define Catalog and meta data ? A catalog is a compilation of records elaborating the contents of a particular collection or group of collections. Metadata (Meta data, or someti

Using a labelled diagram explain the operation of the Data Warehouse, define the basic architectural components and outline the main functionalities. Briefly explain the role an op

Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server