Mastering Data Warehouse Design: Relational and Dimensional Techniques
-
Author:
-
Subject:
-
Published by:John Wiley & Sons Inc (US)
-
Published:25/07/2003
-
Price:$67.99
- < Buy this book >
- 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
Biography
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.
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.
Glossary.
Recommended Reading.
Index.
- CCDB2 / DBA Technical Consultant - Finance company - Melbourne CBD - DB2VIC
- FTMobile Portal Architect - .Net TechnologiesNSW
- FTSenior .Net Developer - Mobility/Portal SolutionsNSW
- FTAccount Manager - Strategic Enterprise DevelopmentNSW
- FTTechnical Operations ManagerNSW
- FTDigital Account ManagerNSW
- FTSupport Consultant - Global Vendor - $55-75,000NSW
- FTDigital Account ManagerNSW
- CCDigital Business Analyst - Agile/ScrumNSW
iAsset is a channel management ecosystem that automates all major aspects of the entire sales,marketing and service process, including data tracking, integrated learning, knowledge management and product lifecycle management.
HiveManager Online: Less Dollars, More Sense
Today’s de facto standard controller-based Wi-Fi infrastructure model is just too complicated, too expensive, and too unreliable. It’s common for enterprise and mid-market network operators alike to get caught in a crossroads of compromises involving costs, complexity, features, and reliability.
HiveManager Online: Less Dollars, More Sense
Today’s de facto standard controller-based Wi-Fi infrastructure model is just too complicated, too expensive, and too unreliable. It’s common for enterprise and mid-market network operators alike to get caught in a crossroads of compromises involving costs, complexity, features, and reliability.








