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
Aggregation Aggregation is stronger form of association. It represents the "has-a" or "part-of" relationship. An aggregation association depicts a complex object which is comp

Explain weak and strong entity type ? Weak and Strong entity type: An entity set which does not have a primary key is referred to as a weak entity set. The existence of a wea

What are the object-oriented approaches Software systems which are designed with structured design methodology never support some of desired quality attributes for example reus

Define Network DBMS The NDBMS is built primarily on a one-to-many relationship, but where a parent-child representation between the data items cannot be ensured. This may occur

Task Part A. Create an ERD from a business problem. (50 marks) Read the following problem and complete the tasks listed below. THE ABS Blood Bank Australian Blood Services (ABS) i

The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

Explain Derived and Non-Derived Attribute? In few cases, two or more attribute values are related, for instance, Age and BirthDate attributes of a person. For specific person e

To eliminate duplicate rows (distinct operator)  Example: SELECT DISTINCT DEPTNO FROM EMP;

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