ROLAP versus MOLAP
ROLAP
- Exploits services of relational engine
- Provides additional OLAP services
- design tools for DSS schema
- performance analysis tool to pick aggregates to materialize
- Some SQL queries are hard to formulate and can be time consuming to execute