Skip to main content
NSWInformation Processes and TechnologySyllabus dot point

What are the characteristics of a transaction processing system and how does batch processing differ from real time processing?

Describe the characteristics of transaction processing systems and compare batch processing with real time processing, including data integrity and recovery

A focused answer to the HSC Information Processes and Technology option dot point on transaction processing systems. Batch versus real time processing, data integrity, validation, backup and recovery, and the traps markers look for.

Generated by Claude Opus 4.76 min answer

Reviewed by: AI editorial process; not yet individually human-reviewed

Have a quick question? Jump to the Q&A page

What this dot point is asking

NESA wants you to describe what makes a transaction processing system (TPS) distinctive and to compare the two main ways it processes data: batch and real time. You also need to explain how a TPS protects data integrity and recovers from failure, because these systems handle the high-volume, mission-critical transactions an organisation depends on.

The answer

What a TPS does

A transaction is a single logical piece of business activity, such as a sale, a deposit or a seat booking. A transaction processing system captures, processes, stores and reports these transactions. It is usually the foundation system of an organisation, feeding data to higher-level systems such as decision support. The defining features are high volume, repetition of similar transactions, a need for speed, and an absolute need for accuracy, because errors in money or stock are costly.

Characteristics of a TPS

  • High transaction volume processed reliably and consistently.
  • Strong validation and accuracy, since each transaction affects money, stock or records.
  • Concurrency, with many users transacting at once against shared data.
  • Robust storage with backup and recovery, because the data is the lifeblood of the business.
  • A clear audit trail recording who did what and when.

Batch processing

In batch processing, transactions are collected over a period and stored, then processed together as a group at a scheduled time. A payroll run that processes every employee's pay at the end of a fortnight is batch processing. Its strengths are efficiency (the system can run the heavy job overnight when demand is low) and simplicity. Its weakness is that the stored data is not current between runs: until the batch is processed, the master file does not reflect the latest transactions.

Real time processing

In real time (or online transaction) processing, each transaction is processed immediately as it occurs, updating the master data at once. An airline reservation system must process a booking instantly so the same seat is not sold twice, and an ATM must update a balance the moment cash is withdrawn. Real time processing keeps data always current, which is essential where decisions depend on up-to-the-second information, but it demands more processing power and a continuously available system.

Comparing the two

The choice depends on how current the data must be. If transactions can be accumulated and processed later without harm (monthly billing), batch is cheaper and simpler. If every query must see the latest state and conflicts must be prevented (seat booking, banking), real time is required. Many organisations use both: real time capture at the point of sale, with batch reporting overnight.

Data integrity

Data integrity means the data is accurate, consistent and complete. A TPS protects it with validation (range, type and check digit tests on input), concurrency control (locking a record while one user updates it so two updates do not clash), and verification at the source. Because many users hit shared data at once, concurrency control is especially important: without it, two simultaneous withdrawals could both read the same balance and overdraw an account.

Backup and recovery

Because a TPS holds critical data, it must survive failure. A transaction log records every transaction as it happens. If the system crashes, recovery uses the most recent backup plus the log to restore the data: roll forward reapplies completed transactions recorded in the log after the backup, and rollback undoes incomplete transactions so the database returns to a consistent state. Regular backups, ideally stored off site, underpin this process.

Exam-style practice questions

Practice questions written in the style of NESA exam questions on this dot point, with worked answer explainers. The year tag is the paper they imitate, not the source.

2019 HSC4 marksCompare batch processing and real-time processing in terms of their advantages and disadvantages. Include an example of each in your answer.
Show worked answer →

"Compare" at 4 marks wants similarities and differences plus an example of each.

Batch processing collects transactions into a group and processes them together later (for example end-of-day payroll, or overnight bank statement runs).

  • Advantages: efficient use of computer resources, can run in off-peak times, lower processing cost.

  • Disadvantages: data is not up to date between runs, so there is a delay before records reflect the transactions.

Real-time processing handles each transaction immediately as it occurs (for example an ATM withdrawal or an airline seat booking).

  • Advantages: data is always current, so decisions and balances are accurate instantly.

  • Disadvantages: needs more processing power and constant availability, so it is more expensive and complex.

Both update the same data, but the key difference is timing - grouped and delayed versus immediate. Markers reward an advantage and disadvantage of each plus a valid example of each.

2020 HSC3 marksJustify a situation where batch processing is appropriate.
Show worked answer →

"Justify" at 3 marks means name a situation and give reasons it suits batch processing.

Situation: an organisation's weekly or fortnightly payroll, where many employees' pay must be calculated and paid at once.

Justification:

  1. The transactions do not need to be processed instantly - pay is only required on payday, so collecting them and processing together is acceptable.

  2. Processing a large group at once is efficient and cheaper, and can run overnight when the system is otherwise idle.

  3. The data is stable and predictable (hours, rates), so accuracy is not affected by the delay.

Other valid examples include monthly utility billing or end-of-day bank statement updates. Markers reward a clear scenario plus reasons that the delay is acceptable and grouping is efficient.

2021 HSC3 marksJustify a situation where real time processing is essential.
Show worked answer →

"Justify" at 3 marks means name a situation and explain why immediate processing is essential there.

Situation: an airline seat reservation system (or an ATM cash withdrawal).

Justification:

  1. Records must update instantly so the same seat is not sold to two customers - a delay would cause double-booking and errors.

  2. The customer needs immediate confirmation to complete their booking and payment, so batch processing later would be unworkable.

  3. Data integrity depends on every transaction being reflected at once across all access points, which only real-time processing provides.

Other valid examples include EFTPOS payments and online banking. Markers reward a scenario where any delay would cause incorrect results or conflicts, justifying real-time processing.