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
Gyan Gurukul is a software company that provides software related solution. Ashutosh Dubey who is the director of Gyan Gurukul want a three-level schema architecture for the Gyan G

Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

What is Nested Trigger? A trigger can also having INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause ano

As with other software, databases can potentially be used for unethical purposes. As a database developer, and a consumer, you should recognize database misuse, and how it may affe

Ask question #MinimThe Georgia Tech Library (GTL) has approximately 16,000 members, 100,000 titles, and 250,000 volumes (an average of 2.5 copies per book). About 10 percent of the

What is multiple relationship ?

Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order

Consider a table student (std_id, std_name, date_of_birth, percent_marks, dept_name). Write a QBE query to display names of Computer Science department students who have scored mo

Explain forms based and graphical interface? Forms based and graphical interface: graphical user interface (GUI) is a kind of user interface which permits people to interact

Query Processor The query language processor is responsible for taking query language statements or shifting them from the English-like syntax of the query language to a form