MIS 385 Chapter 9
Enterprise data warehouse (EDW)
A centralized, integrated data warehouse that is the control point and single source of all data made available to end users for decision support applications
Logical Data mart
A data mart created by a relational view of a data warehouse
Dependent data mart
A data mart filled exclusively from an enterprise data warehouse and its reconciled data
Independent data mart
A data mart filled with data extracted from the operational environment, without the benefit of a data warehouse
Data mart
A data warehouse that is limited in scope, whose data are obtained by selecting a summarizing data from a data warehouse or from separate extract, transform, and load processes from source data systems
Star Schema
A simple database design in which dimensional data are separated form fact or event data. A dimensional model is another name for a star schema
Data Warehouse
A subject-oriented, integrated, time variant, nonupdateable collection of data used in support of management decision-making processes
Informational System
A system designed to support decision making based on historical point-in-time and prediction data for complex queries or data-mining applications
Operational System
A system that is used to run a business in real time, based on current data. Also called a system of record
Real-time data warehouse
An enterprise data warehouse that accepts near-real-time feeds of transactional data from systems of record, analyzes warehouse data, and in near real time relays business rules to data warehouse and systems of record so that immediate action can be taken in response to business events
Snowflake Schema
An expanded version of a star schema in which dimension tables are normalized into several related tables
Operatonal data store
An integrated, subject-oriented, continuously updatable, current valued (with recent history), enterprise wide, detailed database designed to serve operational users as they do decisions support processing
Periodic Data
Data that are never physically altered or deleted once they have been added to the store
Derived Data
Data that have been selected, formatted, and aggregated for end-user decision support applications
Transient Data
Data which changed to existing records are written over previous records, thus destroying the proviso data content
Reconciled data
Detailed, current data intended to be single, authoritative source for all decision support applications
Conformed dimension
One or more dimensional tables associated with two or more fact tables for which the dimension table have the same business meaning and primary key with each fact table
Grain
The level of detail in a fact table, determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements