File organisation in dbms, Database Management System

File Organisation In Dbms

Introduction

Databases are used to store information. Usually, the principal operations we have to perform on database are those relating to:

  • Retrieving data
  • Creation of data
  • Modifying
  • Removing some information which we are sure is no longer useful or valid.

We have seen that in terms of the logical operations to be done on the data, relational tables give a good mechanism for the entire over tasks. Thus the storage of a database in a computer memory (on the hard disk, of course), is mainly concerned with the following issues:

  • They require storing a set of tables, where every table can be stored as an independent file.
  • The attributes in a table are closely related and, thus, often accessed together. Thus it makes sense to store the dissimilar attribute values in every record contiguously. In fact, is it essential that the attributes must be stored in the similar series, for each record of a table?
  • It seems logical to store all the records of a table contiguously. Though, since there is no prescribed order in which records must be stored in a table, we may choose the series in which we store the dissimilar records of a table.

We shall see that the point (iii) between these observations is quite needful. Databases are used to store information in the form of files of records and are typically stored on magnetic disks. This section focuses on the file Organisation in DBMS, the access methods available and the system parameters related with them. File Organisation is the way the files are in order on the disk and access method is how the data can be retrieved based on the file Organisation.

Posted Date: 3/7/2013 2:34:24 AM | Location : United States







Related Discussions:- File organisation in dbms, Assignment Help, Ask Question on File organisation in dbms, Get Answer, Expert's Help, File organisation in dbms Discussions

Write discussion on File organisation in dbms
Your posts are moderated
Related Questions
After going by the database architecture, let us now dwell on an important query: how is the data organised in a database? There are a lot of basic structures that exist in a datab

What are axioms? Axioms or rules of inference give a simpler technique for reasoning about

What is the use of integrity constraints? Integrity constraints make sure that changes made to the database by authorized users do not result in a loss of data consistency. The

What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?         Ans: A few transaction will must rolled back (made a victim)

Describe Interfaces for the DBA? Interfaces for the DBA - Most database systems holds privileged commands which could be used only through the DBA's staff. These involves com

Normalize the following tables upto and including the 3NF. Submit a 1 page printout of only the final set of normalized tables in Data Architect. Just use Data Architect to do the

Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

discuss the purpose of the concurrency control?

Explain the Difference between DROP and DELETE DELETE deletes one or more than one tuples of a particular relation from the database. DROP is employed to remove a table from th

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