An Overview of On-Line Analytical Processing
Database Evolution
OLAP
OLAP vs OLTP (1)
OLAP vs OLTP (2)
OLAP vs OLTP (3)
OLAP vs OLTP (4)
OLAP vs OLTP (5)
Multi-dim Data
OLAP System Architecture
SQL Group-By Operator
Problems with SQL Group-By
Data Cube Operator
Output Cube
Accessing the Data Cube
Computing the Data Cube
Aggregate Function Trichotomy
OLAP Server Implementation
Star Schema
MOLAP Approach
MOLAP Advantages
An Example
T2 Queries & Group-By (1)
T2 Queries & Group-By (2)
A Titan Query
A Virtual Microscope Query
UT-Austin Simulation
Relating T2 to OLAP
Email: chialin@cs.umd.edu
Home Page: Tools and Techniques for Very Large Scale Data Intensive Applications