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

What was the method in which records are physically stored, What was the me... What was the method in which records are physically stored in a specified order according to a key field in each record ? A method in which records are physically stored within

Limitations of file based system, Limitations of File Based System The... Limitations of File Based System The file-based system has some limitations. The limitations are listed as follows: Isolation and separation of data: When the data is

What is the difference between primary key and a unique key, What's the dif... What's the difference between a primary key and a unique key? Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default prim

What subschema expresses, What subschema expresses ? A subschema expres... What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)

Explain recovery process after system failure, Explain recovery process aft... Explain recovery process after system failure using checkpoint. Ans: Checkpoint scheme or method is an extra component of the log based recovery system. This scheme is used to

Types of locks, Types of Locks There are two necessary types of locks: ... Types of Locks There are two necessary types of locks: Binary lock : This locking mechanism has two states for to a data item: locked or unlocked Multiple-mode loc

ER diagram , ER diagram on cosmetics ER diagram on cosmetics

Evaluate the bulleted list of information-related items, Critically evaluat... Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

Multi-key file organisation, Multi-Key File Organisation In this part, ... Multi-Key File Organisation In this part, we will introduce two basic file Organisation schemes that permit records to be accessed by more than one key field, therefore, allowi

Hass, waht is a repeating group? waht is a repeating group?