Liew Woei Song Muhammad Hofiz Achoson Introduction Transaction Processing System What is a TPS an information system designed to process routine business transactions seeks time and costefficiency by automating repetitive operations in large volumes ID: 244566
Download Presentation The PPT/PDF document "Transaction Processing System" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Transaction Processing System
Liew
Woei
Song
Muhammad Hofiz AchosonSlide2
Introduction
Transaction Processing SystemSlide3
What is a TPS?
an information system designed to process routine business transactions
seeks time- and cost-efficiency by automating repetitive operations in large volumes
interfaces with an organization’s other information systems, such as IRS, DSS, EIS
centers around accounting and finance transactions
e.g
,, airline reservation systems, order entry/processing systems, bank’s account processing systemsSlide4
examples of transaction processing systems
The components of a transaction processing system, including:
1. users of the information system as belonging to the same
organization
that owns the transaction processing system
2. participants as the people who conduct the information processing
3. people from the environment becoming participants in real time systems as they directly enter transactions and perform validation
Examples of real time transaction processing, including:
1. reservation systems; 2. point of sale terminal;3. library loans
Examples of batch processing, including:
1. clearing of presented
cheques
; 2. generation of bills;
3. systems that appear real time,
computerising
transactions as they occur, but actual updating is processed in batch, such as credit card transactions.Slide5
Characteristic
Transaction Processing SystemSlide6
Performance
Fast performance with a rapid response time is critical. Transaction processing systems are usually measured by the number of transactions they can process in a given period of time.Slide7
Reliability
The system must be available during the time period when the users are entering transactions. Many organizations rely heavily on their TPS; a breakdown will disrupt operations or even stop the business.Slide8
Data Integrity
The system must be able to handle hardware or software problems without corrupting data. Multiple users must be protected from attempting to change the same piece of data at the same time, for example two operators cannot sell the same seat on an airplane.Slide9
Ease of Use
Often users of transaction processing systems are casual users. The system should be simple for them to understand, protect them from data-entry errors as much as possible, and allow them to easily correct their errors.Slide10
Modular Growth
The system should be capable of growth at incremental costs, rather than requiring a complete replacement. It should be possible to add, replace, or update hardware and software components without shutting down the system.Slide11
Type
Transaction Processing SystemSlide12
Real-Time Processing
Transactions may be collected and processed as in batch processing.
Transactions
will be collected and later updated as a batch when it's convenient or economical to process them.
Historically
, this was the most common method as
the information
technology did not exist to allow real-time processing.
This
is the immediate processing of data
.
It
provides instant confirmation of a transaction.
It
may involve a large number of users who are simultaneously performing transactions which change data.
Because
of advances in
technology,
real-time updating is possible.
Batch
ProcessingSlide13
For videoSlide14
storing/retrieving in transaction processing systems
Storage of data in relational and flat-file databases in
digital form as it has the ability to manipulate, store and retrieve along with process and display with digital technology.
Data, is for large companies collected in batched format
Retrieval of stored data to conduct further transaction is usually warehoused.
Sequential, indexed sequential and hashed files generally store the data in databases.
Transaction Processing SystemsSlide15
storing/retrieving in transaction processing systems
Sequential data storage
are
data
records one after the other in entry or key field order, header stores and field order of each record in a data dictionary with a search completed using either
binary
or
linear.
Indexed sequential data storage
are
records stored in any order and with a separate index file, keeping matching key field items with the records position. This is faster, but continual updates to index file requires two files which must be maintained.
Hashed file storage
will
divide the disk space into numbered locations, with key field. At the time that they are divided by the total locations a remainder is provided as storage location.
Transaction Processing SystemsSlide16
storing/retrieving in transaction processing systems
data warehousing
is the collection of data from a range of data sources.
Transaction Processing SystemsSlide17
Data Input
Data Processing
Output Generation
Data Storage
A Transaction Processing ModelSlide18
Barcode Scanner
POS
TPS
UPC
Product
DB
Inventory
DB
Information
Reporting System
Customer
Receipt
Exception
Reports
UPC
Price
UPC
&
Quantity
Product, Quantity,
Date, Time,
Price
POS(Point Of Sale) TPS
Purchasing
DB
Quantity,
Date,
TimeSlide19
Transaction
Data
Data
Processing
Trans.
File
New
Master
File
Old
Master
File
Documents/
Reports
Batch ProcessingSlide20
On-line Processing
On-line
Data
Processing
Documents/
Reports
Transaction
Data
Inquiries/
Reponses
Transaction
Data
Transaction
DataSlide21
TPS Applications
Order Processing
Purchasing
Accounts Receivables & Accounts Payables
Receiving & Shipping
Inventory on Hand
Payroll
General LedgersSlide22
IS 533 - Transactions
22
Transaction states and additional operations
(continued)
ACTIVE
PARTIALLY
COMMITTED
FAILD
TERMINATED
COMMITTED
BEGIN
TRANSACTION
END
TRANSACTION
COMMIT
ABORT
ABORT
Figure 19.4
State transition diagram illustrating the states for transaction execution
READ
/
WRITESlide23
Recovery Procedure
Transaction Processing SystemSlide24
Why recovery need?
There is various reason leak fail transaction :
Computer
failure
Transaction error
Concurrent control enforcement
Physical problem
A hardware, software, or network error occurs in the computer
system during transaction execution.
Some operations in the transaction may cause it to fail
The concurrency
control method may decide to abort the transaction.
Natural disaster ,theft , fire ,
etcSlide25
How system recovery the transaction?
TPS will go through recovery of database which involve backup, journal, checkpoint, and recovery manager
Journal: contain transaction logs and database change logs
Checkpoint: consists of the transaction start, terminate, commit or abort