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 "fix" the long term data issues. I find this is a common mentality among people who are doing operations on the cheap and haven't researched how this was solved in the past with job automation systems, or mainframes. Which is a shame.* I would prefer to promote a healthy data life cycle. I still think the best ETL tools, is perl! 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).
From dual have a nicely formatted piece, on creating Materialised Views: http://www.fromdual.ch/mysql-materialized-views
Rich * Autosys anyone? On 9 July 2013 13:26, Roberto Spadim <roberto@spadim.com.br> wrote:
Hi Rich, i just see some guys using OLAP, i don't have a full understand of what's OLAP I think we can do with sql, but i don't know how guys use it, they talk about linq (.net functions), mdx and cubes, check this: http://en.wikipedia.org/wiki/Online_analytical_processing http://en.wikipedia.org/wiki/OLAP_cube http://en.wikipedia.org/wiki/Comparison_of_OLAP_Servers
I saw guys using with sql server and oracle servers, but i really don't know how usefull they are In a high level i think that'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'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 well i don't really know what this could do, they tell that's for datamining and get more information about data, i didn't see something like this (datamining) in mysql/mariadb, that's why i asked i take a look many times ago about column database, that's a nice tool but i don't think it's something that guys see as OLAP solution, column database have a really nice use and can optimize many things
well any information is welcome, i will search more about it, maybe it's a easy tool to implement (maybe not) but if it's usefull we could give a try thanks Rich