CIS 2010 Chapter Notes - Chapter 3: Data Mart, Data Warehouse, Decision Management
Document Summary
Module 09a: a central location in which data is stored and managed. Data warehouse: a logical collection of information gathered from many different operational databases that supports business analysis activities and decision-making tasks. Data aggregation: the collection of data from various sources for the purpose of data processing, example: gather information about particular groups based on specific variables such as age, profession, or income. The model compiles information from internal databases or transactional/operational databases and external databases through extraction, transformation, and loading (etl) Extraction, transformation, and loading (etl: a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse. The data warehouse then sends subsets of the information to data marts. A data mart contains a subset of data warehouse information. Dirty data: erroneous or flawed data, the complete removal of dirty data from a source is impractical or virtually impossible.