4 comments:

Hi,What I think is very common.Mondrian is a great open source ROLAP engine. Use it with aggregated tables, better if partitionned (including indexes). Mondrian relies on the database, so you have to optimize your data structures and management for good performances (think of materialized views for instance).

Just to picture my thoughts, please have a look on this quote, from Julian Hyde (Mondrian's dad) : "I'm surprised that people can run 10m+ row fact tables on Mondrian at all, without using aggregate tables or materialized views."

More in depth information about optimization here : http://mondrian.pentaho.org/documentation/performance.php

And of course my email, you are welcome : vteyssier at decisionsystems-studio dot fr

Who am I ?

Datawarehousing & BI / Cloud Computing and Data processing.
I work for several clients from banking/insurance to call centers, entertainment and tourism.
Regularly CTO or CDO for startups or marketing companies dealing with data. Technical consulting for startups around Big Data, Analytics and Cloud Computing. Currently working for public / gov organization.