The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd Edition
ISBN: 978-0-471-20024-6
April 2002
464 pages
ISBN: 978-0-471-20024-6
April 2002
464 pages
The authors begin with fundamental design recommendations and gradually progress step-by-step through increasingly complex scenarios. Clear-cut guidelines for designing dimensional models are illustrated using real-world data warehouse case studies drawn from a variety of business application areas and industries, including:
By the end of the book, you will have mastered the full range of powerful techniques for designing dimensional databases that are easy to understand and provide fast query response. You will also learn how to create an architected framework that integrates the distributed data warehouse using standardized dimensions and facts.
Ralph Kimball invented a data warehousing technique called "dimensional modeling" and popularized it in his first Wiley book, The Data Warehouse Toolkit. Since this book was first published in 1996, dimensional modeling has become the most widely accepted technique for data warehouse design. Over the past 5 years, Kimball has improved on his earlier techniques and created many new ones. In this second edition, he provides a comprehensive collection of all of these techniques, from basic to advanced.