THE NINE IS NOW OUT

THE WORLD’S FOREMOST INDEPENDENT EXPERT ON WORKPLACE COLLABORATION & TECHNOLOGY 🇺🇦

Traditional Data Warehouses Can’t Do it All

Thoughts on the future of data storage and analytics.
Dec | 12 | 2016

Dec | 12 | 2016
}

 

Introduction

As part of my new professor gig, I teach CIS405 (Business Intelligence) at the W. P. Carey School. It’s an online course that demonstrates how students can turn raw data into intelligence, insights, analytics, and, ultimately, better business decisions.

When I think about contemporary business intelligence, data mining, data visualization, data warehousing, and analytics, I find it difficult to explain simply where one ends and the others begin. On the contrary, there seems to be a great deal of overlap among these terms and concepts. To be sure, things are muddier than ever here.

It’s more clear that ever, though, traditional data warehouses will not store every type of information relevant to an enterprise. To paraphrase Kevin Hart, let me explain why.

Limitations of Traditional Data Warehouses

My new friend and ASU colleague Alan Simon is an expert here. I’m not. Still, I’ve worked around data warehouses (DWs) for a long time. Sure, they can store a great deal of data from different sources. Make no mistake, though: This benefit is concurrently a limitation. That is, DWs require very specific and static structures and categories. The word flexible certainly doesn’t come to mind. (This problem is more acute when organizations lack a proper data-warehousing strategy.) Collectively, these rules and decisions restrict the types of analysis that organizations can perform.

Despite their considerable warts, mature BI and DW tools will remain in place for decades.

For years, data warehouses represented the best that we could do for data storage and consolidation. Not anymore. Hadoop and other NoSQL databases inarguably represent the future of data storage. Some have even that DW appliances will go the way of the Dodo. Ditto for the “traditional” single-database implementation of a DW.

Fortunately, there’s good news for those looking for more flexible data-storage, reporting, and infrastructure solutions. New tools can handle significantly faster, larger, and more diverse datasets—and offer real-time analytics in the process. (This is essential, as data streams will doubtless increase in the future with no end in sight.)

Simon Says: Get ready for new data-management and -storage tools.

Brass tacks: Despite their considerable warts, I don’t doubt for a minute that mature BI and DW tools will remain in place for decades, particularly at mature organizations that have spent millions configuring them just right.Old habits die hard.

Many CXOs of mature organizations will eventually realize, however, that new data varieties, velocities, and volumes [PDF], simply won’t play nicely—if at all—with traditional data-management and -storage tools. Expect new ones such as data lakes to rise in importance over the next few years.

Feedback

What say you?

IBM sponsored this post.

Receive my musings, news, and rants in your inbox as soon as they publish.

 

Blog E Higher Education E Traditional Data Warehouses Can’t Do it All

Related Posts

From Big to Small

Layoffs are all the rage these days. Microsoft, Zoom, Amazon, Meta, and Salesforce are just some of the companies that have let go of thousands of employees. Yet the labor market remains white hot. Unemployment is 3.4 percent. It's a question that I consider in The...

Book Review: Wonder Boy

In 2011, I moved from NJ to Vegas. It didn't take long for me to hook up with the Vegas tech scene and the Downtown Project. Over the course of my five years in Sin City, I attended events, spoke at Zappos's HQ a few times, met plenty of smart cookies, and learned a...

0 Comments

Submit a Comment

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