Is this the age of Big OLAP?

Is this the age of Big OLAP?

Is this the age of Big OLAP?

There was a time when analytics was synonymous with BI, and BI was synonymous with OLAP -- Online Analytical Processing. The term was meant to contrast with the more common Online Transaction Processing (OLTP), and involved the creation of multi-dimensional "cubes" rather than 2-dimensional tables. Each dimension is a different category with which to perform drill-down analyses on numerical data, known as measures.

Now that you've had your BI 101 crash course, look around at numerous analytics products like Tableau, and you'll see the paradigm of dimensions and measures is alive and well. OLAP never died, even if its underlying technologies morphed a bit.

The justice of scale What has dogged OLAP, though, is its scalability. Most OLAP servers run on single, albeit beefy, servers, which limits the parallelism that can be achieved and therefore imposes de facto limits on data volumes. Customers who hit these scalability ceilings may contemplate using Big Data technologies, like Hadoop and Spark, but those tend not to employ the dimensional paradigm to which OLAP users are accustomed.

Read Also:
Predicting Wine Quality with Azure ML and R

What to do? Well, a few vendors have decided to take Hadoop and Spark, and leverage them as platforms on which big OLAP cubes can be run and built. The vendors, namely AtScale, Kyvos Insights and Arcadia Data, have looked at Big Data adoption patterns in some enterprises, and seen that momentum has stalled. Their approach has been to let people in those enterprises work in the OLAP environments they are comfortable with and, at the same time, make use of their Hadoop clusters.

AtScale's CEO, David Mariani, was the person behind a couple of the biggest Microsoft OLAP projects (at Yahoo and Klout). And while he was able to do big things with Microsoft's OLAP platform, SQL Server Analysis Services (SSAS), he definitely hit up against scalability limits, including cube re-processing times of as much as a week. His motivation for creating a more resilient OLAP platform was pretty clear, so he formed AtScale.

Read Also:
Avoid the storm with trusted data

Three approaches AtScale cubes can be made to appear to BI clients as if they were SSAS cubes. So compatibility is high.

 



Chief Data Officer Europe
20 Feb

15% off with code CDO7W17

Read Also:
Who Is Going To Win Artificial Intelligence Race?
Predictive Analytics Innovation summit San Diego
22 Feb

$200 off with code DATA200

Read Also:
SAP previews new analytics tools for IT, business users
Read Also:
The Rise of Event-Driven Computing and the Keys to Microservices Applications
Read Also:
Data Management: 2016’s Hot Trends and What to Watch in 2017 -

Leave a Reply

Your email address will not be published. Required fields are marked *