There are two major types of fragmentation: Horizontal& Vertical. Horizontal fragments, as the name suggests are subsets of tuples and vertical fragments are subsets of attributes (refer to Figure ).

                  

                                                    Figure: Horizontal and Vertical Fragmentation

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

Ask an Expert

Related Discussions:- There are two major types of fragmentation, Assignment Help, Ask Question on There are two major types of fragmentation, Get Answer, Expert's Help, There are two major types of fragmentation Discussions

Write discussion on There are two major types of fragmentation
Your posts are moderated

Write your message here..

Related Questions

I need help on the following 5 questions, 1. Define and discuss Work Breakd... 1. Define and discuss Work Breakdown Structure, Critical Path Analysis, PERT charts and GANTT charts. Describe the role of each in determining scope, budgets, and schedules? What

Determine the steps of path in association network, Determine the steps of ... Determine the steps of path in association network You can analyse use of paths in association network in the following steps:  Examine every operation and see what asso

I want simple visual basic script, I want a script that will run, and updat... I want a script that will run, and update my virtual machine's LAN settings (proxy server and port), and also re-configure the Firefox User Agent. I want a script that will run,

Relational DB, Suppose R is a relation with attributes A1, A2,..., An. As a... Suppose R is a relation with attributes A1, A2,..., An. As a function of n, tell how many superkeys R has, if: 1.1 The only key is A1. 1.2 The only key is A1 and A2. 1.3 The o

Trigger , Flights(FlightNo, DeptDateTime, Origin, ArrivalDateTime, Destinat... Flights(FlightNo, DeptDateTime, Origin, ArrivalDateTime, Destination, Capacity, SoldSeats) Tickets(FlightNo, Seat, CustID) Where - flightNo is the PK of the flights table - DeptDa

Access, I have to solve a problem using access I have to solve a problem using access

Replicating data, Replicating Data One approach that may support effici... Replicating Data One approach that may support efficient access to dissimilar applications as above may be to give access to every of the applications from dissimilar replicate

Failures and recovery, Failures and Recovery In practice various things... Failures and Recovery In practice various things might occur to prevent a transaction from completing. Recovery methods are used to bring database, which does not satisfy consi

What is meant by mean time to failure, What is meant by mean time to failur... What is meant by mean time to failure? The mean time to failure is the amount of time that the system could run continuously without failure.

Mobile database, write short note on mobile database write short note on mobile database