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
A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded where poss

Making Common Behaviour Abstract Let us define abstraction "Abstraction means to focus on the necessary, inherent aspects of an entity and ignoring its accidental features". O

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Performance of Various Concurrency Control Mechanisms

When is UPDATE_STATISTICS command used? - When processing of large data is done, this command is used. - Whenever large number of modification, deletions or copy takes place


Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.

#quCreate a database design specification (Enhanced Entity Relationship Diagram (EERD) and Relational Data Model (RDM)) from the given business description. The RDM must be in 3rd

Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs

how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples