Chapter 9 - Data Warehouse Implementation and Use

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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


Kaugnay na mga set ng pag-aaral

Nur17o Exam 3 PrepU I/O Nutrition Oxygen

View Set

Human Resources CH 13 Motivation at Work

View Set

Brunner Ch. 63 Assessment & Management of Patients with Eye & Vision Disorders

View Set

course point ch. 23 patients with chest/LRT infections

View Set

Renal: SonoSim for Bladder Scanning and Bladder: Anatomy & Physiology

View Set

Chapter 3: Business and the Constitution

View Set