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

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close