An overview of transaction processing systems
1 / 21

An Overview of Transaction Processing Systems - PowerPoint PPT Presentation

  • Uploaded on

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 Presentation

PowerPoint Slideshow about 'An Overview of Transaction Processing Systems' - yana

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

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.

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.

Typical inputs and outputs of an accounts receivable tps
Typical inputs and outputs of an major componentsaccounts 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 major componentsaccounts payable TPS

  • Inputs:

    • purchase orders, payments, adjustments (returns)

  • Outputs:

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

Data collection in tps
Data collection in TPS major components

  • 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 major components

  • 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 major components

  • 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 major components

  • 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 major components

  • 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 major components

  • 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 major components

  • 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.