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
|