Mastering Data Warehouse Aggregates
Solutions for Star Schema Performance
(Sprache: Englisch)
As the first book to provide in-depth coverage of aggregates, this critical resource addresses how aggregates are the single-most effective tool the data warehouse designers has to control performance. As an expert in data warehouse design and deployment,...
Leider schon ausverkauft
versandkostenfrei
Buch (Kartoniert)
39.90 €
Produktdetails
Produktinformationen zu „Mastering Data Warehouse Aggregates “
As the first book to provide in-depth coverage of aggregates, this critical resource addresses how aggregates are the single-most effective tool the data warehouse designers has to control performance. As an expert in data warehouse design and deployment, author Chris Adamson educates IT managers and data warehouse designers and developers on the benefits and techniques of aggregate implementation.
Klappentext zu „Mastering Data Warehouse Aggregates “
The first book to offer in-depth coverage of star schema aggregate tables Dubbed by Ralph Kimball as the most effective technique for maximizing star schema performance, dimensional aggregates are a powerful and efficient tool that can accelerate data warehouse queries more dramatically than any other technology. After you ensure that a database is properly designed, configured, and tuned, any measures you take to address data warehouse performance should begin with aggregates. Yet, many businesses ignore aggregates, instead turning to specialized, proprietary hardware and software products to solve performance problems. This book fills the knowledge gap that has led businesses on this expensive and risky path. Data warehouse expert Chris Adamson shows how a well-planned set of aggregates can have an extraordinary effect on the overall throughput of your data warehouse. Regardless of your role or current level of star schema expertise, the best practices in this book will help you achieve astounding performance increases, while avoiding common pitfalls. From star schema basics through advanced aggregation techniques, this book covers the impact of aggregate tables on the entire data warehouse lifecycle. After establishing a few fundamentals, including the star schema approach to data warehouse design, chapters are dedicated to major phases of the data warehouse lifecycle. Topics include: * Fundamental principles of aggregate schema design * How to use aggregates in a production environment, with or without an aggregate navigator * Integration of aggregate processing into the ETL process * Standard tasks and deliverables for incorporating aggregates into data warehouse development projects * How to organize and execute a project that adds aggregate capability to an existing star schema * The impact of advanced schema design techniques such as bridge tables, heterogeneous stars, or snapshot models on aggregation * Special considerations when implementing dimensional
... mehr
aggregates using Oracle's materialized views or IBM's materialized query tables * How aggregates can add value in other areas, including database security and the archive strategy Wiley Technology Publishing Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/
... weniger
Inhaltsverzeichnis zu „Mastering Data Warehouse Aggregates “
- Foreword.- Acknowledgments.
- Introduction.
- Chapter 1 Fundamentals of Aggregates.
- Chapter 2 Choosing Aggregates.
- Chapter 3 Designing Aggregates.
- Chapter 4 Using Aggregates.
- Chapter 5 ETL Part 1: Incorporating Aggregates.
- Chapter 6 ETL Part 2: Loading Aggregates.
- Chapter 7 Aggregates and Your Project.
- Chapter 8 Advanced Aggregate Design.
- Chapter 9 Related Topics.
- Glossary.
- Index.
Autoren-Porträt von Christopher Adamson
Christopher Adamson is a data warehousing consultant and founder of Oakton Software LLC. An expert in star schema design, he has managed and executed data warehouse implementations in a variety of industries. His customers have included Fortune 500 companies, large and small businesses, government agencies, and data warehousing tool vendors. Mr. Adamson also teaches dimensional modeling and is a co-author of Data Warehouse Design Solutions (also from Wiley). He can be contacted through his website, www.ChrisAdamson.net.
Bibliographische Angaben
- Autor: Christopher Adamson
- 2006, 336 Seiten, Kartoniert (TB), Englisch
- Verlag: Wiley & Sons
- ISBN-10: 0471777099
- ISBN-13: 9780471777090
Sprache:
Englisch
Kommentar zu "Mastering Data Warehouse Aggregates"
0 Gebrauchte Artikel zu „Mastering Data Warehouse Aggregates“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Mastering Data Warehouse Aggregates".
Kommentar verfassen