I have a personal bias to stay away from self-proclaimed OLAP tools. Developers and architects tend to forget or just plain ignore long term data plans, so tools and contractors are installed to &quot;fix&quot; the long term data issues. I find this is a common mentality among people who are doing operations on the cheap and haven&#39;t researched how this was solved in the past with job automation systems, or mainframes. Which is a shame.*<br>

<br>I would prefer to promote a healthy data life cycle. I still think the best ETL tools, is perl!<br><br>You can achieve OLAP/DWH results with MySQL and MariaDB, you just have to roll your own data lifecycle. CONNECT and multi-source replication certainly help with this (multiple and/or foreign data sources).<br>

<br>From dual have a nicely formatted piece, on creating Materialised Views:<br><a href="http://www.fromdual.ch/mysql-materialized-views">http://www.fromdual.ch/mysql-materialized-views</a><br><br>Rich<br><br><br><br>* Autosys anyone?<br>

<br><br><br><div class="gmail_quote">On 9 July 2013 13:26, Roberto Spadim <span dir="ltr">&lt;<a href="mailto:roberto@spadim.com.br" target="_blank">roberto@spadim.com.br</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

<div dir="ltr">Hi Rich, i just see some guys using OLAP, i don&#39;t have a full understand of what&#39;s OLAP<div>I think we can do with sql, but i don&#39;t know how guys use it, they talk about linq (.net functions), mdx and cubes, check this:<div>


<a href="http://en.wikipedia.org/wiki/Online_analytical_processing" target="_blank">http://en.wikipedia.org/wiki/Online_analytical_processing</a><br></div><div><a href="http://en.wikipedia.org/wiki/OLAP_cube" target="_blank">http://en.wikipedia.org/wiki/OLAP_cube</a><br>


</div><div><a href="http://en.wikipedia.org/wiki/Comparison_of_OLAP_Servers" target="_blank">http://en.wikipedia.org/wiki/Comparison_of_OLAP_Servers</a><br></div><div><br></div><div>I saw guys using with sql server and oracle servers, but i really don&#39;t know how usefull they are</div>


<div>In a high level i think that&#39;s a tool that run over sql layer, something that tcp is over ip protocol, they have cubes (views), measures (columns) and dimensions (rows). i think that each cube is a sql query (? maybe i&#39;m wrong) and measures are columns, and dimensions are rows, something like versions of these measures, or maybe view this as a cube, something like X/Y/Z axis</div>


<div>well i don&#39;t really know what this could do, they tell that&#39;s for datamining and get more information about data, i didn&#39;t see something like this (datamining) in mysql/mariadb, that&#39;s why i asked</div>


<div>i take a look many times ago about column database, that&#39;s a nice tool but i don&#39;t think it&#39;s something that guys see as OLAP solution, column database have a really nice use and can optimize many things</div>


<div><br></div><div>well any information is welcome, i will search more about it, maybe it&#39;s a easy tool to implement (maybe not) but if it&#39;s usefull we could give a try</div></div><div>thanks Rich</div>
</div>
</blockquote></div><br>