An overview of transaction processing systems
1 / 21

An Overview of Transaction Processing Systems - PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

An Overview of Transaction Processing Systems. Transaction Processing Systems (Operational level). A transaction is any business-related exchange e.g. payments to employees, sales to customers, payments to suppliers.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentationdownload

An Overview of Transaction Processing Systems

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

An overview of transaction processing systems

An Overview of Transaction Processing Systems

Transaction processing systems operational level

Transaction Processing Systems (Operational level)

  • A transaction is any business-related exchange e.g. payments to employees, sales to customers, payments to suppliers.

  • Transaction processing system (TPS) - an organized collection of people, procedures, software, databases, and devices used to record completed business transactions.

  • To understand a TPS is to understand basic business operations and functions.

Transaction processing systems operational level1

Transaction Processing Systems (Operational level)

  • Bottom managers e.g. a manager at a supermarket, must identify, collect and register all transactions and events when sales are made, and when goods are shipped.

  • Financial data on account receivables/payables, payrolls, cash receipts must be recorded as they occur.

Tps operational is

TPS (operational IS)

  • TPS support the most fundamental, basic business operations of the organization; as it records every detail of each transaction.

  • TPS can be manual or automated.

  • TPS is the earliest use of computers to reduce costs by automating routine, repetitive, labour-intensive business procedures.

  • E.g. ATMs, supermarket’s check-out cashiers, use of smart card technology in transportation, fast food stores etc.

A payroll transaction processing system

A Payroll Transaction Processing System

Benefits of automated tps

Benefits of automated TPS

  • Reduced cost: less labour/personnel

  • Increased speed (operational efficiency): processing is faster

  • Increased accuracy: less typing mistakes, error-free input and processing.

  • Increased quality customer service: faster response to customer’s queries or needs, 24-hour access to information.

  • Increased data for decision making: serve as the foundation for DSS; as TPS collects & stores all transactional data into the databases.

Traditional transaction processing methods by computers

Traditional Transaction Processing Methodsby computers

  • Batch processing – processing of business transactions are accumulated over a period of time and prepared for processing later as a single unit. Some time delay between the occurrence of transaction and the actual processing of the transactions.

  • Previous slide has some e.g. of batch processing.

  • On-line transaction processing (OLTP) - processing of each transaction is done immediately and the affected records are updated.

E g of on line processing

E.g. of on-line processing

  • Stock market exchange: transactions of buying/selling of stocks are processed instantly.

  • Airline reservation systems, especially cheap or budget airline tickets which are usually sold on airline’s website.

  • Gambling: soccer or horse racing bets can be placed on appropriate websites and processed immediately.

  • Suitable for more urgent transactions that require data updated quickly.

Batch versus on line processing

Batch versus On-Line Processing

E g of tps in 4 business functions

E.g. of TPS in 4 business functions

Integrated tps s in a financial accounting system and its major components

Integrated TPS’s in a financial accounting system and its major components

Typical inputs and outputs of an accounts receivable tps

Typical inputs and outputs of an accounts receivable TPS

  • Inputs:

    • payments, sales orders, adjustments (returns)

  • Outputs:

    • customer statements, aging reports, schedule of accounts receivable

Typical inputs and outputs of an accounts payable tps

Typical inputs and outputs of an accounts payable TPS

  • Inputs:

    • purchase orders, payments, adjustments (returns)

  • Outputs:

    • checks to creditors, list of bills due, schedule of accounts payable

Data processing activities common in all tpss

Data Processing Activities Common in all TPSs

Data collection in tps

Data collection in TPS

  • captures and gathers all necessary data to complete transactions.

  • Data must be recorded at its source accurately, in a timely fashion and automatically with minimal manual effort.

  • Automated input devices e.g. barcode scanners at libraries, point-of-sale cashiers at supermarkets

Data editing in tpss

Data editing in TPSs

  • Detects for any errors in input data

  • Performs validity and completeness checking in input data

  • E.g. quantity and cost data must be in numeric,

  • E.g. names must be alphabetic

Data correction in tpss

Data correction in TPSs

  • If input data is invalid, TPS should give appropriate error messages so that corresponding corrections can be made.

  • Data correction involves reentering mis-keyed or mis-scanned data.

Data manipulation in tpss

Data Manipulation in TPSs

  • The actual processing inside the TPS such as calculations and data transformations related to the transactions.

  • E.g. classifying data, sorting data in categories, performing calculations, summarizing results

Data storage in tpss

Data Storage in TPSs

  • Update one or more databases with new transactional data.

  • Once the update process is complete, this data can be further processed and used by other types of information systems e.g. MIS, DSS for tactical decision making or strategic planning.

Document or report production in tpss

Document or report production in TPSs

  • TPSs produce important business documents about the transactions.

  • Documents can be hardcopy or displayed on computer screens.

  • E.g. paychecks of a payroll system,

  • E.g. receipts of an order processing system,

  • E.g. outstanding balance report for invoices for an accounts receivable TPS.

Characteristics of tps

Characteristics of TPS

  • Repetitive – transactions repeat daily, weekly, or monthly.

  • Predictable – information always has expected results e.g. customers are billed for what they purchased in a month.

  • Emphasis on the past – information describes past activities e.g. payroll output describes employee’s past work pay.

  • Detailed nature - output information is very detailed e.g. paychecks have details on the worksheet of each employee’s gross and net pay.

  • Structured form – input and output data format are structured, e.g. data on time cards are carefully formatted in identical fashion.

  • Great accuracy – input and output data to/from TPS must be accurate and carefully checked.

  • Login