The Data Warehouse Lifecycle Toolkit / Edition 2

by Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker

Overview

A thorough update to the industry standard for designing, developing, and deploying data warehouse and business intelligence systems

The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. In that time, the data warehouse industry has reached full maturity and acceptance, hardware and software have made staggering advances, and the techniques promoted in the premiere edition of this book have been adopted by nearly all data warehouse vendors and practitioners. In addition, the term "business intelligence" emerged to reflect the mission of the data warehouse: wrangling the data out of source systems, cleaning it, and delivering it to add value to the business.

Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. The authors understand first-hand that a data warehousing/business intelligence (DW/BI) system needs to change as fast as its surrounding organization evolves. To that end, they walk you through the detailed steps of designing, developing, and deploying a DW/BI system. You'll learn to create adaptable systems that deliver data and analyses to business users so they can make better business decisions.

Product Details

ISBN-13:	9780470149775
Publisher:	Wiley
Publication date:	01/10/2008
Edition description:	New Edition
Pages:	672
Product dimensions:	7.50(w) x 9.30(h) x 1.50(d)

About the Author

Ralph Kimball, PhD, is the Founder of the Kimball Group and has been a leading visionary in the data warehouse industry since 1982.

Read an Excerpt

Click to read or download

Table of Contents

Chapter 1 Introducing the Kimball Lifecycle 1

Chapter 2 Launching and Managing the Project/Program 15

Chapter 3 Collecting the Requirements 63

Chapter 4 Introducing the Technical Architecture 109

Chapter 5 Creating the Architecture Plan and Selecting Products 179

Chapter 6 Introducing Dimensional Modeling 233

Chapter 7 Designing the Dimensional Model 287

Chapter 8 Designing the Physical Database and Planning for Performance 327

Chapter 9 Introducing Extract, Transformation, and Load 369

Chapter 10 Designing and Developing the ETL System 425

Chapter 11 Introducing Business Intelligence Applications 473

Chapter 12 Designing and Developing Business Intelligence Applications 505

Chapter 13 Deploying and Supporting the DW/BI System 541

Chapter 14 Expanding the DW/BI System 579 

Editorial Reviews

(...)
Das Buch richtet sich primdr an Designer und Informations-Manager im Umfeld von Data-Warehouse-Anwendungen. Diese Zielgruppe erhdlt Ratschldge und Handlungsanleitungen, um deren Anforderungen optimal zu bewdltigen. Dabei ist der ganzheitliche Ansatz zu betonen, der eine evolutiondre Weiterentwicklung besser als singuldre Schnellsch]sse unterst]tzen kann. auch der zugrundeliegende Architekturcharakter trdgt zur Festigung dieser Intension bei. Zu knapp werden die Themen Data Mining und Parallelverarbeitung angesprochen; ebenfalls fehlen zur Vertiefung weiterf]hrende Literaturhinweise. Insbesondere SMP und MPP bieten f]r die praktische Realisierung wichtige Unterst]tzungshilfen. Wobei zur Verbesserung der Performance die Fdhigkeit einiger DBMS Abfragen zu optimieren und parallel zu verarbeiten n]tzlich ist.
IT-Director 10/2000

From the Publisher