File organisation in dbms, Database Management System

File Organisation In Dbms


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
FitAll Ltd is a company that manufactures clothes. Its processes are manual and there are stand-alone Information Systems that aid to manage them. The Information Systems were purc

Foreign Keys and NULL Let us take the relation:                 DEPT DEPT ID DNAME BUDGET D1 M

explain concept of decomposition?

Explain recovery process after system failure using checkpoint. Ans: Checkpoint scheme or method is an extra component of the log based recovery system. This scheme is used to

sql is relationally complete-justify

The figure below depicts the conceptual diagram of a banking system. (a) Describe one example relevant to the system in figure, for each of the 4 types of enterprise appl

Define the Immediate Update The immediate update methods may apply changes to the database on disk before the transaction arrives a successful conclusion. Though, these change

What is use of generating such tables? How can you create temporary tables? When you require a table only for a short time after that you want it to disappear automatically you

Have a look around the site, and at some of the sites they have featured. These are all examples of bad design, and also offer an explanation about why they fall into this category

Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.