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
What are the several forms of identity? a) Value b) Name c) Built-in

Why, generally does an object-oriented system use the relational DBMS? The reasons for using relational DBMS for OO systems could be any combination of following: a. Many or

Define entity integrity and referential integrity.  How does SQL allow specification of  these? Ans: Entity Integrity Rule- If the attribute A of relation R is a prime attribut

Which of the operations constitute a basic set of operations for manipulating relational data? Relational algebra operations constitute a basic set of operations for manipulati

File Manager File manager handles the allocation of space on disk storage. It starts and maintains the list of structures and indices described in the internal schema that is

Security And Integrity After Reading the concepts of database recovery in the last section, let us now deal with a vital concept that helps in minimizing consistency errors in

Consider entity type Employee with attributes empNumber (this is unique), empName, and the year when he/she was hired. An employee can either be a technical employee, a marketing e


How to Insert data in your table from another table? insert into e.g, To insert tuples from employee into N_emp created above, use following statement Insert into N_emp

What is entity in DBMS? Entity: A DBMS entity is either a thing in the modelled world or a drawing element in an ERD.