Transaction Processing System

1. Transaction Processing System,
Characteristics and Processing Cycle
Inam Ul-Haq
Lecturer in Computer Science
UE, Okara Campus
[email protected], [email protected]
M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
1

2. M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
2
Transactions
•Transactions…
•Basic business operations such as customer orders, purchase orders,
receipts, time cards, invoices, and payroll checks in an organization
•A business activity between seller and buy to exchange an asset for
payment.
•Transaction processing systems (TPS)
•A computerized system that performs and records the daily routine
transactions necessary to the conduct of the business
•Perform routine operations and serve as a foundation for other
systems
•A Transaction MIS (at operational level)
•Question: a person using ATM machine is an example of TPS?

3. M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f
E
d
u
c
a
t
i
o
n
, O
k
a
r
a

C
a
m
p
u
s
3
Batch vs. On-Line Transaction
Processing
•Two types of TPS:
•Batch processing
•A system whereby business transactions are accumulated over a
period of time and prepared for processing as a single unit or
batch
•Manufacturing products, supply chain, salaries
•On-line transaction processing (OLTP)
•A system whereby each transaction is processed immediately,
without the delay of accumulating transactions into a batch
•Real-time transaction
•Mostly in Online shopping
•Uses PCI cards(Payment Card Industry: MasterCard, Visa, Maestro,
American Express, Discover, )
•Paypal or WorldPay, WePay, eWay, ICEPAY,

4. M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f
E
d
u
c
a
t
i
o
n
, O
k
a
r
a

C
a
m
p
u
s
4
Batch vs. On-Line Transaction
Processing
(Online TPS)

5. M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f
E
d
u
c
a
t
i
o
n
, O
k
a
r
a

C
a
m
p
u
s
5
Batch vs. On-Line Transaction
Processing
(Batch Processing)

6. M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
6
Symbolic Representation of Payroll System

7. M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
7
Order Fulfillment Process

8. M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f
E
d
u
c
a
t
i
o
n
, O
k
a
r
a

C
a
m
p
u
s
8
Functions of TPS
•Input Functions
•Place an order for LUNCH
•Processing Functions
•Pizza is being prepared and served
•Output Functions
•Go to counter for payment, show discount cards, get invoice

9. Characteristics of TPS
•Performance
•Rapid Processing : customers can’t wait for TPS to respond.
•Reliability: Breakdown will disrupt or stop business
•E.g.Banking, Financial, Stocks, Airline reservations
•Consistency: All parties must agree on facts of exchange
•Atomicity: All operations fail or succeed
•Data Integrity
•TPS is primarily concerned with data integrity
•Efficiency
•Paperless Transactions
•Reduce manual data entry (errors)
•Speed up transaction process
•Elimination of redundant steps
M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
9

10. Objectives of TPS
M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
10
•Ensure data and information integrity and accuracy
•Produce timely documents and reports
•Increase labor efficiency
•Help provide increased and enhanced service
•Help build and maintain customer loyalty
•Achieve competitive advantage

11. Processing Cycle
Data Entry
•Collecting and capturing transactions
•No longer manual:
•Old technologies Bar Codes, Magnetic Strips (credit cards)
•New technologies RFID, Smart Cards,
M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
11

12. Corporate
databases
of
internal
data
Databases
of
external
data
Databases
of
valid
transactions
Operational
Databases

(CRM)
Transaction
processing
systems
MIS
Decision
support
systems
Executive
support
systems
Expert
systems
Business
transactions
Input and
error list
Drill-down reports
Exception reports
Demand reports
Key-indicator reports
Scheduled
reports
Employees
Corporate
intranet
Application
databases
U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n

O
k
a
r
a

C
a
m
p
u
s
12
App databases
Ebay.com, photo.net uses Oracle
Facebook.com built over MySQL
Schematic View (Cont.)

13. Processing Cycle
Database Maintenance
•TPS helps ensure the databases are up-to-date and correct.
•Multiple databases (internal & external)
•A single purchase
•decreases quantity – Inventory Database
•decrease credit – Credit Card Database
•increase sales – Sales Database
M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
13

14. Processing Cycle
Document/Report Generation
•Examples
•purchase orders
•pay checks
•sales receipts
•invoices
•bank statements
An MIS also generates reports, but TPS reports are
operational (no analysis).
M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
14

15. Processing Cycle
Inquiry Processing
•Examples
•when was a purchase made
•does a customer have any credits on their account
•was an item scheduled for delivery
•was a package signed for
An MIS also allows for inquiries, but the information
available is summarized (or aggregated), i.e., What are
the total sales for a whole department? What is the best
selling product?
M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
15

16. Processing Cycle
M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
16

17. Transaction Processing
System
•An Order Entry System affects
•accounting data
•inventory data
•customer data
•financial data
•invoicing data
•Enhanced Feedback:
•Inventory is updated at the point of ordering, not at the point of
fulfillment. Eliminates surprise backorders (out-of-stock
products).
M
I
S
,

U
n
i
v
e
r
s
i
t
y

o
f

E
d
u
c
a
t
i
o
n
,
O
k
a
r
a

C
a
m
p
u
s
17