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
Describe entity referential integrity and integrity. Give an example of each. Entity Integrity Rule - If there is a attribute A of relation R is a prime attribute of R then A

Consider the following six relation schemes and their corresponding sets of functional dependencies. In each case identify a. All the candidate keys b. The highest normal for

Define Fifth Normal form is concerned with Ans : Fifth Normal form is concerned with Join dependency.

Example:  //REVOKE ALL ON EMP FROM MCA12;                              (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-


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

Define the terms i) DDL ii) DML DDL: Data base schema is particular by a set of definitions expressed by a special language known as a data definition language. DML: A data


Write short note on Data models? Data models: A data model is an abstract model which elaborates how data is represented and accessed. The term data model has two commonly ac

What do you understand by RAID? Explain RAID Level 4 and Level5? RAID - It is stands for Redundant Array of Inexpensive Disks (as named by the inventor), or alternatively Re