8/19/2019 Transatrction Processing System

1/8

Transaction Processing SystemsTransaction Processing Systems

What is a TPS?What is a TPS?

Characteristics of TPSCharacteristics of TPS a Transaction Processing Modela Transaction Processing Model

POS(Point Of Sale) Transaction Processing SystemPOS(Point Of Sale) Transaction Processing System

Batch Processing vs. On-line ProcessingBatch Processing vs. On-line Processing

TPS !!licationsTPS !!lications

8/19/2019 Transatrction Processing System

2/8

What is a TPS?What is a TPS?

an information system designed to !rocess ro"tinean information system designed to !rocess ro"tine

 #"siness transactions #"siness transactions

see$s time- and cost-efficiency #y a"tomatingsee$s time- and cost-efficiency #y a"tomatingre!etitive o!erations in large vol"mesre!etitive o!erations in large vol"mes

interfaces %ith an organi&ation's other informationinterfaces %ith an organi&ation's other information

systems s"ch as *S +SS ,Ssystems s"ch as *S +SS ,S

centers aro"nd acco"nting and finance transactionscenters aro"nd acco"nting and finance transactions

e.g airline reservation systems ordere.g airline reservation systems order

entry!rocessing systems #an$'s acco"ntentry!rocessing systems #an$'s acco"nt

 !rocessing systems !rocessing systems

8/19/2019 Transatrction Processing System

3/8

The Major Characteristics of TPSThe Major Characteristics of TPS

 Large amounts of data Large amounts of data are !rocessed.are !rocessed.

The so"rces of data are mostlyThe so"rces of data are mostly  internal internal  and the o"t!"t is intended mainly for an and the o"t!"t is intended mainly for an

internal a"dience.internal a"dience.

The TPS !rocesses informationThe TPS !rocesses information on a regular basison a regular basis daily %ee$ly monthly etc. daily %ee$ly monthly etc.

 Large storage Large storage (data#ase) ca!acity is re/"ired.(data#ase) ca!acity is re/"ired.

 High processing speed  High processing speed  is needed d"e to the high vol"me.is needed d"e to the high vol"me.

TPS #asically monitors and collectsTPS #asically monitors and collects  past data past data..

n!"t and o"t!"t data aren!"t and o"t!"t data are structured  structured  (i.e. standardi&ed).(i.e. standardi&ed).  Low computation complexity Low computation complexity is "s"ally evident in TPS.is "s"ally evident in TPS.

high level of high level of accuracy, data integrity, and securityaccuracy, data integrity, and security is needed.is needed.

0igh0igh reliabilityreliability is re/"ired.is re/"ired.

 Inquiry processing Inquiry processing is a m"st.is a m"st.

8/19/2019 Transatrction Processing System

4/8

Data Input

Data Input Data Processing

Data Processing Output Generation

Output Generation

Data Storage

Data Storage

A Transaction Processing ModelA Transaction Processing Model

8/19/2019 Transatrction Processing System

5/8

Barcode Scanner   POS

TPS

UPC

Product

DB

Inventory

DB  Information

Reporting System

Customer

Receipt

Exception

ReportsUPC   Price

UPC

!uantity

Product" !uantity"

Date" Time"

Price

POS(Point Of Sale) TPS

Purc#asing

DB

!uantity"

Date"

Time

8/19/2019 Transatrction Processing System

6/8

Transaction

Data  Data

Processing

Trans$

%i&e

'e(

)aster %i&eO&d

)aster 

%i&e

Documents*

Reports

Batch Processing

8/19/2019 Transatrction Processing System

7/8

On-line Processing

On+&ine

Data

Processing

Documents*

Reports

Transaction

Data

In,uiries*

Reponses

Transaction

Data

Transaction

Data

8/19/2019 Transatrction Processing System

8/8

TPS !!licationsTPS !!lications

Order ProcessingOrder Processing

P"rchasingP"rchasing

cco"nts *eceiva#les 1 cco"nts Paya#lescco"nts *eceiva#les 1 cco"nts Paya#les

*eceiving 1 Shi!!ing*eceiving 1 Shi!!ing

nventory on 0andnventory on 0and PayrollPayroll

2eneral 3edgers2eneral 3edgers