The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling - Softcover

Kimball, Ralph; Ross, Margy

Softcover

ISBN 10: 0471200247 ISBN 13: 9780471200246

Verlag: Wiley & Sons, 2002

Inhaltsangabe

". . . one of the definitive books of our industry. If you take the time to read only one professional book, make it this book." -W. H. InmonOne of the most dramatic new developments in database design, the dimensional data warehouse is a powerful database model that.significantly enhances managers' ability to quickly analyze large, multidimensional data sets. Written by the leading proponent of this revolutionary new approach, this valuable book/CD toolkit outfits you with all the nuts-and-bolts information you need to design, build, manage, and use dimensional data warehouses for virtually any type of business application, as well as software for querying dimensional data warehouses.Employing many real-life case studies of data warehouses, Ralph Kimball provides clear-cut guidelines on how to model data and design data warehouses to support advanced multidimensional decision support systems. Beginning with the relatively simple example of a data warehouse for a grocery store, he progresses, step-by-step, through an increasingly complex array of business applications in retail, manufacturing, banking, insurance, subscriptions, and airline reservations. By the end of the book, you will have mastered the full range of powerful techniques for creating, controlling, and navigating dimensional business databases that are easy to understand and navigate.On the CD-ROM you'll find: Software for querying dimensional data warehouses. Working models of all the databases described in the book.

Über diesen Titel

Über die Autorin bzw. den Autor

RALPH KIMBALL, PhD, has been a leading visionary in the data warehouse industry since 1982 and is one of today′s most well– known speakers, consultants, and teachers. He writes the "Data Warehouse Designer" column for Intelligent Enterprise magazine and is also the author of the bestselling books The Data Warehouse Lifecycle Toolkit and The Data Webhouse Toolkit (both from Wiley).
MARGY ROSS is President of DecisionWorks Consulting and a Ralph Kimball Associate. She has focused exclusively on decision support and data warehousing since 1982. Margy coauthored the highly acclaimed The Data Warehouse Lifecycle Toolkit, consults on data warehouse projects worldwide, and teaches data warehouse design for Kimball University.

Von der hinteren Coverseite

The latest edition of the single most authoritative guide on dimensional modeling for data warehousing!

Dimensional modeling has become the most widely accepted approach for data warehouse design. Here is a complete library of dimensional modeling techniques–– the most comprehensive collection ever written. Greatly expanded to cover both basic and advanced techniques for optimizing data warehouse design, this second edition to Ralph Kimball′s classic guide is more than sixty percent updated.

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:
∗ Retail sales and e–commerce
∗ Inventory management
∗ Procurement
∗ Order management
∗ Customer relationship management (CRM)
∗ Human resources management
∗ Accounting
∗ Financial services
∗ Telecommunications and utilities
∗ Education
∗ Transportation
∗ Health care and insurance

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.

Wiley Computer Publishing. Timely. Practical. Reliable.

Visit our Web site at www.wiley.com/compbooks/
Visit Kimball′s Web site at www.kimballuniversity.com

Aus dem Klappentext

The latest edition of the single most authoritative guide on dimensional modeling for data warehousing!

Dimensional modeling has become the most widely accepted approach for data warehouse design. Here is a complete library of dimensional modeling techniques-- the most comprehensive collection ever written. Greatly expanded to cover both basic and advanced techniques for optimizing data warehouse design, this second edition to Ralph Kimball's classic guide is more than sixty percent updated.

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: * Retail sales and e-commerce * Inventory management * Procurement * Order management * Customer relationship management (CRM) * Human resources management * Accounting * Financial services * Telecommunications and utilities * Education * Transportation * Health care and insurance

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.

Wiley Computer Publishing. Timely. Practical. Reliable.

Details zur Ausgabe

• Verlag: Wiley & Sons
• Erscheinungsdatum: 2002
• Sprache: Englisch
• ISBN 10: 0471200247
• ISBN 13: 9780471200246
• Einband: Taschenbuch
• Auflage: 2
• Anzahl der Seiten: 436
• Kontakt zum Hersteller: WROX; https://www.wiley.com/en-us; ; 111 River Street; Hoboken; NJ; 7030; USA
• Verantwortliche Person: Nicht verfügbar