Summary
Data warehouse
- A subject-oriented, integrated, time-variant, and nonvolatile collection of data in support of management’s decision-making process
A multi-dimensional model of a data warehouse
- Star schema, snowflake schema, fact constellations
- A data cube consists of dimensions & measures
OLAP operations: drilling, rolling, slicing, dicing and pivoting
OLAP servers: ROLAP, MOLAP, HOLAP
Efficient computation of data cubes
- Partial vs. full vs. no materialization
- Multiway array aggregation
- Bitmap index and join index implementations
Extensions of data cubes
- Discovery-drive and multi-feature cubes
- From OLAP to OLAM (on-line analytical mining)