21-08-2012, 04:10 PM
Transaction Processing Systems
Transaction Processing Systems.ppt (Size: 306 KB / Downloads: 43)
IS that process data resulting from occurrences of business transactions
Transactions are events that occur as part of doing business e.g. sales, purchases, deposits, withdrawals
Transaction processing activities needed to capture and process data
Support business operations
E.g data generated whenever business sells something on credit. Data about customer, sales person, store, customer billing , credit checks, inventory changes etc.
Traditional Data Entry
Rely on end users
Data entry using keyboard terminals periodically in Batches
Data entry specialists enter data using keyboards.
Many people and activities needed
High Costs and more errors
Source Data Automation
Automated methods for data entry
Sales transaction processing system
Captures data as early as possible after a transaction
Captures transaction as close as possible to the source that generates the data
Captures data using machine-readable media
Capturing data that rarely changes on pre recordable media
Captures data directly without the use of data media by optical scanning of bar code packaging
Batch Processing
Transactions are accumulated over time and processed.
It involves
Gathering source documents originated by business transactions
Record Transactions on some input medium
Sort transaction file in order of master file
Process transactions and create updated master file
Capture and store batches of transaction data at remote sites and transmit them periodically to a central computer for processing
Real Time Processing
Transaction data is processed immediately after they are generated
Called Online transaction Processing Systems (OLTP)
Transaction data are processed as soon as they are originated or recorded, without waiting to accumulate batches of data.
Data is fed directly into computer terminals from online transactions
Immediate responses to user queries
Files and databases are upto date
Depends on Internet, extranets and other networks to provide link between transaction terminals, client PCs, Servers and other computers.
Fault Tolerant Processing
The processing system which can respond gracefully to an unexpected hardware or software failure.
Airline reservation, online banking, Internet Electronic Commerce application
May use a multiprocessor design of several coupled CPU’s or parallel processor
Provides built-in backup fail over capability
Have redundant memory units, disk drives, duplicate software copies, redundant OS.
Database Maintenance
TPS must maintain database and ensure they correct and up to date.
Must record day to day transactions & make suitable Updation in a database
e.g. credit sales will cause customer credit balances to increase & inventory to decrease.
These updated databases provide updated data for MIS, DSS and EIS.
Transaction Processing Systems.ppt (Size: 306 KB / Downloads: 43)
IS that process data resulting from occurrences of business transactions
Transactions are events that occur as part of doing business e.g. sales, purchases, deposits, withdrawals
Transaction processing activities needed to capture and process data
Support business operations
E.g data generated whenever business sells something on credit. Data about customer, sales person, store, customer billing , credit checks, inventory changes etc.
Traditional Data Entry
Rely on end users
Data entry using keyboard terminals periodically in Batches
Data entry specialists enter data using keyboards.
Many people and activities needed
High Costs and more errors
Source Data Automation
Automated methods for data entry
Sales transaction processing system
Captures data as early as possible after a transaction
Captures transaction as close as possible to the source that generates the data
Captures data using machine-readable media
Capturing data that rarely changes on pre recordable media
Captures data directly without the use of data media by optical scanning of bar code packaging
Batch Processing
Transactions are accumulated over time and processed.
It involves
Gathering source documents originated by business transactions
Record Transactions on some input medium
Sort transaction file in order of master file
Process transactions and create updated master file
Capture and store batches of transaction data at remote sites and transmit them periodically to a central computer for processing
Real Time Processing
Transaction data is processed immediately after they are generated
Called Online transaction Processing Systems (OLTP)
Transaction data are processed as soon as they are originated or recorded, without waiting to accumulate batches of data.
Data is fed directly into computer terminals from online transactions
Immediate responses to user queries
Files and databases are upto date
Depends on Internet, extranets and other networks to provide link between transaction terminals, client PCs, Servers and other computers.
Fault Tolerant Processing
The processing system which can respond gracefully to an unexpected hardware or software failure.
Airline reservation, online banking, Internet Electronic Commerce application
May use a multiprocessor design of several coupled CPU’s or parallel processor
Provides built-in backup fail over capability
Have redundant memory units, disk drives, duplicate software copies, redundant OS.
Database Maintenance
TPS must maintain database and ensure they correct and up to date.
Must record day to day transactions & make suitable Updation in a database
e.g. credit sales will cause customer credit balances to increase & inventory to decrease.
These updated databases provide updated data for MIS, DSS and EIS.