Apache Druid vs Mondrian
Apache Druid: Real-time analytics database for sub-second slice-and-dice over streaming event data. Mondrian: Java ROLAP engine that answers MDX queries by generating SQL against your relational warehouse.
key differences
- Apache Druid is primarily a columnar / OLAP database; Mondrian is relational.
- Licensing: Apache Druid is open source (permissive) (Apache License 2.0); Mondrian is source-available (Business Source License 1.1 (since 10.3; older releases EPL)).
- Apache Druid is built for larger datasets (Multi-PB) than Mondrian (≤ 10 TB).
- Horizontal scaling is native in Apache Druid and none in Mondrian.
- Transactions: Apache Druid offers limited ACID; Mondrian offers none.
- Only Apache Druid has secondary indexes, geospatial, json, ttl / expiry, columnar storage.
- Mondrian can run embedded in your application process.
choose apache-druid for
- +User-facing analytics dashboards
- +Clickstream and ad-tech analytics
- +Network and application telemetry
- +Real-time operational monitoring
best at · Real-time analytics, OLAP, Time-series
choose mondrian for
- +Pivot-style analytics over a star schema in PostgreSQL, MySQL or a warehouse
- +Embedding OLAP cubes in Java BI applications
- +Pentaho Business Analytics deployments
best at · OLAP, Warehouse
Apache Druid vs Mondrian: FAQ
What is the difference between Apache Druid and Mondrian?
Apache Druid: Real-time analytics database for sub-second slice-and-dice over streaming event data. Mondrian: Java ROLAP engine that answers MDX queries by generating SQL against your relational warehouse. Apache Druid is primarily a columnar / OLAP database; Mondrian is relational. Licensing: Apache Druid is open source (permissive) (Apache License 2.0); Mondrian is source-available (Business Source License 1.1 (since 10.3; older releases EPL)). Apache Druid is built for larger datasets (Multi-PB) than Mondrian (≤ 10 TB).
When should I choose Apache Druid over Mondrian?
Choose Apache Druid for user-facing analytics dashboards; clickstream and ad-tech analytics; and network and application telemetry. Choose Mondrian for pivot-style analytics over a star schema in PostgreSQL, MySQL or a warehouse; embedding OLAP cubes in Java BI applications; and pentaho Business Analytics deployments.
Is Apache Druid or Mondrian more popular?
Apache Druid ranks #58 on the WhichDB Score (35.0/100) and Mondrian ranks #267 (12.4/100). Popularity is not fit: check the requirements that matter for your project.
Are Apache Druid and Mondrian open source?
Yes. Apache Druid is open source. License: Apache License 2.0. Not in the OSI sense. Mondrian is source-available: you can read the code, but the license restricts some uses, typically offering it as a competing managed service. License: Business Source License 1.1 (since 10.3; older releases EPL).