MIS 111 Lecture Notes - Lecture 23: Strategic Business Unit, Teijin, Data Mart

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

Document Summary

Data mart: low cost, scaled-down version of a data warehouse designed for user needs in a strategic business unit or department (used in departments or very small organizations) Data warehouse is there for you, rationale to provide you with access to corporate data so you can analyze it to improve your decision making. Data warehouses are read-only (can read, but cant change anything in the database) Data warehouses accesses group of related records. Characteristics of data warehouses and data marts. 1. organized by business dimension or subject ( customer, vendor, student, etc. ) User decides on business dimensions or subjects. 2. use online analytical processing (olap) the analysts of accumulated data by end users. 3. integrated: data collected from multiple systems and then integrated around subjects. 4. time variant maintain historical data, which are data that include time as a variable (used to detect deviations, trend analysis, and long term relationships) 5. nonvolatile users cannot change, update, or delete data.