Mastering Data Warehouse Design: Relational and Dimensional Techniques - Softcover

At last, a balanced approach to data warehousing that leverages the techniques pioneered by Ralph Kimball and Bill Inmon

Since its groundbreaking inception, the approach to understanding data warehousing has been split into two mindsets: Ralph Kimball, who pioneered the use of dimensional modeling techniques for building the data warehouse, and Bill Inmon, who introduced the Corporate Information Factory and leads those who believe in using relational modeling techniques for the data warehouse. Mastering Data Warehouse Design successfully merges Inmon's data ware- house design philosophies with Kimball's data mart design philosophies to provide you with a compelling and complete overview of exactly what is involved in designing and building a sustainable and extensible data warehouse.

Most data warehouse managers, designers, and developers are familiar with the open letter written by Ralph Kimball in 2001 to the data warehouse community in which he challenged those in the Inmon camp to answer some tough questions about the effectiveness of the relational approach. Cowritten by one of the best-known experts of the Inmon approach, Claudia Imhoff, this team of authors addresses head-on the challenging questions raised by

Kimball in his letter and offers a how-to guide on the appropriate use of both relational and dimensional modeling in a comprehensive business intelligence environment. In addition, you'll learn the authors' take on issues such as:

• Which approach has been found most successful in data warehouse environments at companies spanning virtually all major industrial sectors
• The pros and cons of relational vs. dimensional modeling techniques so developers can decide on the best approach for their projects
• Why the architecture should include a data warehouse built on relational data modeling concepts
• The construction and utilization of keys, the historical nature of the data warehouse, hierarchies, and transactional data
• Technical issues needed to ensure that the data warehouse design meets appropriate performance expectations
• Relational modeling techniques for ensuring optimum data warehouse performance and handling changes to data over time