Alternative data warehousing frameworks

Alternative data warehousing frameworks

The only work I know on data warehouse that provides a framework or a blueprint to build a decision support system environment is that proposed by Bill Inmon and called CIF (Corporate Information Factory). Do you know another approach that you can recommend me to evaluate?

    Requires Free Membership to View

    When you register, you'll begin receiving targeted emails from my team of award-winning editorial writers on the latest customer relationship management (CRM)and call center technology issues today. Our goal is to keep you informed on the hottest issues facing this fast-changing industry.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchCRM.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchCRM.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Why do you need another approach? ;-)

Actually, Bill Inmon and Claudia Imhoff's Corporate Information Factory is the most well-known data warehouse methodology due to its prime mover advantage, its wide circulation in several releases of the book of the same name and its practical applicability to a wide variety of situations. Certainly, there are other methodologies available through consultancies, which you will learn the details of once you engage with them, for obvious reasons. Guidelines and highlights of methodologies, however, are published on a number of data warehouse consultancy web sites, mine included (www.mcknight-associates.com).

An alternative, very popular, methodology is a "bottom up" approach popularized by Ralph Kimball (www.rkimball.com). Pieter Mimno has a similar approach which he wrote up in the TDWI Flashpoint on August 28, 2002 if you can get that. Here's a summary:

SUMMARY: In my consulting practice, I recommend an incremental, "bottom-up" implementation methodology, similar to that advocated by Ralph Kimball. This has proven to be a successful deployment approach to ensure a short-term return on investment with minimal project risk, while still delivering a data warehousing architecture that provides a standardized, enterprise-wide view of information. This FlashPoint column describes a typical project plan based on a bottom-up implementation methodology.

This was first published in February 2003

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.