The Data Warehouse Lifecycle Toolkit

By Ralph KimballMargy RossWarren Thornthwaite, et al.

Book Overview

"A comprehensive, thoughtful, and detailed book that will be of inestimable value to anyone struggling with the complex details of designing, building, and maintaining an enterprise-wide decision support system. Highly recommended." -Robert S. Craig, Vice President, Application Architectures, Hurwitz Group, Inc. In his bestselling book, The Data Warehouse Toolkit, Ralph Kimball showed you how to use dimensional modeling to design effective and usable data warehouses. Now, he carries these techniques to the larger issues of delivering complete data marts and data warehouses. Drawing upon their experiences with numerous data warehouse implementations, he and his coauthors show you all the practical details involved in planning, designing, developing, deploying, and growing data warehouses. Important topics include: * The Business Dimensional Lifecycle(TM) approach to data warehouse project planning and management * Techniques for gathering requirements more effectively and efficiently * Advanced dimensional modeling techniques to capture the most complex business rules * The Data Warehouse Bus Architecture and other approaches for integrating data marts into super-flexible data warehouses * A framework for creating your technical architecture * Techniques for minimizing the risks involved with data staging * Aggregations and other effective ways to boost data warehouse performance * Cutting-edge, Internet-based data warehouse security techniques The CD-ROM supplies you with: * Complete data warehouse project plan tasks and responsibilities * A set of sample models that demonstrate the Bus Architecture * Blank versions of the templates and tools described in the book * Checklists to use at key points in the project

• Format: Paperback
• Language: English
• ISBN: 0471255475
• ISBN13: 9780471255475
• Release Date: August 1998
• Publisher: Wiley
• Length: 800 Pages
• Weight: 3.15 lbs.
• Dimensions: 1.7" x 7.4" x 9.2"

Customer Reviews

Fantastic, the best I've seen on the subject

This book is terrific. I've been involved in implementing a data warehouse, and I wish I'd had this book then, as the author proposes solutions to several problems we encountered, but had less elegant, or no, solutions for. I have read a number of books on data warehousing, and a major portion of every one of them is devoted to the politics of getting management to adopt, and then support, building a data warehouse, and very little on the concrete aspects involved. This book is almost entirely on the nuts and bolts of actual doing the implementation, assuming it is already supported by management. Presents how to do dimensional (star schema) models from elementary to highly advanced. Every important aspect of implementing a data warehouse is covered with real content at all points. Wonderful resource book for the experienced warehouse person, while also extremely helpful the the novice, and anyone in between. Read this book first, then peruse any others in the book store before buying--you may not need a second book.

Finally, an intelligent development book rooted in reality

After 21 years in software development, which includes managing three data warehouse projects, I had decided to write a book trying to capture whatever wisdom I had accumulated. After reading this book I no longer feel the need to. This book not only provides detailed techniques for building a data warehouse and managing the process, it also deals with the realities faced in these projects. If you've ever been frustrated with those abstract tomes written by strict methodologists while you were burdened with a tight budget, a dysfunctional company (is that redundant?), immature technology, underskilled technologists and waffling user support -- then this is the book for you. It is filled with recommendations for conducting every phase of the project, yet is always careful to acknowledge that no two projects are alike and there is no one guaranteed blueprint for managing the project. My only regret is that this book wasn't available before my first data warehouse projects. Although our teams ended up at many of the same conclusions, it was only after a lot of hard thought, insecurity, and trial and error.If you are going to develop a data warehouse or a data mart, read this book first.

This is clearly the BEST Data Warehouse book I've read!!

Our organization has implemented a very successful Data Warehouse, due largely to following the design and deployment principles from Dr. Kimball's two textbooks. The key to a successful Data Warehouse is providing all business users an easy to use and high performance queryable system. The dimensional design is, without a doubt, the defacto standard for Queryable Data Warehouses, and the author does a superb job motivating its use and explaining how to develop your integrated, dimensional data warehouse. In addition, the author gives valuable advice on many, many other aspects of the process, such as assessing your readiness for proceeding with a warehouse effort. This book is a "must read" for anyone involved in a Data Warehouse project. You will have an excellent chance of succeeding with even a most complicated Data Warehouse System if you follow the wisdom in this book.

This book makes building a Data Warehouse Possible!

We were at a lose on how to proceed with putting together an historical database that would track 10,000 discrete survey items from over 800 surveys per year, including survey indications, and official estimates. The real problem was doing it such a way as to make it easy to use, understandable, and accessible to all of our data analysts. We read Inmon's book and decided it would be too complicated and slow if we used his approach. Besides, we wanted true ad-hoc capabilities, and did not want to be hampered by a system that had too little data, or was being controled by someone trying to save nickles on DASD by spending dollars of our time. Kimball's book gave us what we were looking for: a way to build a data warehouse incrementally, using and tracking the lowest level of granularity in our data, and offering simplicity and service without an army of IT consultants. His engineering approach to dimensional modeling, particularly his notion of conforming dimensions puts the traditionalists, like Inmon, out to pasture.

Number-one in Data Warehousing Literature

Ralph and his colleagues wrote a wonderful book about Data Warehousing. Ralph's objective is to make user happy. He want's to build intuitive and user-friendly Data Warehouses with a good performance and in this book he tells us how to succeed. He guides you through the Data Warehouse process form initialize interviews to design staging area and dimension models and lots more. I found this book to be the perfect answer to bringing myself up to speed. Not too technical -- but enough information to answer all the important questions which can occur in a Data Warehouse project Easy reading as well for people who native language is not english. Just read it and lets make users happy.By the why: I would like to recommend this book to NCR's Rob Armstrong.