Mondrian

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
第31行: 第31行:
 
         -inputFile=/mondrian/demo/FoodMartCreateData.sql
 
         -inputFile=/mondrian/demo/FoodMartCreateData.sql
 
         -outputJdbcURL="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart"  
 
         -outputJdbcURL="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart"  
 +
或下载: http://download.huihoo.com/mondrian/create-foodmart-mysql.zip
 
==Apache Derby==
 
==Apache Derby==
  

2007年11月20日 (二) 23:52的版本

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" 

或下载: http://download.huihoo.com/mondrian/create-foodmart-mysql.zip

Apache Derby

Links

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

变换
操作
导航
工具箱