Mondrian 简介

Mondrian 是一个 ROLAP 系统，支持 SQL Server、Oracle等关系数据库

--------------------------- From Wiki ------------------------------

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 of 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

--------------------------- From Pentaho Homesite ------------------------------

Pentaho Analysis Services (Mondrian)

Welcome to the community home for  Pentaho Analysis Services Community Edition also known as  Mondrian. Mondrian is an Online Analytical Processing (OLAP) server that enables business users to analyze large quantities of data in real-time. Users explore business data by drilling into and cross-tabulating information with speed-of-thought response times to complex analytical queries.

Community Edition is self supported open source software. An Enterprise Edition (EE) of Pentaho Analysis Services including technical support and managed upgrades is also available. For more information about EE or for case studies and datasheets, visit Pentaho Analysis Services EE on Pentaho's corporate site.

Mondrian's aggregation strategy is as follows:

• Fact data is stored in the RDBMS. Why develop a storage manager when the RDBMS already has one?
• Read aggregate data into the cache by submitting group by queries. Again, why develop an aggregator when the RDBMS has one?
• If the RDBMS supports materialized views, and the database administrator chooses to create materialized views for particular aggregations, then Mondrian will use them implicitly. Ideally, Mondrian's aggregation manager should be aware that these materialized views exist and that those particular aggregations are cheap to compute. It should even offer tuning suggestings to the database administrator.