Increases efficiency-data fragmentation, Database Management System

Increases efficiency: Data is stored close to most often used site, therefore retrieval would be faster. Also, data that is not required by local applications is not stored, therefore the size of data to be looked into is smaller.

 

Posted Date: 3/13/2013 8:34:48 AM | Location : United States







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

Write discussion on Increases efficiency-data fragmentation
Your posts are moderated
Related Questions
Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

Explain heap file with advantages? Heap File is an unordered set or a group of records, stored on a set of pages. This class gives basic support for inserting, updating, select

what benefit can a company gain by managing its own infrasture and services

Define According to the levels of abstraction, the schema at the intermediate level is called  Ans: As per to the levels of abstraction, the schema at the intermediate level is

Explain the two constraints, check and foreign key in SQL along with an example for each. Give the syntax. CHECK constraint - CHECK constraint specifies an expression which

What is a data dictionary? Data Dictionary is a main source of data in a data management system.  Its major function is to carry the creation and management of data definition

What are the two types of blocks in the fixed -length representation? Define them. Anchor block: Have the first record of a chain. Overflow block: Have the records other tha

What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.


Attributes having a one value for a particular entity. For instance, Age is a single valued attribute of a student entity. Attributes  that  have  more  than  single  values