File Organisation and Access Methods: Serial, Sequential, Direct and Random

Think of a playlist on a cassette tape versus songs on your phone. On the tape you must wind past every song to reach the one you want; on the phone you tap it and it plays straight away. Computer files work in a similar way. How records are organised in a file decides how they can be accessed, and that decides which applications the file suits.

Build on what you learned in Forms 1–3

These Lower School ICT posts cover the basics of this topic:

In this post:

  • Records, fields and files (a quick reminder)
  • Serial file organisation
  • Sequential file organisation
  • Direct and random access
  • Choosing a file organisation: archiving, payroll and real-time systems

A quick reminder: records and files

A file is a collection of related records. Each record is made up of fields. For example, a school’s student file has one record per student, with fields such as Student ID, Name, Form and Date of birth. A key field (e.g. Student ID) uniquely identifies each record.

Serial file organisation

  • Records are stored one after the other in the order they arrive – no sorting.
  • To find a record, the computer must read from the start until it finds it (serial access).
  • New records are simply added to the end, so writing is quick.
  • Example: a shop’s transaction log during the day, recording each sale as it happens.

Sequential file organisation

  • Records are stored one after the other in order of a key field (e.g. by Employee ID or alphabetically by name).
  • Access is still from the start, record by record, but because the records are sorted, processing all of them in order is efficient.
  • Adding a record in the middle means rewriting the file.
  • Example: a payroll master file sorted by Employee number.

Magnetic tape can only be accessed serially/sequentially, because the tape must be wound past the earlier data.

Walls of magnetic tape reels at the U.S. Department of Agriculture’s Washington Data Processing Center (1960s). Data on tape must be read in order, from the beginning of the reel.
Walls of magnetic tape reels at the U.S. Department of Agriculture’s Washington Data Processing Center (1960s). Data on tape must be read in order, from the beginning of the reel.

Image source: File:Magnetic tape library at USDA.jpg

Direct and random access

  • With direct access, the computer can go straight to a record without reading the ones before it. The record’s key is used to work out (or look up in an index) where it is stored.
  • Random access means records can be reached in any order, each in about the same time. In everyday use and in most CSEC answers, direct and random access mean much the same thing: jump straight to the record.
  • Needs a direct-access storage device such as a hard disk, SSD or flash memory – not tape.
  • Example: an airline booking system finding seat 14C on tomorrow’s flight to Barbados instantly.

Video: File Access Methods Explained: Sequential, Direct & Indexed (Beginner's Guide) – https://www.youtube.com/watch?v=q1f2hizy3_M

Choosing a file organisation

ApplicationBest organisation / accessWhy
Archiving (long-term storage of old records, e.g. last year’s school records, old bank statements)Serial or sequential, often on magnetic tapeRecords are rarely needed, so slow access is fine; tape is cheap and holds a lot
Payroll (paying every employee at the end of the month)SequentialEvery record is processed, in order, in one batch run – no need to jump around
Real-time systems (ATMs, airline/hotel booking, supermarket price look-up)Direct / randomA single record must be found immediately while the customer waits

The key question to ask is: “Will I process most of the records at once, or do I need one record quickly?” Most of them at once → sequential. One quickly → direct.

See also Serial, Sequential, Direct (Random) Access and Archive.

Try it: Choose the file organisation

For each application, choose the most suitable way of organising and accessing the file.

A bank’s ATM checking one customer’s balance
Producing monthly pay slips for all 200 workers in employee-number order
Storing ten-year-old tax records on tape
A hotel checking if room 204 is free tonight
Logging each sale at a cash register as it happens, unsorted

Related

Related: my class video on serial, sequential and direct (random) access

Paper 1 practice (multiple choice)

Choose the best answer for each question. Try them all before you check.

1. In a sequential file, records are stored
(A) in the order they arrive
(B) in order of a key field
(C) at random positions
(D) in a separate index only

2. Which file organisation is MOST suitable for an airline booking system?
(A) Serial
(B) Sequential
(C) Direct
(D) Archive on tape

3. Which storage medium allows ONLY serial/sequential access?
(A) Hard disk
(B) Magnetic tape
(C) SSD
(D) Flash drive

4. A payroll file is usually processed sequentially because
(A) only one record is needed at a time
(B) all records are processed in order in one run
(C) records are never updated
(D) it is stored on a flash drive

5. Records added to the end of a file in the order they arrive, with no sorting, form a
(A) serial file
(B) sequential file
(C) direct file
(D) index

Show answers

1. B
2. C
3. B
4. B
5. A

Paper 2 practice (structured question)

A credit union keeps records of its members. It uses one file to print a monthly statement for every member and another to let tellers look up a member’s balance while the member waits.

(a) Distinguish between serial and sequential file organisation. (2 marks)

(b) State the most suitable file organisation for printing the monthly statements, and give a reason. (2 marks)

(c) State the most suitable file access method for the tellers’ look-ups, and give a reason. (2 marks)

(d) The credit union keeps old statements for seven years. Suggest a suitable storage medium and file organisation for these records, with a reason. (2 marks)

Total: 8 marks

Show answers

(a) Serial – records stored one after another in the order they are added/unsorted (1); sequential – records stored in order of a key field (1).

(b) Sequential (1) – every member’s record is processed in order in one batch run (1).

(c) Direct/random access (1) – the teller needs one member’s record immediately without reading all the others (1).

(d) Magnetic tape with serial/sequential organisation (1) – records are rarely accessed so slow access is acceptable, and tape is cheap with large capacity (1).

Next: Types of Computer Networks: LAN, MAN, WAN and Mobile Networks

Syllabus link: This post is relevant to the CSEC® Information Technology Syllabus (CXC 30/G/SYLL 17), Section 1: Computer Fundamentals and Information Processing, Specific Objective 15 (“select appropriate file organisation for particular application”).

Attributions to media used in this post:

© 2026 Vedesh Kungebeharry. All rights reserved.

Archive

Information technology systems produce data that is usually recorded or stored.  This information is used to make  strategic decisions to capitalize on  opportunities, and tactical decisions to improve efficiency.

As time passes on, some of the older recorded data becomes less useful in decision making and is accessed infrequently. In this case, we make an archive of this data.

Definition: An archive is a historical copy of information that is important to an organization.

Archives can be used to look back on past decision making, or to gain a better understanding of an organization’s history.

Computer output on microfilm and magnetic tape can be used for archival purposes.

File access

The data is usually stored onto the tape in the order it was exported from the original system, and may be to some extent in sequential form.

However, after many years the original system’s data structure may change and differs from the sequence on tape.

This means that when searching for a record for research purposes, all the data must be examined because the tape’s data structure may be forgotten or unknown; thus making it a serial access medium.

External Video

Archives in a business context:

https://www.youtube.com/watch?v=a-x2IUZVhAE

Credit:

Business Archives Council of Scotland

@businessarchivescouncilofs40

https://www.youtube.com/@businessarchivescouncilofs40

Creating Digital Archives

https://www.youtube.com/watch?v=X53N86nP3lk

Credit:

The British Library

@britishlibrary

https://www.youtube.com/@britishlibrary


updated 26th November 2022 – Added external Video section

(last updated 4th October 2019)

© 2019  Vedesh Kungebeharry. All rights reserved.