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.)

A Guide to Claims-Based Identity and Access Control (Patterns & Practices)
A Guide to Claims-Based Identity and Access Control (Patterns & Practices)

Claims-based identity means to control the digital experience and to use digital resources based on things that are said by one party about another. A party can be a person, organization, government, Web site, Web service, or even a device. The very simplest example of a claim is something that a party says about itself.

As the...

Adobe Photoshop CS5 for Photographers: A professional image editor's guide to the creative use of Photoshop for the Macintosh and PC
Adobe Photoshop CS5 for Photographers: A professional image editor's guide to the creative use of Photoshop for the Macintosh and PC

When I fi rst started using Photoshop, it was a much simpler program to get to grips with compared with what we see today. Since then Adobe Photoshop CS5 has evolved to supply photographers with all the tools they need. My aim is to provide you with a working photographer’s perspective of what Photoshop CS5 can do and how to...

Advanced Computational Intelligence Paradigms in Healthcare - 1 (Studies in Computational Intelligence)
Advanced Computational Intelligence Paradigms in Healthcare - 1 (Studies in Computational Intelligence)
This book presents some of the most recent research results on the applications of computational intelligence in healthcare. The contents include: Information model for management of clinical content; State-based model for management of type II diabetes; Case-based reasoning in medicine; Assessing the quality of care in artificial intelligence...

Architecture of Reliable Web Applications Software
Architecture of Reliable Web Applications Software
This book is concerned with the issues and matters that relate to the reliability, availability, manageability, performance, scalability, and secured-ability of applications, particularly the ones that run over the Web. The importance of studying and exploring such issues is obvious.

Shortly after joining IBM Canada in 1997, I was
...
Executive Coaching : A Guide for the HR Professional
Executive Coaching : A Guide for the HR Professional
The purpose of this book is to help human resource professionals
and their clients become more savvy consumers of coaching services.
With the wide array of coaching services now available in the
marketplace, HR professionals need information to allow them to
sort through options, ask discerning questions, and understand what...
The Adobe Illustrator CS Wow! Book
The Adobe Illustrator CS Wow! Book
One of the first things you might notice about the newest
version of Adobe Illustrator is that numbers are out, and
letters are in. Instead of the predictable "Illustrator 11,"
this release has been given the name "Illustrator CS." The
CS stands for Creative Suite, and in fact it is a pretty suite
deal
...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy