Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance

3,55 valoración promedio
( 11 valoraciones por Goodreads )
 
9780471777090: Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance

  • 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

"Sinopsis" puede pertenecer a otra edición de este libro.

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/

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. Mr. Adamson also teaches dimensional modeling and is a co-author of Data Warehouse Design Solutions (also from Wiley). He can be contacted through his website, www.ChrisAdamson.net.

"Sobre este título" puede pertenecer a otra edición de este libro.

Comprar nuevo Ver libro

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America

Destinos, gastos y plazos de envío

Añadir al carrito

Los mejores resultados en AbeBooks

1.

Christopher Adamson
Editorial: John Wiley and Sons Ltd, United States (2006)
ISBN 10: 0471777099 ISBN 13: 9780471777090
Nuevos Paperback Primera edición Cantidad: 1
Librería
The Book Depository
(London, Reino Unido)
Valoración
[?]

Descripción John Wiley and Sons Ltd, United States, 2006. Paperback. Estado de conservación: New. 1. Auflage. Language: English . Brand New Book. * 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. Nº de ref. de la librería AAH9780471777090

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 39,04
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Christopher Adamson
Editorial: John Wiley and Sons Ltd
ISBN 10: 0471777099 ISBN 13: 9780471777090
Nuevos Paperback Cantidad: 4
Librería
THE SAINT BOOKSTORE
(Southport, Reino Unido)
Valoración
[?]

Descripción John Wiley and Sons Ltd. Paperback. Estado de conservación: new. BRAND NEW, Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance, Christopher Adamson, * 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. Nº de ref. de la librería B9780471777090

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 32,42
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 7,74
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

3.

Christopher Adamson
Editorial: John Wiley and#38; Sons (2006)
ISBN 10: 0471777099 ISBN 13: 9780471777090
Nuevos Cantidad: 4
Librería
Books2Anywhere
(Fairford, GLOS, Reino Unido)
Valoración
[?]

Descripción John Wiley and#38; Sons, 2006. PAP. Estado de conservación: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Nº de ref. de la librería FW-9780471777090

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 30,83
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 10,04
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Christopher Adamson
Editorial: Wiley (2006)
ISBN 10: 0471777099 ISBN 13: 9780471777090
Nuevos Paperback Cantidad: 1
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración
[?]

Descripción Wiley, 2006. Paperback. Estado de conservación: New. 1. Nº de ref. de la librería DADAX0471777099

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 37,75
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,42
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

Christopher Adamson
Editorial: John Wiley and Sons Ltd, United States (2006)
ISBN 10: 0471777099 ISBN 13: 9780471777090
Nuevos Paperback Primera edición Cantidad: 1
Librería
The Book Depository US
(London, Reino Unido)
Valoración
[?]

Descripción John Wiley and Sons Ltd, United States, 2006. Paperback. Estado de conservación: New. 1. Auflage. Language: English . Brand New Book. * 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. Nº de ref. de la librería AAH9780471777090

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 41,26
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Christopher Adamson
Editorial: Wiley (2006)
ISBN 10: 0471777099 ISBN 13: 9780471777090
Nuevos Paperback Cantidad: 1
Librería
Irish Booksellers
(Rumford, ME, Estados Unidos de America)
Valoración
[?]

Descripción Wiley, 2006. Paperback. Estado de conservación: New. book. Nº de ref. de la librería 0471777099

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 48,32
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

7.

Christopher Adamson
Editorial: John Wiley and Sons
ISBN 10: 0471777099 ISBN 13: 9780471777090
Nuevos Cantidad: > 20
Librería
INDOO
(Avenel, NJ, Estados Unidos de America)
Valoración
[?]

Descripción John Wiley and Sons. Estado de conservación: New. Brand New. Nº de ref. de la librería 0471777099

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 45,44
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,00
A Estados Unidos de America
Destinos, gastos y plazos de envío

8.

Adamson, Christopher
Editorial: Wiley (2006)
ISBN 10: 0471777099 ISBN 13: 9780471777090
Nuevos Paperback Cantidad: 2
Librería
Murray Media
(North Miami Beach, FL, Estados Unidos de America)
Valoración
[?]

Descripción Wiley, 2006. Paperback. Estado de conservación: New. Nº de ref. de la librería P110471777099

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 56,16
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,56
A Estados Unidos de America
Destinos, gastos y plazos de envío

9.

Christopher Adamson
Editorial: John Wiley & Sons Inc (2006)
ISBN 10: 0471777099 ISBN 13: 9780471777090
Nuevos Paperback Cantidad: 2
Librería
Revaluation Books
(Exeter, Reino Unido)
Valoración
[?]

Descripción John Wiley & Sons Inc, 2006. Paperback. Estado de conservación: Brand New. 1st edition. 384 pages. 9.25x7.25x1.00 inches. In Stock. Nº de ref. de la librería __0471777099

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 56,82
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 6,69
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

10.

Christopher Adamson
Editorial: John Wiley and Sons Ltd, United States (2006)
ISBN 10: 0471777099 ISBN 13: 9780471777090
Nuevos Paperback Primera edición Cantidad: 10
Librería
Book Depository hard to find
(London, Reino Unido)
Valoración
[?]

Descripción John Wiley and Sons Ltd, United States, 2006. Paperback. Estado de conservación: New. 1. Auflage. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. * 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. Nº de ref. de la librería BZV9780471777090

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 64,50
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

Existen otras copia(s) de este libro

Ver todos los resultados de su búsqueda