Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Other Big Data and the fly likes Mondrian in Action : supported databases? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » Other Big Data
Bookmark "Mondrian in Action : supported databases?" Watch "Mondrian in Action : supported databases?" New topic
Author

Mondrian in Action : supported databases?

Patroklos Papapetrou
Author
Ranch Hand

Joined: Aug 06, 2013
Posts: 32
    
    5

Hi

With which databases is Mondrian compatible? Can it be used with NoSql databases as well? And if yes, which ones?

Thanks

Follow me on twitter ( @ppapapetrou76 ) or see my linked profile and connect with me
You can slso subscribe to my technical blog
Bill Back
Author
Greenhorn

Joined: Aug 09, 2013
Posts: 7
The full list is available at http://infocenter.pentaho.com/help/index.jsp?topic=%2Fsupported_components%2Freference_supported_components.html. There are some techniques using Pentaho Data Integration for going directly against NoSQL data sources, such as Cassandra and MongoDB. But keep in mind the performance is usually lower than using a database, particularly an analytics (columnar) database.

I know there is also a lot of work going on with Optiq, Julian's other project, to provide such access. Perhaps he can provide more info.
Nicholas Goodman
Greenhorn

Joined: Oct 03, 2013
Posts: 4
We do discuss the integration with NoSQL systems in Chapter 11, briefly. And, like Bill mentions Optiq and other intermediary layers is necessary since Mondrian needs to speak to "something" that speaks SQL. Most NoSQL systems these days are sql-esque (functionally if not semantically similar) but don't speak directly which is where optiq fits in.

The techniques Bill mentions with PDI will work functionally, but will not (*currently to my knowledge) leverage any optimizations in the source data (filtering before aggregation in MongoDB) based on the Mondrian query. Until something like Optiq is working well on many systems, with it's inherent ability for optimization rules, the performance directly on NoSQL systems from Mondrian will be a bit disappointing.

Good luck - and if you get the book, jump straight to Chapter 11 so that the context of where Mondrian fits in the NoSQL/Big Data world.

Julian Hyde
Author
Greenhorn

Joined: Aug 09, 2013
Posts: 1
As Nick said, my Optiq project is allowing us to put Mondrian on top of databases that don't speak SQL.

Optiq has adapters for Splunk, MongoDB, and CSV files.

An adapter for Spark is under development. That is particularly exciting, because we will be able to use Spark as a distributed in-memory database that works on cached copies (or subsets, or aggregates materialized in memory) of other databases. This will be useful for operational databases that do not have great performance for scanning/aggregating large numbers of records.

Optiq also has a JDBC adapter, which allows it to push queries down to an underlying database. Why is that useful? Optiq can be used to combine multiple databases (maybe all relational, or maybe a mixture of relational and non-relational), or add a distributed cache on top of a database.

Lastly, I hear reports from the lab that Mondrian works on top of HBase using the Phoenix JDBC driver. I'll be trying Mondrian on Optiq on HBase shortly.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Mondrian in Action : supported databases?
 
Similar Threads
Pentaho Reporting 3.5 : Integration with Olap engines
What is the difference between Distinct and Unique?
Java OLAP Server/API
How to setup Mondrian OLAP in Glassfish??
How is JPivot, Mondrian and Pentahouse related?