3.4 storing and retrieving in transaction processing systems

In this stem you will learn about: 

  • storage of digital data in databases and files
  • retrieval of stored data to conduct further transaction processing such as printing invoices
  • systems to store paper records of transactions
  • data backup and recovery, including:
    • –  grandfather, father, son
    • –  off-site storage
    • –  secure on-site storage
    • –  full and partial backups
    • –  recovery testing
    • –  suitable media
    • –  specialised backup software
    • –  transaction logs
    • –  documenting backup and recovery procedures
    • –  mirroring
    • –  rollback 


A TPS requires an efficient method for the storage and retrieval of data. Data is stored in a database or a data warehouse. The data storage system requires well designed backup and recovery procedures.