MIS 111 Lecture Notes - Lecture 24: Data Integration, Data Warehouse, Extract, Transform, Load

• School: University of Arizona
• Department: Management Info Systems Main
• Course: MIS 111
• Professor: ALL

Document Summary

Source systems: web-site data, erp systems, variety of source systems and source data. Relational databases v. data warehouses relational example. If you put these together. you can create a data cube. Data integration: etl proces extract, transform, load. Example of transformation (organize data around customer id to get a 360 view of a customer) Source, integrate, format for storing it in the organization. Storing the data: 1. central enterprise data warehouse 2. independent data marts (application- centric approach) 3. Hub and spoke ( central data warehouse for all decisions makers with multiple depends data marts) It needs info about: data sources, database, table, and column name. Users need info about: data definitions, report/query tools.