Thanks charly<br>as you mentioned:"Palo save data directly in the server" as a data warehouse?<br>So if use mondrian , is it better to use a DW(like Infosight or Bizgres) to build the multi dimensional table first <br>
in order to increase performance?<br><br>Regards<br><br><br><br><br><div class="gmail_quote">2009/3/20 Charly CLAIRMONT <span dir="ltr"><<a href="mailto:charly.clairmont@altic.org">charly.clairmont@altic.org</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi all !<br><br>Just to make a little answer about differences between Palo and Mondrian. <br>
<br>Firstly, it's not the same approach. In OLAP technologie you have : <br> - ROLAP, like Mondrian, the engine is based on a relational database to expose dimensions<br>
<a href="http://en.wikipedia.org/wiki/ROLAP" target="_blank">http://en.wikipedia.org/wiki/ROLAP</a><br><br> - MOLAP, like Palo, the engine has is own data storage and save data directly in dimensional aspects...<br> <a href="http://en.wikipedia.org/wiki/MOLAP" target="_blank">http://en.wikipedia.org/wiki/MOLAP</a><br>
<br>You also have HOLAP... and hybrid approach...<br><br>You have to pay attention about Palo if you store too many data inside a cube... In a relational database you don't ask you this question...<br><br>Cheers...<br>
<br><div class="gmail_quote">2009/3/20 Lin Chun <span dir="ltr"><<a href="mailto:franks1984@gmail.com" target="_blank">franks1984@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div class="h5">
hi <br><div style="color: rgb(0, 0, 0); font-weight: 400; font-style: normal; font-family: serif; font-size: 16px;">
I am a newer to open source BI. For the last days I've done some reseach in <br>
OSBI for finding a BI solution. Now I'm studying in OLAP server , while these are too projects Mondian and palo, but I cannot find any comparation between them in technique point of view also in bussiness point of view~<br>
Looking forward to your answers,Thanks
</div>
<br></div></div>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><font color="#888888"><br><br clear="all"><br>-- <br>-- -- -- --<br>CCharly<br>
</font><br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>-------------------------<br>Lin Chun<br>