Mondrian

Mondrian is an Online Analytical Processing (OLAP) server written in Java. It enables you to interactively analyze very large datasets stored in SQL databases without writing SQL.

It executes queries written in the MDX language, reading data from a relational database (RDBMS), and presents the results in a multidimensional format via a Java API.

Mondrian Architecture

Install

wget http://download.huihoo.com/mondrian/mondrian-2.4.2.9831-derby.zip
unzip mondrian-2.4.2.9831-derby.zip
explode lib/mondrian-embedded.war to TOMCAT_HOME/webapps/mondrian-embedded
Start up Tomcat
Hit http://localhost:8080/mondrian-embedded

PostgreSQL

C:\mondrian> java -cp "C:\mondrian\lib\mondrian.jar;C:\mondrian\lib\log4j-1.2.9.jar; C:\mondrian\lib\eigenbase-xom.jar;  
C:\mondrian\lib\eigenbase-resgen.jar; C:\mondrian\lib\eigenbase-properties.jar; C:\mondrian\lib\postgres-jdbc.jar"
    mondrian.test.loader.MondrianFoodMartLoader
    -verbose -tables -data -indexes
    -jdbcDrivers="org.postgresql.Driver,sun.jdbc.odbc.JdbcOdbcDriver"
    -inputJdbcURL="jdbc:odbc:MondrianFoodMart"
    -outputJdbcURL="jdbc:postgresql://localhost/foodmart"
    -outputJdbcUser=postgres
    -outputJdbcPassword=password

MySQL

$ mysqladmin create foodmart
mysql> grant all privileges on foodmart.* to foodmart@localhost identified by 'foodmart';
mysql> flush privilegs;
$ java -cp "/mondrian/lib/mondrian.jar:/mondrian/lib/log4j-1.2.9.jar:/mondrian/lib/eigenbase-xom.jar:/mondrian/lib/eigenbase-resgen.jar
:/mondrian/lib/eigenbase-properties.jar:/usr/local/mysql/mysql-connector-java-5.0.5-bin.jar"
        mondrian.test.loader.MondrianFoodMartLoader
        -verbose -tables -data -indexes
        -jdbcDrivers=com.mysql.jdbc.Driver
        -inputFile=/mondrian/demo/FoodMartCreateData.sql
        -outputJdbcURL="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart" 

Links

• http://mondrian.pentaho.org/
• http://sourceforge.net/projects/mondrian
• http://docs.huihoo.com/mondrian
• http://download.huihoo.com/mondrian