Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance

Buy
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 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/

About the Author
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.

(HTML tags aren't allowed.)

Water Resilience: Management and Governance in Times of Change
Water Resilience: Management and Governance in Times of Change

This book synthesizes current knowledge and understanding of management and governance in the context of water resilience; advances theory through synthesis of research and experiences from a variety of disciplinary perspectives.  The book highlights the implications of theory and experience for innovation in practice and...

CCNA Practice Questions Exam Cram 2 (2nd Edition)
CCNA Practice Questions Exam Cram 2 (2nd Edition)

The CCNA is the first exam a candidate takes on the road toward becoming a Cisco certified professional or expert. While Cisco exams are considered very difficult, these exams are also very popular. The CCNA Practice Questions Exam Cram 2 will provide you with 500 practice questions and...

Color Imaging: Fundamentals and Applications
Color Imaging: Fundamentals and Applications

Color is one of the most fascinating areas to study. Color forms an integral part of nature, and we humans are exposed to it every day. We all have an intuitive understanding of what color is, but by studying the underlying physics, chemistry, optics, and human visual perception, the true beauty and complexity of color can be...


Growth Factors and Their Receptors in Cancer Metastasis
Growth Factors and Their Receptors in Cancer Metastasis

about the involvement of signaling Transforming growth factor in tumor development and metastasis. plays a central role in the signaling network that controls morphogenesis, 2. THE BASICS OF growth and cell differentiation in SIGNALING multicellular organisms. The different members of this pleiotropic family of 2. 1. receptor signaling growth...

Advanced Engineering Mathematics
Advanced Engineering Mathematics

Advanced Engineering Mathematics, 10th Edition is known for its comprehensive coverage, careful and correct mathematics, outstanding exercises, and self-contained subject matter parts for maximum flexibility. The new edition continues with the tradition of providing instructors and students with a comprehensive and up-to-date...

Understanding Intrusion Detection through Visualization (Advances in Information Security)
Understanding Intrusion Detection through Visualization (Advances in Information Security)
With the ever increasing use of computers for critical systems, computer security that protects data and computer systems from intentional, malicious intervention, continues to attract attention. Among the methods for defense, the application of a tool to help the operator identify ongoing or already perpetrated attacks (intrusion detection), has...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy