File organisation and its types, Database Management System

File Organisation And Its Types

 Just as arrays, trees, lists and other data structures are used to execute data Organisation in main memory, a number of planning's are used to support the Organisation of data in secondary memory. A file organisation is a method to organise data in the secondary memory. In this part, we are concerned with obtaining data representation for files on external storage devices so that need functions (e.g. update, retrieval,) may be carried out efficiently.

File Organisation is a way of arranging the records in a file when the file is accumulated on the disk. Data files are organized so as to facilitate access to records and to make sure their efficient storage. A tradeoff among these two requirements generally exists: if rapid access is needed, more storage is needs to make it possible. Selection of File Organisations is reliant on two factors as shown below:

  • Typical DBMS applications require a small subset of the DB at any given time.
  • When a portion of the data is required it must be located on disk, copied to memory for processing and rewritten to disk if the data was modified.

A file of record is likely to be accessed and modified in a various ways, and dissimilar ways of arranging the records enable dissimilar operations over the file to be carried out efficiently. A DBMS supports various file Organisation techniques. The main task of the DBA is to choose a good Organisation for every file, based on its type of use.

The definite organisation most suitable for any application will depend upon such factors as the part of external storage available, number of keys, types of queries allowed,  mode of retrieval and mode of update. The Figure shows different file organisations based on an access key.

 

 

 

                              1375_File organisation and its types.png

 

                                        Figure : File Organisation techniques

Posted Date: 3/7/2013 6:10:51 AM | Location : United States







Related Discussions:- File organisation and its types, Assignment Help, Ask Question on File organisation and its types, Get Answer, Expert's Help, File organisation and its types Discussions

Write discussion on File organisation and its types
Your posts are moderated
Related Questions
What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application? Enterprise Resource Planning (ERP) is an information system used in manuf

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

It is mandatory that for every table in the LDB hierarchy there should exist one GET statement in the report. False.  It is not essential.

What are the kinds of Strings?  -A binary string in MySQL is one that MySQL treats as case sensitive in comparisons. -A non binary string in MySQL is one that MySQL does'nt

Transactions And Concurrency Management  Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

What is Secondary Index While making the index, generally the index table is kept in the primary memory (RAM) and the main table, because of its size is keeps in the secondary

What are the drawbacks of shadow-paging technique? The drawbacks of shadow paging is:- a) Commit Overhead b) Data fragmentation c)  Garbage collection

Lack of standards and experience: The lack of standards has considerably limited the potential of distributed DBMSs. As well, there are no tools or methodologies to help users cha

It is not possible to make an ABAP/4 program, which having only Subroutines. False. We can make ABAP/4 program, which having only Subroutines.

Two Phase Locking (2PL) The two-phase locking protocol having of two phases: Phase 1 : The lock acquisition phase : If a transaction T needs to read an object, it wants to