Sequential Vs Relative files Top Differences

The organization of Sequential and Relative files is different. Fixed nature is for Relative files. Fixed and variable nature is for Sequential files.

Then, how to choose the file organization? In this post, I have shared ideas for your reference.

Sequential File

A Sequential file that you can be accessed sequentially. That means you cannot supply the key. The length can be a maximum of Operating system supports.

The record can be either fixed or variable. If the incoming data is the same size always, then you can go for Sequential fixed-length.

Else, you can go for Sequential variable files

Record Can be Fixed or Variable

12345678910

1233333

2233445

1111

2222222222

2222222222222222222222222222

Advertisements

Relative File

Relative files are different. They have a relative key. But, these are only fixed in nature. That means, it creates record for full length (as per definition) by padding spaces.

The maximum length of the record usually depends on your Operating system supports.

Relative file does not support variable length records.

Record is always Fixed

12345678910

12345678910

12345678910

If you need fast access, you need to go for relative files.

Summary

Sequential files slow in response to fetch a record. Alternatively, relative files faster since they use a relative key.

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.