News Stay informed about the latest enterprise technology news and product updates.

Building the Enterprise Data Warehouse

Following is a "Letter to Bill" that Bill Inmon recently received from Ernest Chan, information architect with Kaiser Permanente's Information Technology group. Bill wholeheartedly agrees with the solution described.

This article originally appeared on the BeyeNETWORK

Hi Bill,

One of the things I have been thinking about is how we can balance the long-term strategic need to properly architect an enterprise data warehouse (EDW), with the ability to respond quickly to the short-term expectations of the business users, and I wanted to share with you – and get your thoughts on – what I have come up with. 
As you have taught me, the successful data warehouse is built iteratively and in small, fast increments. 

The approach is to start with a "thin slice" of the enterprise logical data model (LDM) and introduce that into the EDW. This thin slice can either be "vertical" comprising the major entities from one subject area, or "horizontal" across different subject areas that when brought together and integrated, multiply the business value beyond that of its constituents. 


As each slice is introduced into the EDW, the data marts that represent the most effective and actionable subset of data, can be built off that slice, thus demonstrating business value to the end-user community fairly quickly, without waiting for the full-blown EDW to be built. 



Dig Deeper on Data warehouse software

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.