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

Can a stored procedure call itself, Can a stored procedure call itself or r... Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible? Yes. Because Transact-SQL supports recursion, you can write kept proced

Database Management System, assignment assignment

Microeconomic, anyone have a textbook solutions case fair, 8 edition of vo... anyone have a textbook solutions case fair, 8 edition of vol 1 ?, please give me

Relational database model, diagrams and meaning diagrams and meaning

What is dml compiler, What is DML compiler? DML Compiler: Translates DM... What is DML compiler? DML Compiler: Translates DML statements in a query language within low level instructions understandable through the query evaluation engine. Attempts to

Create a database, Project: Microsoft Access You have been asked by the ... Project: Microsoft Access You have been asked by the ABC Tanning Salon to create a database that can be used to track the salon's customers.  You are to create a table in Access

Why do you go for sorting your query results, Why do you go for sorting you... Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order

Exclusive lock, Exclusive lock It is asked for by a transaction on... Exclusive lock It is asked for by a transaction on a data item that it wants to update. No other transaction can put either a shared lock or an exclusive lock on a dat

Write the sql code, Express the following queries in SQL: (a) Write the... Express the following queries in SQL: (a) Write the SQL code that will create ALL the four tables given in the appendix. Your answer should not contain the primary key and

What is cardinality ratio, What is Cardinality Ratio? Cardinality Rati... What is Cardinality Ratio? Cardinality Ratios - The cardinality ratios for relationship kinds specifies the maximum number of relationship instances in which an entity can pa