Computer Science 1032A/B Lecture 23: Decision Making and Business Intelligence (i)

• School: Western University
• Department: Computer Science
• Course: Computer Science 1032A/B
• Professor: Louis Magguilli

Document Summary

Decision making is a daily occurrence for business managers. 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, incorporate this data into decision making. Data quality (processed) data from operational systems can be used for: basic reports, example: current sales, sales projections. Raw data unsuitable for sophisticated reporting or data mining. Online transaction processing (oltp) system: 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. Batch processing: system waits until it has a batch of transactions before the data are processed and the information is updated. Example: transfer of all daily branch transactions to the central office for processing.