Enabling Real-Time Analytics With Database In-Memory

Defining Analytics

Andy Rivenes
Product Manager

We tell people that Database In-Memory is all about improving analytic processing. The definition that I use is "using aggregation to find patterns or trends in data". I believe I saw this used in one of Juan Loaiza's OpenWorld presentations and it made sense to me. After all Database In-Memory is really good at scanning and filtering a lot of data, and most of the articles on this blog echo that theme.

The problem is, the definition that I use doesn't necessarily make sense for everyone. When we do presentations or give webinars many people don't seem to really get what we mean by analytics.

While watching the Golden State Warriors two weeks ago from my hotel room the TV commentators began discussing how the Warriors use analytics pretty extensively and they mentioned that this is in no way mainstream in basketball.

This reminded me of where baseball was back when Michael Lewis published Moneyball: The Art of Winning an Unfair Game, the story about how the Oakland Athletics (another SF Bay Area team) used an analytic, evidence-based, approach to competing in Major League Baseball. At the time they were severely chastised by the baseball establishment and the story made for a pretty good book and movie.

So I did a little surfing on what the Warriors define as analytics and found the following quote in an article on SF Gate:

“We always want to be pioneers, first-adopters, because we believe that having the most information gives us the best chance of making the right decisions,” said Warriors assistant general manager Kirk Lacob, who often spearheads the team’s analytics staff. “I don’t understand anyone who says, 'I don’t like analytics,’ because they’re basically saying, 'I like to just guess.’ Analytics doesn't mean stats; it means using information or data to make informed decisions.”
SF Gate, http://www.sfgate.com/warriors/article/Golden-State-Warriors-at-the-forefront-of-NBA-5753776.php

I'll re-phrase Kirk Lacob's definition of analytics to "using information or data to make informed decisions". And that's what Database In-Memory is all about. The ability to run adhoc, analytic queries on source data without impacting the existing workload, except for the CPU cycles required to scan the data in-memory. There is also the additional benefit, or side-effect, in a mixed workload environment of allowing the removal of analytic indexes that probably only exist to support analytic reporting. You can even read about a real world use case where Bosch was able to remove 76 analytic reporting indexes to improve the performance of their SAP CRM system.

Now that we have a better idea of what analytics are, next up we will try characterizing an analytic query.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.