[Mondrian] Querying non-SQL multidimensional store

Radek Maciaszek radek.maciaszek at gmail.com
Wed Nov 14 17:52:57 EST 2012


Thanks guys, yes either of these solution should do work. Hsqldb sounds especially tempting.

Best,
Radek

On 13 Nov 2012, at 17:55, Julian Hyde <jhyde at pentaho.com> wrote:

> I suggest that you populate a single table in an embedded or embeddable database like hsqldb or MonetDB. Mondrian will talk to it via SQL but because it is embedded you don't need to worry about it. Pentaho Instaview works in this way (using MonetDB).
> 
> Julian
> 
> 
> On Nov 11, 2012, at 1:09 PM, Radek Maciaszek <radek.maciaszek at gmail.com> wrote:
> 
>> Hi,
>> 
>> I am trying to figure out how I can make my object database work with Mondrian. Is there any way to make Mondrian work with a non-SQL storage? I have a data store with multidimensional arrays, which I would like to expose to Mondrian. My arrays are rather small so I can load them into memory - perhaps it would be possible to somehow popular the Mondrian cache with them within my Dialect implementation? This way Mondrian would never have to issue any SQL queries as all data would be loaded into the cache. Any ideas are appreciated.
>> 
>> Thanks,
>> Radek
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20121114/6e72bbea/attachment.html 


More information about the Mondrian mailing list