/
Transaction Processing System Transaction Processing System

Transaction Processing System - PowerPoint Presentation

briana-ranney
briana-ranney . @briana-ranney
Follow
513 views
Uploaded On 2016-03-06

Transaction Processing System - PPT Presentation

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

processing transaction system data transaction processing data system systems time transactions users information tps storage real batch recovery file

Share:

Link:

Embed:

Download Presentation from below link

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.


Presentation Transcript

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