Computer Science 1032A/B Lecture Notes - Data Warehouse, Database, Intellectual Capital

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

Document Summary

Decision making daily occurrence for business managers, factors making business decisions challenging: uncertainty and complexity, information overload, data quality. Storage capacity increases, cost decreases, basically unlimited today, exponential growth both inside and outside organizations, used to improve decision making. Ability to store any size customer data, allows for better understanding of customers. Data can be used for forecasting competitive strength (when making decisions) 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 (e. g. sales projections) Raw data usually unsuitable for sophisticated reporting or data mining (missing values, inconsistent, data not integrated, wrong granularity, too much data) Collects data electronically and processes transactions online. Backbone of all functional, cross-functional, and interorganizational systems in an organization. Oltp support decision making: provides raw info about transactions, info of status of organization. Real-time processing: transactions entered and processed immediately upon entry (airline reservation)