Transaction Processing Systems UNIT II Transaction Processing Cycle

Transaction Processing Systems UNIT II

Transaction Processing Cycle l l l Data Entry Activities Transaction Processing Activities File and Database Processing Document and Report Generation Inquiry Processing

Transaction Processing System Data Entry Transaction Processing Document and Report Generation File and Database Processing Inquiry Processing

Data Entry Activities l l Data is captured and collected by recording, coding and editing activities Traditional Data Entry – – – People Involved Get data, Edit it and batch it, key it into computer then sort and store. Disadvantages : Too costly, Increases potential errors, Too many activities, many people and media involved.

Data Entry Activities l Source Data Automation – – – l From source that generates data By using machine readable media Optical Scanning, MICR, Light Pens, Voice Input, Touch Screen Electronic Data Interchange (EDI) – – – Complete Automation From start till information is got. For eg. Orders put up in internet and customers fill in data that is fed into the Sales TPS and then processed

Transaction Processing Activities l Batch Processing – Process l l – – Gather Source Data Record data and input Sort Update Master file Advantages : Efficiency, Economy, Control Disadvantages : Frequently out-of-date Master file

Transaction Processing Activities l Real Time Processing – l Processing as soon as transaction gets over Levels of Systems – – – Inquiry / Response Systems (Information Retrieval) Data Entry Systems (Po. S) File Processing Systems (Collect, Convert, Manipulate and Store (no output)) Full Capability Systems (Eg. Indian Railways Ticketing) Process Control Systems (Full Capability + Control (uses info output to control))

Transaction Processing Activities l l Real Time Processing Advantages – l Immediate Updation Disadvantages – – Security Cost

File and Database Processing l Maintenance Activities : Correct and Update Information Inquiry Processing l l Interrogation of Online files and database by end users Eg. Getting Account Information

Document and Report Generation l Action Documents – l Information Documents – l Initiate actions / transactions Relate, Confirm or Prove that transactions occurred Turnaround Documents – Returned back to the sender

Attributes of Information Quality l Time Dimension – – Timeliness (provided when needed) Currency (up-to-date when provided) Frequency (as often as needed) Time Period (info about past, present and future time periods)

Attributes of Information Quality l Content Dimension – – Accuracy (free from errors) Relevance (related to needs) Completeness (all info is provided) Conciseness (info needed alone is provided)

Attributes of Information Quality l Form Dimension – – – Clarity (easy to understand form) Detail (in detail or summary form) Order (in predetermined sequence) Presentation (numeric, graphic, narrative) Media (as required [printed paper, video displays, disks, etc. ])

Information Reporting System l l Produce information products (reports and documents) that support day-to-day decision making Information Reporting Alternatives : – – – Periodic Scheduled Reports Exception Reports (specific conditions) Demand Reports and Responses

Executive Information Systems l l Information Reporting Systems + Decision Support Systems For Strategic Planning and Control Much of top management information comes from non-computer sources Now computer-based EIS developed – easy to operate and understand

Executive Information Systems l l l Tailored to the preferences of the executives Use of Graphics Get detailed information in areas of interest to them