Mondrian

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
第10行: 第10行:
 
  Start up Tomcat
 
  Start up Tomcat
 
  Hit http://localhost:8080/mondrian-embedded
 
  Hit http://localhost:8080/mondrian-embedded
==Apache Derby==
+
==PostgreSQL==
==MySQL==
+
$ mysqladmin create foodmart
+
mysql> grant all privileges on *.* to 'foodmart'@'localhost' identified by 'foodmart';
+
      $ 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"
+
or windows
+
 
  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> 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"
 
  C:\mondrian\lib\eigenbase-resgen.jar; C:\mondrian\lib\eigenbase-properties.jar; C:\mondrian\lib\postgres-jdbc.jar"
第31行: 第20行:
 
     -outputJdbcUser=postgres
 
     -outputJdbcUser=postgres
 
     -outputJdbcPassword=password
 
     -outputJdbcPassword=password
 +
==MySQL==
 +
$ mysqladmin create foodmart
 +
mysql> grant all privileges on *.* to 'foodmart'@'localhost' identified by 'foodmart';
 +
$ 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"
 +
==Apache Derby==
 +
 +
  
 
==Links==
 
==Links==

2007年11月19日 (一) 17:07的版本

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 *.* to 'foodmart'@'localhost' identified by 'foodmart';
$ 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" 

Apache Derby

Links

分享您的观点
个人工具
名字空间

变换
操作
导航
工具箱