Mondrian

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
(Links)
 
(未显示1个用户的14个中间版本)
第1行: 第1行:
 +
{{SeeWikipedia|Mondrian OLAP server}}
 +
 
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.
 
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.
  
第10行: 第12行:
 
  Start up Tomcat
 
  Start up Tomcat
 
  Hit http://localhost:8080/mondrian-embedded
 
  Hit http://localhost:8080/mondrian-embedded
 +
==olap4j==
 +
Mondrian 3.0 includes [[olap4j]] 0.9.6 along with significant improvements to security and additional function support.
 
==PostgreSQL==
 
==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> java -cp "C:\mondrian\lib\mondrian.jar;C:\mondrian\lib\log4j-1.2.9.jar; C:\mondrian\lib\eigenbase-xom.jar;   
第34行: 第38行:
 
==Apache Derby==
 
==Apache Derby==
  
 
+
==Pentaho==
 
+
[[Mondrian Schema Workbench]] (Pentaho Analysis schema design)
 +
==Code==
 +
Pentaho packages detail: http://docs.huihoo.com/javadoc/mondrian/3.0.4/
 
==Links==
 
==Links==
 
*http://mondrian.pentaho.org/
 
*http://mondrian.pentaho.org/
 
*http://sourceforge.net/projects/mondrian
 
*http://sourceforge.net/projects/mondrian
 
*http://docs.huihoo.com/mondrian
 
*http://docs.huihoo.com/mondrian
 +
*http://docs.huihoo.com/javadoc/mondrian
 
*http://download.huihoo.com/mondrian
 
*http://download.huihoo.com/mondrian
 +
 +
{{Comment}}
 +
 +
[[category:business intelligence]]
 +
[[category:OLAP]]
 +
[[category:MDX]]
 +
[[category:pentaho]]

2013年3月2日 (六) 16:28的最后版本

Wikipedia-35x35.png 您可以在Wikipedia上了解到此条目的英文信息 Mondrian Thanks, Wikipedia.

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

[编辑] olap4j

Mondrian 3.0 includes olap4j 0.9.6 along with significant improvements to security and additional function support.

[编辑] 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

[编辑] Pentaho

Mondrian Schema Workbench (Pentaho Analysis schema design)

[编辑] Code

Pentaho packages detail: http://docs.huihoo.com/javadoc/mondrian/3.0.4/

[编辑] Links

Comment-32x32.png

<discussion>characters_max=300</discussion>

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

变换
操作
导航
工具箱