INTRODUCTION TO TRANSACTION PROCESSING SYSTEM EXAMPLES Advantages of













- Slides: 13

INTRODUCTION TO TRANSACTION PROCESSING SYSTEM

EXAMPLES

Advantages of TPS • Rapid Processing • Reliability • Standardisation • Controlled access

• The disadvantage is that there is a chance of double booking. Also, transaction processing systems need to use direct acess files, serial access media such as magnetic tape cannot be used. Disadvantages in Real Time TPS – – • CONCURRENCY ATOMICITY Disadvantages in Batch TPS – – – CHEQUE CLEARANCE BILL GENERATION CREDIT CARD TRANSACTIONS

ORGANISATION’S EXPECTATION FROM TRANSACTION PROCESSING SYSTEM • Process data generated by and about transactions • Maintain a high degree of accuracy and integrity

Continued…… • Help provide increased service • Help build and maintain customer loyalty • Achieve competitive advantage

Aspects of TPS relevant to “A large retail company” • Real-time transaction processing • Manual transaction systems • Components of a TPS • Credit card sales transactions • Database and files

Transaction Processing Systems Various TPS Technologies • Some TPS Technologies – Online Transaction Processing (OLTP) • Allows managers to run client-server transactions to obtain some information of interest e. g. CICS – Web-based Transaction Processing • Similar to OLTP • Allows managers to run transactions via the web – Object-Oriented Transaction Monitors (OTM) • Objects that monitor transactions in web-based applications • When an activity happens within a web site, the object sends a query to the data warehouse to record information about what happened (e. g. , customer checked out) • Customer integrated systems

FILES IN TPS • MASTER FILE • TRANSACTION FILES • REPORT FILE • WORK FILE • PROGRAM FILE

HARDWARES FOR TPS PHYSICAL ARTIFACTS AND TECHNOLOGY

• TRADITIONAL TPS WERE CENTRALIZED AND RUN ON A MAINFRAME • TODAY… MAINFRAMES CLIENT/SERVER SYSTEM CLUSTER OF SERVERS, EACH SERVER RUNNING MULTIPLE PROCESSORS

Transaction Processing Systems TPS SOFTWARES • • SOCIAL SOFTWARES ANTI-SPYWARE PRIVACY-INVASIVE SOFTWARE CUSTOMER INTEGRATED SOFTWARES e. g. P 18 • SERVICE ORIENTED SOFTWARES e. g. SAT • BROKERAGE SOFTWARES

Transaction Processing Systems Typical Tasks Customer Makes a Purchase POS Terminal File Product Processing System Master Files Inventory Files Department Sales Files