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

Mobile 3D Graphics: with OpenGL ES and M3G (The Morgan Kaufmann Series in Computer Graphics)
Mobile 3D Graphics: with OpenGL ES and M3G (The Morgan Kaufmann Series in Computer Graphics)
Graphics and game developers must learn to program for mobility. This book will teach you how.

"This book - written by some of the key technical experts...provides a comprehensive but practical and easily understood introduction for any software engineer seeking to delight the consumer with rich 3D interactive experiences on their
...
Design by Nature: Using Universal Forms and Principles in Design (Voices That Matter)
Design by Nature: Using Universal Forms and Principles in Design (Voices That Matter)

In Design by Nature: Using Universal Forms and Principles in Design, author Maggie Macnab takes you on an intimate and eclectic journey examining the unending versatility of nature, showing how to uncover nature’s ingenuity and use it to create beautiful and compelling designed communications.

...

Aligning Business Strategies and Analytics: Bridging Between Theory and Practice (Advances in Analytics and Data Science, 1)
Aligning Business Strategies and Analytics: Bridging Between Theory and Practice (Advances in Analytics and Data Science, 1)
This book examines issues related to the alignment of business strategies and analytics. Vast amounts of data are being generated, collected, stored, processed, analyzed, distributed and used at an ever-increasing rate by organizations. Simultaneously, managers must rapidly and thoroughly understand the factors driving their business....

Microsoft Office Home & Student 2010 Step by Step
Microsoft Office Home & Student 2010 Step by Step

Teach yourself exactly what you need to know about using Microsoft Word, Excel®, PowerPoint®, and OneNote®-one step at a time! With STEP BY STEP, you build and practice new skills hands-on, at your own pace. Topics include creating effective documents; using themes, templates, and other formatting tools; building...

Chromatin and Disease (Subcellular Biochemistry)
Chromatin and Disease (Subcellular Biochemistry)

This book includes a collection of articles with the broad theme of disease connection to chromatin structure and function. It elaborates on the molecular pharmacology of the drugs targeting chromatin structure and its components. The book contains up-to-date information about the chromatin structure and chromatin related diseases and drug...

Quotient Space Based Problem Solving: A Theoretical Foundation of Granular Computing
Quotient Space Based Problem Solving: A Theoretical Foundation of Granular Computing
The term problem solving is used in many disciplines, sometimes with different perspectives. As one of the important topics in artificial intelligence (AI) research, it is a computerized process of human problem-solving behaviors. So the aim of problem solving is to develop techniques that program computers to find solutions...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy