On-Line Analytical Processing (OLAP)

10/10/99


Click here to start


Table of Contents

On-Line Analytical Processing (OLAP)

Traditional OLTP

OLTP vs. OLAP

On-Line Analytic Processing (OLAP)

Data Cube Implementation of Characterization

A Sample Data Cube

Sample Operations

Data Cube

Cuboid Lattice

Cube Computation -- Array Based Algorithm

ROLAP versus MOLAP

ROLAP versus MOLAP

Roll-up, Drill-down, Slicing, Dicing

Automatic Generation of Numeric Hierarchies

PPT Slide

Visualization of a Data Cube

Methodologies of Multiple Level Data Mining

Incomplete Data Cubes

Cubette

Partial query results

Exploration of OLAP Data Cubes (Sarawagi et al.)

InExp Example

Drill down Product

Drill down Region for a product

Determining Exceptions

Anticipated and surprising values

Summarizing exceptions

Algorithm

Example

OLAP Mining (OLAM): An Integration of Data Mining and Data Warehousing

Why On-Line Analytical Mining?

OLAM

OLAM

Author: Dora Cai