INF2004F Summary Notes.docx

Problem possible loss of segregation of duties and

Info icon This preview shows pages 5–7. Sign up to view the full content.

Problem- possible loss of segregation of duties and audit trail - Transaction logs/ transaction registers log all inputs into a special file that contains tags to identify transactions - Tagging- additional audit-orientated information included with original transaction data Transaction processing Information systems - process data generated from business transactions (e.g. booking a ticket) Carry out day-to-day transactions Collect, capture, process, edit, update, store data Supply necessary information to the organisation – enable organisation to function properly Processing system: NB* Transaction file – collection of transaction input data, usually temporary data e.g. sales journal Master file – permanent data or data of continuing interest e.g. accounts receivable master file- becomes permanent database Reference file – necessary data to support data processing (aka. Table file) e.g. payroll tax files Transaction Processing System (TPS): Collects and stores data about transactions Focuses on keeping records and controlling repetitive processes TPS characteristics: Rapid processing – data available for all parties speedily Reliability of processing – transactions processed are reliable and accurate Standardisation – processed in a standard manner for efficiency Controlled access – only relevant and authorised parties can access ACID requirements: Atomicity – completed in full Consistency – consistent with defined rules & standard manner Isolation – transactions processed concurrently should be equal to transactions processed sequentially Durability – once complete, cannot be undone/reversed Batch processing vs Real time transaction processing Batch processing - (delayed processing) process data periodically in batches (groups of data) - 2 types of batch processing: sequential file (files processed in sequence) and random file processing 1. - Prepare the transaction file- additional editing and validation- sort in same sequence as master file - Updating the master file- read records in both files one by one, match and write to new master file - Updating the general ledger- to reflect changes in master file - Preparing general ledger reports- trial balances and other reports produced 2. Random Access file updating - instead of taking one transaction file after another, this system works out the most effective way of processing this many files i.e. access files using some criteria
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

- A record is read from a transaction file - The key value of the transaction record is used to randomly access the related record in the master file - The record in the master file is updated in memory and rewritten back to the data file Advantages: Large repeated works processed quickly without user interaction Manage large repeated work easily Can work offline – less stress on processor & hardware No need for special hardware and system support to input data Disadvantages: Unknown time (time delays)
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern