Designing Transaction Processing System For A Business Organization

ABSTRACT

A transaction processing system is a type of information system. TPSs collect, store, modify, and retrieve the transactions of an organization. A transaction is an event that generates or modifies data that is eventually stored in an information system. To be considered a transaction processing system the computer must pass the ACID test. The essence of a transaction program is that it manages data that must be left in a consistent state, e.g. if an electronic payment is made, the amount must be both withdrawn from one account and added to the other; it cannot complete only one of those steps. Either both must occur, or neither. In case of a failure preventing transaction completion, the partially executed transaction must be 'rolled back' by the TPS. While this type of integrity must be provided also for batch transaction processing, it is particularly important for online processing: if e.g. an airline seat reservation system is accessed by multiple operators, after an empty seat inquiry, the seat reservation data must be locked until the reservation is made, otherwise another user may get the impression a seat is still free while it is actually being booked at the time. Without proper transaction monitoring, double bookings may occur. Other transaction monitor functions include deadlock detection and resolution (deadlocks may be inevitable in certain cases of cross-dependence on data), and transaction logging (in 'journals') for 'forward recovery' in case of massive failures

TABLE OF CONTENTS

CERTIFICATION PAGE

DEDICATION

ACKNOWLEDGEMENT

ABSTRACT

CHAPTER ONE

1.0 INTRODUCTION

1.1BACKGROUND OF STUDY

1.2STATEMENT OF PROBLEM

1.3PURPOSE OF STUDY

1.4IMPORTANCE OF STUDY

CHAPTER TWO

2.0 LITERETURE REVIEW

CHAPTER THREE

3.0 Contrasted with batch processing

3.1 Real-time and batch processing

3.2 TXSeries for Multiplatform

CHAPTER FOUR

4.0 Transaction Processing Systems

CHAPTER FIVE: CONCLUSION

5.1LIMITATION OF STUDY

5.2SUGGESTION FOR FURTHER RESEARCH

5.3 REFERENCES