Chapter 9 - Data Warehouse Implementation and Use
Hybrid Online Analytical Processing (HOLAP)
An OLAP architecture that combines MOLAP and ROLAP approaches
Multidimensional Online Analytical Processing (MOLAP)
An OLAP architecture that stores data in multidimensional cubes
Drill Up
An OLAP operation for making the granularity of the data in the query result coarser
Drill Down
An OLAP operation for making the granularity of the data in the query result finer
Slice and Dice
An OLAP operation that adds, replaces, or eliminates specified dimension attributes (or particular values of the dimension attributes) from the already displayed results
Pivot (rotate)
An OLAP operation that reorganizes the values displayed in the original query result by moving values of a dimension column from one axis to another
Alpha Release
Internal deployment of a system to the members of the development team for initial testing of its functionalities
Business Intelligence (BI) Tools
see online analytical processing (OLAP) tools
Data Cleansing (scrubbing)
the detection and correction of low-quality data
Multidimensional Database Model
A model for implementation of dimensionally modeled data in which the database is implemented as a collection of cubes
Executive Dashboard
A front-end application that contains an organized, easy-to-read display of critically important queries describing the performance of the organization
Active Data Warehouses
Data warehouses with loads that occur continuously in micro batches, ensuring that the data in the data warehouse is updated close to real time (enabling analysis of the latest data)
Refresh Cycle
The frequency with which the data warehouse is reloaded with new data
First Load
The initial data warehouse load populating the empty data warehouse
Beta Release
The system release (following the alpha releases), in which the system is deployed to a selected group of users to test the usability of the system
Online Analytical Processing (OLAP) Tools
Tools enabling end users to engage in an ad-hoc analytical querying of data warehouses
Online Transaction Processing (OLTP)
Updating (i.e. inserting, modifying, and deleting), querying, and presenting data from databases for operational purposes
Relational Online Analytical Processing (ROLAP)
An OLAP architecture that stores data in relational tables
OLAP/ BI Tools
see online analytical processing (OLAP) tools
Online Analytical Processing (OLAP)
Querying and presenting data from data warehouses and/ or data marts for analytical purposes
Refresh Load
Every subsequent load after the first load
Cubes
Multidimensional database repositories; can be used to store dimensionally modeled data
Production Release
The actual deployment of a functioning system