- Used Books
- Staff Picks
- Gifts & Gift Cards
- Sell Books
- Stores & Events
- Let's Talk Books
Special Offers see all
More at Powell's
Recently Viewed clear list
Mastering Data Warehouse Design: Relational and Dimensional Techniquesby Claudia Imhoff
Synopses & Reviews
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 Inmons data ware- house design philosophies with Kimballs 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, youll learn the authors take on issues such as:
Book News Annotation:
Bill Inmon, one of the pioneers of data warehouses for business, defined a warehouse "a subject-oriented, integrated, time variant, and non-volatile collection of data used in strategic decision making." This text brings together Inmon's relational modeling approach to warehouses with other design philosophies more reliant on dimensional modeling. The authors describe types of data models used for different "business intelligence" functions, explore the step-by-step construction of a data warehouse model, and discuss deployment issues and common problems.
Annotation ©2004 Book News, Inc., Portland, OR (booknews.com)
Includes bibliographical references (p. 409-410) and index.
About the Author
CLAUDIA IMHOFF (CImhoff@Intelsols.com) is President and Founder of Intelligent Solutions, a leading consultancy on analytic CRM and BI technologies and strategies. She is a popular speaker, an internationally recognized expert, and coauthor of five books.
NICHOLAS GALEMMO (email@example.com) was Information Architect at Nestlé USA. He has twenty-seven years’ experience as a practitioner and consultant involved in all aspects of application systems design and development. He is currently an independent consultant.
JONATHAN G. GEIGER (JGeiger@IntelSols.com) is Executive Vice President at Intelligent Solutions, Inc. In his thirty years as a practitioner and consultant, he has managed or performed work in virtually every aspect of information management.
Table of Contents
About the Authors.
PART ONE: CONCEPTS.
Chapter 1. Introduction.
Chapter 2. Fundamental Relational Concepts.
PART TWO: MODEL DEVELOPMENT.
Chapter 3. Understanding the Business Model.
Chapter 4. Developing the Model.
Chapter 5. Creating and Maintaining Keys.
Chapter 6. Modeling the Calendar.
Chapter 7. Modeling Hierarchies.
Chapter 8. Modeling Transactions.
Chapter 9. Data Warehouse Optimization.
PART THREE: OPERATION AND MANAGEMENT.
Chapter 10. Accommodating Business Change.
Chapter 11. Maintaining the Models.
Chapter 12. Deploying the Relational Solution.
Chapter 13. Comparison of Data Warehouse Methodologies.
What Our Readers Are Saying
Average customer rating based on 1 comment:
Other books you might like
Computers and Internet » Artificial Intelligence » General