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
Create centralized relational database using bottom up method.   (a) Recognize a single un-normalized relation for the above scenario.          (b) Recognize the primary key for

Question : Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriente

Question (a) Differentiate between the following terms: (i) Distributed Database v/s Distributed Database management System (ii) Homogeneous Distributed Database v/s Hete

How can you terminate the MySQL Server? Typing the following in Command prompt will shut down the server completely as root user % mysqladmin -u root -p shutdown

I need solution of the question posted at http://www.expertsmind.com/questions/sql-query-for-testing-triggers-and-stored-procedures-30140149.aspx

Provide Examples of different types of Time and Date formats.  It's most common store dates using a dash (-) as a colon (:)and the delimiter as the time delimiter. The given fo

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

Define union compatibility? Explain why INTERSECTION of two relations cannot be performed if they are not union compatible? Two relations R(A1, A2,-------, An) and S(B1, B2,--

What is a block and a block number? A block is a contiguous sequence of sectors from a single track of one platter. Every request specifies the address on the disk to be refere

This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not