Transaction Processing System

100 %
0 %
Information about Transaction Processing System

Published on March 11, 2014

Author: inam12



An introduction to TPS.

Transaction Processing System, Characteristics and Processing Cycle Inam Ul-Haq Lecturer in Computer Science UE, Okara Campus, MIS,UniversityofEducation,OkaraCampus 1

MIS,UniversityofEducation,OkaraCampus 2 Transactions • Transactions… • Basic business operations such as customer orders, purchase orders, receipts, time cards, invoices, and payroll checks in an organization • A business activity between seller and buy to exchange an asset for payment. • Transaction processing systems (TPS) • A computerized system that performs and records the daily routine transactions necessary to the conduct of the business • Perform routine operations and serve as a foundation for other systems • A Transaction MIS (at operational level) • Question: a person using ATM machine is an example of TPS?

MIS,UniversityofEducation,Okara Campus 3 Batch vs. On-Line Transaction Processing • Two types of TPS: • Batch processing • A system whereby business transactions are accumulated over a period of time and prepared for processing as a single unit or batch • Manufacturing products, supply chain, salaries • On-line transaction processing (OLTP) • A system whereby each transaction is processed immediately, without the delay of accumulating transactions into a batch • Real-time transaction • Mostly in Online shopping • Uses PCI cards(Payment Card Industry: MasterCard, Visa, Maestro, American Express, Discover, ) • Paypal or WorldPay, WePay, eWay, ICEPAY,

MIS,UniversityofEducation,Okara Campus 4 Batch vs. On-Line Transaction Processing (Online TPS)

MIS,UniversityofEducation,Okara Campus 5 Batch vs. On-Line Transaction Processing (Batch Processing)

MIS,UniversityofEducation,OkaraCampus 6 Symbolic Representation of Payroll System

MIS,UniversityofEducation,OkaraCampus 7 Order Fulfillment Process

MIS,UniversityofEducation,Okara Campus 8 Functions of TPS • Input Functions • Place an order for LUNCH • Processing Functions • Pizza is being prepared and served • Output Functions • Go to counter for payment, show discount cards, get invoice

Characteristics of TPS • Performance • Rapid Processing : customers can’t wait for TPS to respond. • Reliability: Breakdown will disrupt or stop business • E.g.Banking, Financial, Stocks, Airline reservations • Consistency: All parties must agree on facts of exchange • Atomicity: All operations fail or succeed • Data Integrity • TPS is primarily concerned with data integrity • Efficiency • Paperless Transactions • Reduce manual data entry (errors) • Speed up transaction process • Elimination of redundant steps MIS,UniversityofEducation,OkaraCampus 9

Objectives of TPS MIS,UniversityofEducation,OkaraCampus 10 • Ensure data and information integrity and accuracy • Produce timely documents and reports • Increase labor efficiency • Help provide increased and enhanced service • Help build and maintain customer loyalty • Achieve competitive advantage

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

Corporate databases of internal data Databases of external data Databases of valid transactions Operational Databases (CRM) Transaction processing systems MIS Decision support systems Executive support systems Expert systems Business transactions Input and error list Drill-down reports Exception reports Demand reports Key-indicator reports Scheduled reports Employees Corporate intranet Application databases UniversityofEducationOkaraCampus 12 App databases, uses Oracle built over MySQL Schematic View (Cont.)

Processing Cycle Database Maintenance • TPS helps ensure the databases are up-to-date and correct. • Multiple databases (internal & external) • A single purchase • decreases quantity – Inventory Database • decrease credit – Credit Card Database • increase sales – Sales Database MIS,UniversityofEducation,OkaraCampus 13

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). MIS,UniversityofEducation,OkaraCampus 14

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? MIS,UniversityofEducation,OkaraCampus 15

Processing Cycle MIS,UniversityofEducation,OkaraCampus 16

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 (out-of-stock products). MIS,UniversityofEducation,OkaraCampus 17

Add a comment

Related presentations

Related pages

Transaction processing system - Wikipedia, the free ...

A Transaction Processing System (TPS) is a type of information system that collects, stores, modifies and retrieves the data transactions of an enterprise.
Read more

What is a Transaction Process System (TPS)? - Definition ...

Transaction Process System TPS Definition - A transaction process system (TPS) is an information processing system for business transactions involving the...
Read more

Online Transaction Processing – Wikipedia

Online Transaction Processing Online-Transaction-Processing (OLTP), ... Die Effizienz von OLTP-Systemen ist dabei von der Auswahl geeigneter Hardware ...
Read more

Transaction processing - Wikipedia, the free encyclopedia

Transaction-processing systems ensure database integrity by recording intermediate states of the database as it is modified, then using these records to ...
Read more

Transaction Processing System (TPS - Scribd - Read books ...

Transaction Processing System (TPS) • Whenever two people make an exchange, it is called a transaction. Transactions are important events for a company ...
Read more

Transaction Processing Systems Explained - Cheap laptops ...

Help, what are Transaction Processing Systems? Looking to define the term Transaction Processing Systems or find suppliers, providers, vendors and ...
Read more

Transaction Processing Systems (TPS): Batch and Real-Time ...

Transaction processing systems capture and process the detailed information necessary to update data on the fundamental operations of an organization.
Read more

HSC Information Processing and Technology/Transaction ...

Characteristics of Transaction Processing Systems. TRANSACTION PROCESSING SYSTEMS- collect, store, modify and retrieve the transactions of an organisation.
Read more

What is Transaction Processing?

What is Transaction Processing? In Chapter 1, you were introduced to the concepts behind transaction processing. But you may still be wondering just what ...
Read more

Transaction processing - IBM - United States

Transaction processing from IBM includes a family of application servers, connectors and tools that provide industrial-strength, online transaction ...
Read more