31-01-2012, 11:07 AM
online analytical processing presentation
olap.ppt (Size: 424.5 KB / Downloads: 79)
Motivation
Aggregation, summarization and exploration
Of historical data
To help management make informed decisions
Query Language Extensions
In the real world, data is stored in RDBs.
How to express N-dimensional problems using 2D tables?
Query Language Extensions
In the real world, data is stored in RDBs.
How to express N-dimensional problems using 2D tables?
Can we combine OLAP and SQL queries?
Jim Gray et al:Data Cube: A Relational Aggregation Operator1997
olap.ppt (Size: 424.5 KB / Downloads: 79)
Motivation
Aggregation, summarization and exploration
Of historical data
To help management make informed decisions
Query Language Extensions
In the real world, data is stored in RDBs.
How to express N-dimensional problems using 2D tables?
Query Language Extensions
In the real world, data is stored in RDBs.
How to express N-dimensional problems using 2D tables?
Can we combine OLAP and SQL queries?
Jim Gray et al:Data Cube: A Relational Aggregation Operator1997