src: i.ytimg.com
Mondrian is an open source OLAP (online analytical processing) server, written in Java. It supports the MDX (multidimensional expressions) query language and the XML for Analysis and olap4j interface specifications. It reads from SQL and other data sources and aggregates data in a memory cache.
Mondrian is used for:
- High performance, interactive analysis of large or small volumes of information
- Dimensional exploration of data, for example analyzing sales by product line, by region, by time period
- Parsing the MDX language into Structured Query Language (SQL) to retrieve answers to dimensional queries
- High-speed queries through the use of aggregate tables in the RDBMS
- Advanced calculations using the calculation expressions of the MDX language
Video Mondrian OLAP server
Mondrian History
The first public release of Mondrian was on August 9, 2002.
A release history is [1]here[2].
Maps Mondrian OLAP server
Mondrian frontends
- JPivot
- Saiku
- Pentaho Analyzer
- Pivot4J
- EazyBI
src: 3.bp.blogspot.com
See also
- Business intelligence
- Comparison of OLAP Servers
Source of the article : Wikipedia