SlideServe
Menu
Préférences
© SlideServe · v2026

Transaction Processing Systems

joyceramirez avatar
16 diapositives · 1.5K Views · Jan 04, 2020

Transaction Processing Systems. Cross-functional: crosses different functional business areas accounting  inventory transactions, human resources  direct deposit transactions finance  stock/investment transactions Transactions can include: Banking, Financial, Stocks, etc.

Transaction Processing Systems - slide 1
01 / 16Transaction Processing Systems
1 / 17

Télécharger la présentation

Transaction Processing Systems
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation
  1. Transaction Processing Systems • Cross-functional: crosses different functional business areas • accounting  inventory transactions, • human resources  direct deposit transactions • finance stock/investment transactions • Transactions can include: • Banking, Financial, Stocks, etc. • Purchases & Orders (phone, Internet, direct) • from Airline reservations to Toll Booth Operations

  2. Value of TPS • Efficiency • Paperless Transactions • Reduce manual data entry (errors) • Speed up transaction process • Elimination of redundant steps

  3. Value of TPS • Online Transaction Processing (OLTP) • Real-time systems, immediate feedback • Real-time Reports and databases updates

  4. Batch Processing transaction data are accumulated processed periodically used to be necessary because of synchronization problems Real-time Processing “online processing” immediately processed Syncronization issues What if two people order the same product at the same extact time, but there is only one product left? Batch vs. Real-time

  5. Processing Cycle Data Entry • Collecting and capturing transactions • No longer manual: • Old technologies Bar Codes, Magnetic Strips (credit cards) • New technologies RFID, Smart Cards,

  6. Processing Cycle Transaction Processing • Synchronization Issues: • Which transaction to process next. • Breaking ties • Dependencies • Can’t schedule delivery before credit approval.

  7. Processing Cycle Database Maintenance • TPS helps ensure the databases are up-to-date and correct. • TPS can control multiple tables/databases • A single purchase • decreases quantity – Inventory Tables • decrease credit – Credit Card DB (other company) • increase sales – Sales Tables

  8. Processing Cycle Document/Report Generation • Examples • purchase orders • pay checks • sales receipts • invoices • bank statements An MIS also generates reports, but TPS reports are operational (no analysis).

  9. Processing Cycle Inquiry Processing • Examples • when was a purchase made • does a customer have any credits on their account • was an item scheduled for delivery • was a package signed for An MIS also allows for inquiries, but the information available is summarized (or aggregated), i.e., What are the total sales for a whole department? What is the best selling product?

  10. Processing Cycle

  11. Invoices Products Shipped Orders Customer Places an Order Customer Actual Order ScheduleRoutes Planned Shipments Picking List Inventory Status 0 Invoicing ShipmentExecution Order EntrySales Config. Routing &Scheduling ShipmentPlanning InventoryControl

  12. Invoices Products Inventory Data Product Data Order Data Customer Data Prices Fulfilled Orders Shipped Orders CreditStatus Inventory Levels 4. NotifyCustomer 3. AuthorizeCredit 1. Collectorderinformation 2. VerifyProduct #’sIn-stock Customer Places an Order Orders Orders Customer Customer Actual Order ScheduleRoutes Planned Shipments Rejected Orders BackOrders Start of Transaction OpenOrders Picking List Notification Back Orders/Rejected Orders Orders ready to be fulfilled Inventory Status Order EntrySales Config. 0 Invoicing ShipmentExecution Order EntrySales Config. Routing &Scheduling ShipmentPlanning InventoryControl

  13. 0 Transaction Processing System • An Order Entry System affects • accounting data • inventory data • customer data • financial data • invoicing data • Enhanced Feedback: • Inventory is updated at the point of ordering, not at the point of fulfillment. Eliminates surprise backorders.

  14. 0 Enhanced Feedback • Reduce Transactions • Customer can be notified of back order before credit authorization. • Customer could cancel or change order • Avoids un-necessary transactions • Credit check/charge on an order that might be canceled.

  15. 0 Enhanced Feedback • Faster Feedback • Pricing or production levels could be set based on current inventory and order status • Increase price if production can’t keep up with orders • Decrease price if inventory levels are high.

  16. Product/Price DB InventoryDB OrderDB CustomerDB Various Reports 0 Manager MIS/DSS ChangeProductPrice Inventory Data Production Data Updates/ additions to Operational Data OrderData TSP PCS AssemblyLine CustomersGrunts