The Data Warehouse Toolkit: The Complete Guide to Dimensional ModelingJohn Wiley & Sons, 8. 8. 2011 - Počet stran: 464 This old edition was published in 2002. The current and final edition of this book is The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition which was published in 2013 under ISBN: 9781118530801. 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. |
Obsah
Dimensional Modeling Primer | 1 |
Retail Sales | 29 |
Inventory | 67 |
Procurement | 89 |
Order Management | 107 |
Customer Relationship Management | 141 |
Accounting | 173 |
Human Resources Management | 187 |
Education | 243 |
Health Care | 255 |
Electronic Commerce | 277 |
Insurance | 305 |
Common Dimensional Modeling Mistakes to Avoid | 326 |
Lifecycle Data Track | 353 |
Present Imperatives and Future Outlook | 371 |
Glossary | 389 |
Financial Services | 199 |
Telecommunications and Utilities | 217 |
Transportation | 229 |
| 419 | |
Další vydání - Zobrazit všechny
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling Ralph Kimball,Margy Ross Zobrazení fragmentů - 2002 |
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling Ralph Kimball,Margy Ross Náhled není k dispozici. - 2002 |
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling Raiph Kimball Náhled není k dispozici. - 2002 |
Běžně se vyskytující výrazy a sousloví
accumulating addition aggregate allow Amount application approach architecture associated attributes bill build Chapter claim codes column combinations common complete conformed contains cost create data marts data warehouse database date dimension Date Key FK describe Description detailed dimension table dimensional model discussed Dollar effective employee event example fact table Figure Finally given grain granularity handle identify Indicator individual interesting inventory join look measure month multiple Name natural operational organization performance period physical presentation primary product dimension profit promotion purchase Quantity query record refer represent requirements response schema separate session Ship single snapshot specific staging standard technique track transaction typically understand users