Business Administration 3300K Study Guide - Quiz Guide: Data Warehouse, Data Mart, Management System
Document Summary
S6-mis: recent developments in data warehousing - watson. Data warehouse: collection of data created to support decision making; provides data infrastructure. & thus eliminates failures that are due to lack of quality single version of truth". Data warehousing: process that encompasses range of activities in data warehouse. Data mart: similar to data warehouse but stores data only for limited number of subject areas (smaller in scope than data warehouses) Independent data mart: built directly from source systems; often point solution" that solves immediate problem but creates new ones in long run when firm tries to implement enterprise-wide data infrastructure (eg data warehouse) Operational data store (ods): consolidates data from multiple source systems & provides near real- time, integrated view of volatile, current (max 60 day old) data; aim to provide integrated data for organisational purposes; often used to avoid erp implementation.