ITM 750 Study Guide - Midterm Guide: Decision Support System, Data Warehouse, Online Analytical Processing

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 750
• Professor: Tim Mc Laren

Document Summary

Data warehouse system a subject-oriented platform; organized to support customers, managers, suppliers, products, sales; can be modified. Integrated includes core components such as data marts integrated into olap platform. Non-volatile once data is located in data warehouse it will not change. Extract, transform & load (etl) is the most common form of data integration found in data warehouse -> dss (decision support system) Olap online analytic processing for real time analytics; historical & current data used to predict future stock market. Machine learning learns about data, predicts future -> data is divided in 2 parts (1) training [30% of data used] (2) testing [70% of data is used] Online transaction processing (oltp) is linked to customers" activities oltp + olap -> linked to machine learning (r, Model a representation of things, a description of reality; myfunction