The Business Intelligence Blog

Slicing Business Dicing Intelligence

The Flaws of the Classic Data Warehouse Architecture  

This CDWA has served us well the last twenty years. In fact, up to five years ago we had good reasons to use this architecture. The state of database, ETL, and reporting technology did not really allow us to develop something else. All the tools were aimed at supporting the CDWA. But the question right now is: twenty years later, is this still the right architecture? Is this the best possible architecture we can come up with, especially if we consider the new demands and requirements, and if we look at new technologies available in the market? My answer would be no! To me, we are slowly reaching the end of an era. An era where the CDWA was king. It is time for change. This article is the first in a series on the flaws of the CDWA and on an alternative architecture, one that fits the needs and wishes of most organizations for (hopefully) the next twenty years. Let’s start by describing some of the CDWA flaws.

The first flaw is related to the concept of operational business intelligence. More and more, organizations show interest in supporting operational business intelligence. What this means is that the reports that the decision makers use have to include more up-to-date data. Refreshing the source data once a day is not enough for those users. Decision makers who are quite close to the business processes especially need 100% up-to-date data. But how do you do this? You don’t have to be a technological wizard to understand that, if data has to be copied four or five times from one data storage layer to another, to get from the production databases to the reports, doing this in just a few seconds will become close to impossible. We have to simplify the architecture to be able to support operational business intelligence. Bottom line, what it means is that we have to remove data storage layers and minimize the number of copy steps.

Great read from BEye Network. Part 1 and Part 2.

share the post:
  • Twitter
  • Facebook
  • LinkedIn
  • FriendFeed
  • del.icio.us
  • Google Bookmarks
  • HackerNews
  • Live

The article has

one response

Written by Guru Kirthigavasan

April 7th, 2009 at 6:08 pm

One Response to 'The Flaws of the Classic Data Warehouse Architecture'

Subscribe to comments with RSS or TrackBack to 'The Flaws of the Classic Data Warehouse Architecture'.

  1. Nice information, but why didn’t you emphasize on advantages along with flaws.

    David Morson

    25 Nov 09 at 4:12 am

Leave a Reply