Computer Science 1032A/B Study Guide - Decision-Making, Online Transaction Processing, Batch Processing

• School: Western University
• Department: Computer Science
• Course: Computer Science 1032A/B
• Professor: Diane Goldstein

Document Summary

Decision making is a daily occurrence for business managers. Factors making business decisions challenging: uncertainty and complexity, data quality. Exponential growth: both inside and outside of organizations, used to improve decision making. Ability to store any size customer data. Allows for a better understanding of the customers. Business manager"s challenge: find appropriate data. Processed data from operational systems can be used for: basic reports, e. g. Raw data unsuitable for sophisticated reporting or data mining. Inconsistent data: dirty data, missing values, data not integrated, wrong granularity too fine/not fine enough, too much data too many attributes/too many data points. Online transaction processing (oltp) systems: collects data electronically, processes the transactions online. Backbone of all functional, cross-functional and interorganizational systems in an organization. Oltp systems support decision making: provides raw information about transactions, provides information about status for an organization. Real-time processing: transactions are entered and processed immediately upon entry.