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
Secondary Indexes Let consider the student database and its clustering index and primary (only one will be applicable at a time). Now consider the state when the database is to

What are data models? Explain it detail? Entity relationship model Rectangles Ellipse Diamonds Lines Relational model Relational model use a collection

1. Determine that the Checkpoints are a part of  Ans: Checkpoints are a part of Recovery measures

In how many parts events are classified Events are classified as four types in UML 1.  Signals 2.  Calls 3.  Passing of Time 4.  Change in State

Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp

What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape

Regional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively. Additi

Identify the need and use of data control through problem solving, illustration

Dependency Preservation It is obvious that the decomposition must be lossless so that we do not lose any information from the relation that is decomposed. Dependency preservati

Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t