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
Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b

Describe file organisation? A file is organized logically as a sequence of records. These records are mapped onto disk blocks. A) Fixed-Length Records Type deposit=record

What is SQL Profiler? SQL Profiler is a graphical tool that permits system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save dat

Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in o

comparison of oracle RDBMS with MySQL

Define outer union operation of the relational algebra. Compute the outer union for the relations R and S given below. Outer Join - If there are any values in one tabl

Question 1 What do you mean by database management system? Question 2 Write a note on Object-Oriented Model Question 3 Explain Sequential File Organization Question

Association as a cache This association must be updated when any new element is added to it, but testing for overlap using association is more efficient.    Figure:

why are older data models are being replaced by new data models

What is a database? Database - Basically in simple terms A database is a collection of inter related data and/or information stored so which it is available to several users