Mondrian OLAP server
From Wikipedia, the free encyclopedia
 |
|
|---|---|
| Developer(s) | Pentaho Corporation |
| Stable release | 3.0.3.11371 / August 2, 2008 |
| Operating system | Cross-platform (JVM) |
| Type | OLAP Server |
| License | EPL |
| Website | mondrian.pentaho.org |
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 Java OLAP 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 of Multi-Dimensional eXpression (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
