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