Mondrian OLAP server
Encyclopedia
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:
Open source
The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...
OLAP
OLAP
In computing, online analytical processing, or OLAP , is an approach to swiftly answer multi-dimensional analytical queries. OLAP is part of the broader category of business intelligence, which also encompasses relational reporting and data mining...
(online analytical processing) server
Server (computing)
In the context of client-server architecture, a server is a computer program running to serve the requests of other programs, the "clients". Thus, the "server" performs some computational task on behalf of "clients"...
,
written in Java
Java (programming language)
Java is a programming language originally developed by James Gosling at Sun Microsystems and released in 1995 as a core component of Sun Microsystems' Java platform. The language derives much of its syntax from C and C++ but has a simpler object model and fewer low-level facilities...
.
It supports the MDX
Multidimensional Expressions
Multidimensional Expressions is a query language for OLAP databases, much like SQL is a query language for relational databases. It is also a calculation language, with syntax similar to spreadsheet formulas.-Background:...
(multidimensional expressions) query language
and the XML for Analysis
XML for Analysis
XML for Analysis is an industry standard for data access in analytical systems, such as OLAP and data mining. XMLA is based on other industry standards such as XML, SOAP and HTTP...
and olap4j interface specifications.
It reads from SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
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 MDXMultidimensional ExpressionsMultidimensional Expressions is a query language for OLAP databases, much like SQL is a query language for relational databases. It is also a calculation language, with syntax similar to spreadsheet formulas.-Background:...
language into Structured Query Language (SQLSQLSQL is a programming language designed for managing data in relational database management systems ....
) 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
Mondrian frontends
See also
- Business intelligenceBusiness intelligenceBusiness intelligence mainly refers to computer-based techniques used in identifying, extracting, and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes....
- Comparison of OLAP ServersComparison of OLAP ServersThe following tables compare general and technical information for a number of Online analytical processing servers. Please see the individual products articles for further information.-General information:-Data storage modes:-APIs and query languages:...