Data fragmentation, Database Management System

Data Fragmentation

"Fragmentation includes decomposing the data in relation to non-overlapping component relations".

Why do we require fragmenting a relation?

 

Posted Date: 3/13/2013 8:32:25 AM | Location : United States







Related Discussions:- Data fragmentation, Assignment Help, Ask Question on Data fragmentation, Get Answer, Expert's Help, Data fragmentation Discussions

Write discussion on Data fragmentation
Your posts are moderated
Related Questions
Ask Write the SQL code that will create the table structure for a table named EMP _1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in

What is an ER diagram? Why is it used in Database management system (DBMS)?

State the Component Diagram A component diagram represents a set of component and relationships among them. In a dynamic model, component diagram is used to model physical com

What is Secondary Index While making the index, generally the index table is kept in the primary memory (RAM) and the main table, because of its size is keeps in the secondary

What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

Determine the language that needs a user to specify the data to be retrieved with no specifying exactly how to get it is Ans: Non-Procedural DML

Define granularity, hierarchy of granularity of locks & multiple granularity locking. Explain the modified two phase locking along with multiple granularity locking. Ans: The s

coventions for displaying an ER schema as ER diagram

Give the levels of data abstraction? There are three levels of Data Abstraction a) Physical level b) logical level c) view level

Ask questApollo Hospitals (AH) is a popular medical service provider in Oman. AH wants to automate its business functions into an information system. The proposed information syst