Importance of file organisation in database, Database Management System

Importance Of File Organisation In Database

To execute a database efficiently, there are various design tradeoffs needed. One of the most vital ones is the file Organisation. For instance, if there were to be an application that need only sequential batch processing, then the use of indexing methods would be pointless and wasteful.

There are various important consequences of an inappropriate file Organisation being used in a database. Therefore using replication would be wasteful of space besides posing the trouble of inconsistency in the data. The wrong file Organisation can also-

  • Mean much larger processing time for modifying the required record or retrieving.
  • Want undue disk access that could stress the hardware

Needless to say, these could have a lot of undesirable consequences at the user level, such as making some applications impractical.

 

Posted Date: 3/8/2013 6:18:22 AM | Location : United States







Related Discussions:- Importance of file organisation in database, Assignment Help, Ask Question on Importance of file organisation in database, Get Answer, Expert's Help, Importance of file organisation in database Discussions

Write discussion on Importance of file organisation in database
Your posts are moderated
Related Questions
INTRODUCTION Databases and database systems have become an essential part of our daily life. We encounter many activities that involve some interaction with a database almost


What is meant by software and hardware RAID systems? RAID can be executed with no change at the hardware level, using only software modification. Such RAID implementations are

Explain four causes for failures in data warehouse projects

What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.

i want answers this assignment now if yiu can maket for me now ?

A customer places orders for parts and belongs to a particular industry group. An individual order is taken by a particular sales representative on a specific date and the sales re


define normalisation and functional dependency

Draw an ER diagram for company''s database schema