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

Grammar Practice for Pre-intermediate Students: With Key (GRPR)
Grammar Practice for Pre-intermediate Students: With Key (GRPR)
Grammar Practice for Pre-Intermediate Students gives short, clear explanations
of all the main areas of English grammar, and provides practice exercises for
you to do.

There are two ways in which this book can he used:
(i) in class with help from your teacher;
(ii) at home by yourself.

If you are using the
...
The Law and Economics of Cybersecurity
The Law and Economics of Cybersecurity

Cybersecurity is a leading national problem for which the market may fail to produce a solution because individuals often select less than optimal security levels in a world of positive transaction costs. The problem is compounded because the insecure networks extend far beyond the regulatory jurisdiction of any one nation or even coalition...

Exam Ref 70-417: Upgrading Your Skills to MCSA Windows Server 2012
Exam Ref 70-417: Upgrading Your Skills to MCSA Windows Server 2012

Prepare for Exam 70-417—and help demonstrate your real-world mastery of Windows Server 2012 core infrastructure services. Microsoft Exam 70-417 is an upgrade exam that is a composite of three standalone exams: 70-410, 70-411, and 70-412. Exam 70-417 validates skills related to the core technology features and functionality of...


An Introduction to Buddhism: Teachings, History and Practices (Introduction to Religion)
An Introduction to Buddhism: Teachings, History and Practices (Introduction to Religion)

In this new edition of the best-selling Introduction to Buddhism, Peter Harvey provides a comprehensive introduction to the development of the Buddhist tradition in both Asia and the West. Extensively revised and fully updated, this new edition draws on recent scholarship in the field, exploring the tensions and continuities between the...

Modelling Computing Systems: Mathematics for Computer Science (Undergraduate Topics in Computer Science)
Modelling Computing Systems: Mathematics for Computer Science (Undergraduate Topics in Computer Science)

This engaging text presents the fundamental mathematics and modelling techniques for computing systems in a novel and light-hearted way, which can be easily followed by students at the very beginning of their university education. Key concepts are taught through a large collection of challenging yet fun mathematical games and logical puzzles...

Mathematics for 3D Game Programming and Computer Graphics, Third Edition
Mathematics for 3D Game Programming and Computer Graphics, Third Edition

This updated third edition illustrates the mathematical concepts that a game developer needs to develop 3D computer graphics and game engines at the professional level. It starts at a fairly basic level in areas such as vector geometry and linear algebra, and then progresses to more advanced topics in 3D programming such as illumination and...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy