Sequential File Organization in DBMS

Sequential File Organization

This method is very simple in that the files are stored one by one (or one after another) in a stored manner.

There are two ways to implement this method....

i) Pile file method

ii) stored file method

i) Pile file method

This method is very simple in which we store the records in a sequential manner. This means that one by one in the order in which they are included in the co-table

ii) Sorted file Method 

The method itself suggests as a name that wherever a new record is to be inserted it is always inserted in a sorted form (A&D). The beginning of a record or data can be based on a primary key or another key.

New Records: -

Advantages and Disadvantages of sequential file Organization

Advantages

1. Fast and efficient method for massive amounts of data.

2. Simple design.

3. The file can be easily stored in a secondary storage system.

Disadvantages

1. Time-consuming We cannot jump on particular records and we have to walk in a sequential manner which takes time.

2. The stored file method is disabled such that it takes time and space to record.

Next Topic ➧ Indexed Sequential File Organization (ISFO)

 

Note: How did you like "Sequential File Organization in DBMS" post? Do let us know through comments. And share it with your friends too