Originally published on April 7, 2013
While reading and researching upon the topic of Business Intelligence, I ended up casually researching the topic of Database Cubes. (OLAP and OLTP databases)
Now, it’s definitely not the first time I’ve come across that term. I recall at least two discussions (number of years ago), where the topic of database cubes had come up.
But, then I found the following article link. This article does a pretty good job of explaining what database cubes are, how they function (on a high level) and what the intended usage of a cube would be.
The thing that piques my interest: Since the cube contains all of your data in an aggregated form, it seems to know the answers in advance. Not so great for real-time/dynamic reporting but everything else can be computed at lightning speeds.
So when you talk about dashboards, Business Intelligence Applications e.t.c. What’s really driving the bulk of the analytics on the GUI are Database Cubes in the back-end.
Technology of this kind automatically draws you in. I mean, by now my career has spanned across a bunch of different areas in the industry. And I am thinking of a couple of ways, where leveraging the capabilities offered by the usage of database cubes can compliment existing offerings. It’s not just general Business Intelligence suite of applications. So many other industries like Business Continuity, Risk Management, Corporate Security e.t.c can also benefit from such technologies. The key is to go from being reactive to being pro-active and the technology exists to be able to guide those actions.
Off-topic, I was watching this interview by Steve Jobs. The interview was conducted in 1995 and Jobs was talking about Disruption and Net-Neutrality. Mind blown….. I am in awe. I mean we are increasingly talking about these topics today and Jobs prophesied them some 18 years ago. Specific to the topic of discussion, I noticed that Next’s logo was in the shape of a cube and so were the machines. Co-incidence? It's not related in any way. I don't know why this off-topic blurb is here. I just like Next's logo. And I like cubes.