January 24, 2011

Do we still need EDWs?

Colin White reopened the question of whether enterprise data warehouses (EDW) are still needed, lining up and knocking down a number of traditional pro-EDW arguments, in more detail than I ever have. So this feels like a good time to revisit my answer to the question of the EDW’s role, whose money quote was:

At conventional enterprises … Manage some of your data to enterprise data warehouse standards, but not all of it. Specifically, your highest-value data should be in something that looks like a classic enterprise data warehouse, and your lower-value data shouldn’t.

For sufficiently small enterprises, the “something that looks like a classic enterprise data warehouse” might just be your One Central Database, combining OLTP (OnLine Transaction Processing) and analytics. Otherwise, the chances are high that you’re going to want to copy your data crown jewels to an EDW, even if they’re also being used as analytic inputs directly from the OLTP systems that first capture them.

As I’ve recently reviewed, there are huge amounts of specialized technology for SQL queries and other analytics. Classical EDW vendors may not be the best or lowest-cost providers of such technology. And even when the EDW is technically competitive, the bureaucratic processes around it can impede rapid adoption of important analytic tools. So Colin is directionally right, in that most large enterprises should be taking the EDW concept less seriously than they currently do. But core EDW technology and business attitudes shouldn’t be entirely discarded either.


3 Responses to “Do we still need EDWs?”

  1. Tweets that mention Do we still need EDWs? | DBMS 2 : DataBase Management System Services -- Topsy.com on January 24th, 2011 6:25 pm

    […] This post was mentioned on Twitter by Curt Monash and Database_News, Julie Hunt. Julie Hunt said: RT @CurtMonash: http://www.dbms2.com/2011/01/24/do-we-still-need-edws/ Do we still need enterprise data warehouses? #EDW […]

  2. Search Facets » Notes from the Field: BI Outside the Warehouse on January 26th, 2011 11:00 pm

    […] Is an Enterprise Data Warehouse Still Required for Business Intelligence?, Curt Monash reiterates his advice […]

  3. Where Next for Big Data? | Tibco Guru on September 10th, 2011 10:18 am

    […] it seems even DB afficionados are beginning to question the roles databases play in enterprises… This entry was posted in Uncategorized and tagged Business Work, ems, […]

Leave a Reply

Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:


Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.