Modern Database Management Chapter 9 - Data Warehousing
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 and 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 from fact or event data. A dimensional model is another name for this.
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 systems of record.
Real-time data warehouse
An enterprise data warehouse that accepts near-real-time feeds of transnational data from the systems of record, analyzes warehouse data, and in near-real-time relays business rules to the data warehouse and systems of records 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.
Big Data
An ill-defined term applied to databases whose size strains the ability of commonly used relational DBMSs to capture, manage, and process that data within a tolerable elapsed time.
Operational data store (ODS)
An integrated, subject-oriented, continuously updatable, current-valued (with recent history), enterprise-wide, detailed database designed to serve operational users as they do decision support processing.
Transient Data
Data in which changes to existing records are written over previous records, thus destroying the previous data content.
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.
Reconciled Data
Detailed, current data intended to be the single, authoritative source for all decision support applications.
Data mining
Knowledge discovery, using a sophisticated blend of techniques from traditional statistics, artificial intelligence, and computer graphics.
Mulidimensional OLAP (MOLAP)
OLAP tools that load data into an intermediate structure, usually a three- or higher-dimensional array.
Relational OLAP (ROLAP)
OLAP tools that view the database as a traditional relational database in either a star schema or other normalized or denormalized set of tables.
Conformed dimension
One or more dimension tables associated with two or more fact tables for which the dimension tables have the same business meaning and primary key with each fact table.
NoSQL
Short for "Not only SQL," this is a class of database technology used to store and access textual and other unstructured data, using more flexible structures than the rows and columns format of relational databases.
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.
Data visualization
The representation of data in graphical and multimedia formats for human analysis.
Online analytical processing (OLAP)
The use of a set of graphical tools that provides users with multidimensional views of their data and allows them to analyze the data using simple windowing techniques.