Anyone have any experience with OLAP, or more specifically, Mondrian running on LINUX and Tomcat, and interfacing it via XMLA? Working on a new project, and one of the requirements is a good analytics engine. I need a multi-dimensional database (schema / queries) which mySQL doesn't offer, plus the ability to quickly and efficiently call up any data sets I need. Few requirements:
1.) Must work on LINUX. No Microsoft allowed.
2.) Must be open-source, as forcing clients to shell out thousands to Oracle isn't going to work.
3.) Must be portable. Not "5 click WP install" portable, but portable enough so we can create our own installation package, and easily install it on client's dedicated servers.
I've found Mondrian, which seems like a good solution. Got it all installed, played around a decent amount, and seems like exactly what I need. Haven't done any serious testing with it yet though (ie. 50+ million rows), but no complaints thus far. I'm not thrilled with the fact XMLA uses SOAP, as I don't like SOAP due to personal preferences (it's bulky), but I can live with it.
My thought was setup the PHP front-end application, then install Mondrian and Tomcat, with Tomcat on a separate port (eg. 28311, or whatever). Then for the reporting features within the PHP application, it'll just send XMLA/SOAP requests over to Mondrian, get a response in SOAP, and display it.
Anyone ever done this before? Any advice? Pitfalls I should watch for? It is ok to still store the analytics data in the mySQL database? Or should I maybe syphon that off, and install http://infinidb.org/ or another DB engine on each client's server? Then just have the PHP/mySQL app for the front-end operations only, which also feeds into say InfiniDB for analytics storage & retrieval?
1.) Must work on LINUX. No Microsoft allowed.
2.) Must be open-source, as forcing clients to shell out thousands to Oracle isn't going to work.
3.) Must be portable. Not "5 click WP install" portable, but portable enough so we can create our own installation package, and easily install it on client's dedicated servers.
I've found Mondrian, which seems like a good solution. Got it all installed, played around a decent amount, and seems like exactly what I need. Haven't done any serious testing with it yet though (ie. 50+ million rows), but no complaints thus far. I'm not thrilled with the fact XMLA uses SOAP, as I don't like SOAP due to personal preferences (it's bulky), but I can live with it.
My thought was setup the PHP front-end application, then install Mondrian and Tomcat, with Tomcat on a separate port (eg. 28311, or whatever). Then for the reporting features within the PHP application, it'll just send XMLA/SOAP requests over to Mondrian, get a response in SOAP, and display it.
Anyone ever done this before? Any advice? Pitfalls I should watch for? It is ok to still store the analytics data in the mySQL database? Or should I maybe syphon that off, and install http://infinidb.org/ or another DB engine on each client's server? Then just have the PHP/mySQL app for the front-end operations only, which also feeds into say InfiniDB for analytics storage & retrieval?