Table of Contents
PPT Slide
Multidimensional data model and OLAP
What this is not about
What is a data model?
The relational algebra
Metadata and data
The multidimensional data model
Cells and data
The measures dimension
Cubes
PPT Slide
Immediate differences between the relational and multidimensional data models
Can we apply the relational algebra to the multidimensional model?
What operations are we interested in?
Operators on a cube
Notation
Projection
Subgrids
Subgrid example
Checking for the product structure
Checking for the product structure, continued
Reordering transformations
Shaping
Shaping, continued
Shaping, continued
Grid sections
Deflation
Slicing example
Deflation, continued
Deflation, continued
Deflation, continued
Inflation
Restrictions
Restrictions, continued
General restriction example
Selections = data driven restrictions
Selections, continued
Other operators
Hierarchies
Hierarchies, continued
Hierarchies, continued
Hierarchies, continued
Summaries
Summaries, continued
Aggregations scenario
Dimensional explosion
Data sparsity
How Essbase treats sparsity issues
Access patterns
Access patterns, continued
General functional dependencies
General functional dependencies, continued
Additional modeling aspects
Additional modeling aspects, continued
Additional modeling aspects, continued
Time dimension modeling
Time dimension modeling, continued
The OLAP equation
|
Author: Zeep
|