This report will discuss problems and solutions to transaction processing (TP) systems.
A brief introduction to the issue by defining and describing a transaction and a TP system is to give here before beginning with the core discussion.
A transaction in general implants changes made in the real world in a physical database [1]. There-fore business transactions are multiple basic operations involving exchanges (cash, credit, informa-tion) that have financial implications, such as customer placing an order or someone paying parking tickets and they establish a connection between an organization and its database [3]. A TP system is a form of data base management system that processes business transactions [1]. Usually there exit several different systems in one organization. Examples of TP applications are payroll, inventory, order processing, reservations, account processing in banks, and stock trading [3]. Considering the highly increased volume of transactions processed by organizations due to the credit card revolution and the Internet and their need to process the transactions in a timely fashion there arise several problems and performance constraints to the transaction processing and its systems, which need to be addressed. To identify a certain performance of a TP system the Input/Output (I/O) of a system is a adequate measure.
In the following it will be assumed that the organizations already provide of Transaction Processing Facilities (TPF), that Main Memory Database Systems (MMDS) are not practical, that most TP sys-tems are already distributed [i.e. that the organization have implemented a Distributed Database Management System (DDMS)] and finally that the organizations have the fastest available comput-ers & networks already installed.
Inhaltsverzeichnis (Table of Contents)
- I. Introduction
- II. Problems to Transaction Processing Systems
- III. Solutions to Transaction Processing Systems
Zielsetzung und Themenschwerpunkte (Objectives and Key Themes)
This report analyzes the challenges and solutions associated with transaction processing (TP) systems in organizations. It examines the limitations of traditional TP systems, particularly regarding the management of high transaction volumes. The report delves into the problems encountered with Transaction Processing Facilities (TPF) and Distributed Database Management Systems (DDMS), exploring their performance constraints and operational complexities.
- Performance Constraints of TP Systems
- Limitations of Traditional TPF
- Challenges of DDMS Implementation
- Solutions for Enhancing TP System Performance
- Alternative Approaches to High-Volume Transaction Processing
Zusammenfassung der Kapitel (Chapter Summaries)
- I. Introduction: This chapter introduces the concept of transaction processing systems and defines the key elements of a transaction, including the relationship between business transactions and organizational databases. The chapter highlights the growing need for efficient TP systems due to increased transaction volumes driven by factors like the credit card revolution and the Internet.
- II. Problems to Transaction Processing Systems: This chapter explores the challenges associated with managing high transaction workloads in TP systems. The limitations of traditional TPF are discussed, particularly its inability to handle large transaction volumes and its reliance on application programmers for file and resource management. The chapter further analyzes the problems posed by DDMS, including its size, communication overheads, reliability concerns, and expansion difficulties.
- III. Solutions to Transaction Processing Systems: This chapter focuses on addressing the problems identified in the previous chapter. The chapter explores various solutions, including enhancing TPF capabilities with a data management system, a network management system, and a transaction management system. The chapter also discusses the benefits and drawbacks of implementing a message-based architecture for TPF. It then explores the Tandem approach to high-volume transaction processing, highlighting its strengths in terms of development environment, high availability, linear growth, and centralized/distributed capabilities. The chapter delves into the key elements of the Tandem approach, such as its message-based interface, automatic transaction logging, and requestor-server architecture. It emphasizes the importance of granularity in system design and discusses the benefits of replicating data for disaster recovery. The chapter also discusses techniques for reducing disk I/O associated with transactions and converting random I/O to sequential I/O.
Schlüsselwörter (Keywords)
This report focuses on key concepts within the realm of transaction processing systems, encompassing the challenges of managing high transaction volumes, the limitations of traditional TPF and DDMS, and proposed solutions for enhancing system performance. The report delves into the areas of data management, network management, transaction management, message-based architecture, fault-tolerant storage, and disaster recovery. It explores alternative approaches like the Tandem approach, highlighting its characteristics of granularity, high availability, and linear growth.
- Quote paper
- Christian Rodiek (Author), 2006, Problems and Solutions to Transaction Processing Systems, Munich, GRIN Verlag, https://www.grin.com/document/68140
