Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance

Description

This is the first book to provide in-depth coverage of star schema aggregates used in dimensional modeling-from selection and design, to loading and usage, to specific tasks and deliverables for implementation projects
Covers the principles of aggregate schema design and the pros and cons of various types of commercial solutions for navigating and building aggregates
Discusses how to include aggregates in data warehouse development projects that focus on incremental development, iterative builds, and early data loads

From the Back Cover
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/

http://rapidshare.de/files/28903943/Wiley.Mastering.Data.Warehouse.Aggregates.Solutions.for.Star.Schema.Performance.rar.html

Password: ebooksatkoobe

$$ Buy "Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance" on Amazon $$

Please check the description for download links if any or do a search to find alternative books.

Can't Download?
Please search mirrors if you can't find download links for "Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance" in "Description" and someone else may update the links. Check the comments when back to find any updates.

Search Mirrors
Maybe some mirror pages will be helpful, search this book at top of this page or click here to find more info.

1. Ebooks list page : 349
2. Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance
3. Mastering Data Warehouse Aggregates Solutions for Star Schema Performance
4. Mastering.Data.Warehouse.Aggregates.Solutions.for.Star.Schema.Performance
5. Wiley Mastering Data Warehouse Aggregates Solutions for Star Schema Performance
6. Mastering Data Warehouse Aggregates Solutions for Star Schema Performance Jul 2006
7. Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance
8. Mastering Data Warehouse Design: Relational and Dimensional Techniques
9. Common Warehouse Metamodel: An Introduction to the Standard for Data Warehouse Integration
10. Mastering Data Warehouse Design : Relational and Dimensional Techniques
11. Mastering the SAP Business Information Warehouse
12. [request_ebook] The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming & Delivering Data
13. [share_ebook] Mastering the SAP Business Information Warehouse
14. Building the Data Warehouse
15. Building.the.Data.Warehouse
16. The Data Warehouse Lifecycle Toolkit