… performance. I plan on covering the following topics: Introduction to OLAP and business intelligence. (this post) Identifying the differences between a… performed, but more on this in post #2. OLAP? What is that? OLAP is an acronym which stands for online analytical processing…. There are two main ways to store multidimensional data for OLAP analysis OLAP servers typically come in two basic flavors. Some servers…
Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks
January 28, 2010 By 16 Comments
…. I have next goals with proposed benchmark: Compare engines in OLAP queries for planning, predicting growth, analyzing access patterns to wiki…
Post: Data mart or data warehouse?
July 15, 2010 By 13 Comments
… on business intelligence, with a focus on OLAP analysis. Part 1 – Intro to OLAP Identifying the differences between a data warehouse and… views to automate that aggregation process. Comparing the performance of OLAP with and without aggregation over multiple MySQL storage engines at… warehousing has become an overloaded term that includes BI tools (OLAP/data mining), data extraction and transformation tools (ETL), and schema…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… fruit where these are concerned. This is particularly true for OLAP workloads. While I’m not going to diverge into a discussion of how OLAP varies from OLTP, it suffices to say that a typical… that Shard-Query performs better is that it turns the OLAP query into something more like OLTP. Instead of getting one…
Comment: Intro to OLAP
August 8, 2010 By 9 Comments
… it will work or not? Another query about CUBE and OLAP (whether MOLAP,ROLAP,HOLAP), what’s the difference between CUBE and OLAP? Looks like when we talk about OLAP, we are also talking about CUBE. So…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
… defects in Infobright that would be “show stoppers” for typical OLAP analysis queries. These tests were intended to approximate what would happen if you ported a MyISAM OLAP application to ICE. My testing suggests that with some basic…
Comment: Should you move from MyISAM to Innodb ?
January 28, 2009 By 53 Comments
…Peter >Yes I speak mostly about OLTP. OLAP with full table scans and similar stuff indeed is the … choice than MyISAM. Because I’m that guy who develops OLAP system. My DBs are very small compared to the mentioned…
Comment: High-Performance Click Analysis with MySQL
December 23, 2008 By 13 Comments
… is data mining the raw data from MySQL slaves into OLAP cube and then query the cube from the application, leaving… the application while the reporting is on different set of OLAP servers.
Comment: Intro to OLAP
January 16, 2012 By 9 Comments
dear justin, here are a few questions , in terms of OLAP with native community edition MySQL cluster running on Redhat Linux…
Comment: Data mart or data warehouse?
October 4, 2011 By 13 Comments
Hi congrats for the article. It’s very impressive. I’d like to know when you will be finishing the others topics from the list. I’m learning the OLAP/OLTP/Cubes concepts and i need some guide. thanks
