130 likes | 147 Views
INTRODUCTION TO TRANSACTION PROCESSING SYSTEM. EXAMPLES. Advantages of TPS. Rapid Processing Reliability Standardisation Controlled access.
E N D
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 • Produce timely documents and reports • Increase labour efficiency
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 SystemsVarious 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
TRADITIONAL TPS WERE CENTRALIZED AND RUN ON A MAINFRAME • TODAY… MAINFRAMES CLIENT/SERVER SYSTEM CLUSTER OF SERVERS, EACH SERVER RUNNING MULTIPLE PROCESSORS
Transaction Processing SystemsTPS SOFTWARES • SOCIAL SOFTWARES • ANTI-SPYWARE • PRIVACY-INVASIVE SOFTWARE • CUSTOMER INTEGRATED SOFTWARES e.g.P18 • SERVICE ORIENTED SOFTWARES e.g.SAT • BROKERAGE SOFTWARES
Customer Makes a Purchase Inventory Files POS Terminal Terminal File Product Processing System Department Sales Files Master Files Transaction Processing SystemsTypical Tasks