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
In an E-R diagram an entity set is represent by? In an E-R digram entity set is represted by rectangle.

What is a Linked Server? Linked Servers is a method in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With

Consider the 1ollowin8 relation: CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., crui

List the Armstrong's axioms for functional dependencies.  What do you understand by soundness and completeness of these axioms?      Ans: The Armstrong's axioms are: F1:

Determine Which is not a consequence of concurrent operations? Ans: Update anomaly.

System Design: An Object Oriented Approach Any software systems always try to change and evolve as technology and business rules evolve. The development of information systems

Describe relational model? Structure of relational data base Basic structure Database schema Keys Schema diagram Query languages

What are stored and derived attributes? Stored attributes: The attributes keeps in a data base are known as stored attributes. Derived attributes: The attributes that are de

Your friend owns and operates a wholesale shoe business with annual revenues of $5 million dollars. His wholesale business specializes in supplying and supporting retailers with sh

Consistency error : These errors happen due to the inconsistent state of database caused may be due to wrong implementation of commands or in case of a transaction abort.  To overc