Mastering Data Warehouse Design: Relational and Dimensional Techniques

Customers who bought this, also bought: The Data Warehouse ETL Toolkit : Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data The Data Warehouse Toolkit : The Complete Guide to Dimensional Modeling 2nd edition Building the Data Warehouse, 3rd Edition (for 4th edition please perform new search using ISBN: 0764599445 ) MCTS Self-Paced Training Kit (Exam 70-445) Bk/CD/DVD: Microsoft SQL Server 2005 Business Intelligence Implement & Maintain Perl Best Practices Oracle PL/SQL Language Pocket Reference, 3rd Edition A guide to Oracle's PL/SQL language fundamentals Perl Pocket Reference, 4th Edition Java Web Services - Using Java in Service Oriented Architectures Microsoft SQL Server 2005 Reporting Services 2005 Data Warehouse Lifecycle ToolKit, 2nd Edition

by: Claudia Imhoff, Nicholas Galemmo, Jonathan G. Geiger

On-line Price: $49.95 (includes GST) Paperback package 456 17%Off Retail Price You save: $10.00 In Stock - Available for immediate delivery! _____________________ N.Sydney : In Stock Supplier : In Transit	Retail Price: $59.95 Publisher: John Wiley & Sons,2003/07/31 Category: DATA WAREHOUSING Level: ISBN: 0471324213 ISBN13: 9780471324218
Add to Shopping Cart

* A cutting-edge response to Ralph Kimball's challenge to the data warehouse community that answers some tough questions about the effectiveness of the relational approach to data warehousing

* Written by one of the best-known exponents of the Bill Inmon approach to data warehousing

* Addresses head-on the tough issues raised by Kimball and explains how to choose the best modeling technique for solving common data warehouse design problems

* Weighs the pros and cons of relational vs. dimensional modeling techniques

* Focuses on tough modeling problems, including creating and maintaining keys and modeling calendars, hierarchies, transactions, and data quality

Table of Contents

Acknowledgments.

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.

  Glossary.

  Recommended Reading.

  Index.

  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 (ngalemmo@yahoo.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.