Data Warehousing: Architecture and Implementation (Paperback)

~ Mark W. Humphries (Author), Michael W. Hawkins (Author), Michelle C. Dy (Author)

Editorial Reviews

Product Description

Presents a thorough overview of today's best solutions, & a reliable step-by-step process for building warehouses that meet their objectives. CD-ROM included.

From the Inside Flap

Preface
This book is intended for Information Technology (IT) professionals who have been hearing about or have been tasked to evaluate, learn or implement data warehousing technologies. Far from being just a passing fad, data warehousing technology has grown much in scale and reputation in the past few years, as evidenced by the increasing number of products, vendors, organizations, and yes, even books, devoted to the subject. Enterprises that have successfully implemented data warehouses find it strategic and often wonder how they ever managed to survive without it in the past. As early as 1995, a Gartner Group survey of Fortune 500 IT managers found that 90 percent of all organizations had planned to implement data warehouses by 1998. Virtually all Top-100 US banks will actively use a data warehouse-based profitability application by 1998. Nearly 30 percent of companies that actively pursue this technology have created a permanent or semipermanent unit to plan, create, maintain, promote, and support the data warehouse. If you are an IT professional who has been tasked with planning, managing, designing, implementing, supporting, or maintaining your organization's data warehouse, then this book is intended for you. The first section introduces the Enterprise Architecture and Data Warehouse concepts, the basis of the reasons for writing this book. The second section of this book focuses on three of the key People in any data warehousing initiative: the Project Sponsor, the CIO, and the Project Manager. This section is devoted to addressing the primary concerns of these individuals. The third section presents a Process for planning and implementing a data warehouse and provides guidelines that will prove extremely helpful for both first-time and experienced warehouse developers. The fourth section of this book focuses on the Technology aspect of data warehousing. It lends order to the dizzying array of technology components that you may use to build your data warehouse. The fifth section of this book opens a window to the future of data warehousing. This book also comes with a CD-ROM that contains two software products. Please refer to the readme.txt file on the CD-ROM for any last minute changes and updates. The enclosed software products are: R/olapXL -- R/olapXL is a powerful query and reporting tool that allows users to draw data directly into Microsoft Excel spreadsheets from any dimensional data mart or data warehouse that resides on an ODBC-compliant database. Once the data are in Microsoft Excel, you are free to use any of Excel's standard features to analyze, report, or graph the retrieved data. Warehouse Designer -- Warehouse Designer is a tool that generates DDL statements for creating dimensional data warehouse or data mart tables. Users specify the required data structure through a GUI front-end. The tool generates statements to create primary keys, foreign keys, indexes, constraints, and table structures. It recognizes key dimensional modeling concepts such as fact and dimension tables, core and custom schemas, as well as base and aggregate schemas. Also enclosed is a License Agreement that you must read and agree to before using any of the software provided on the disk. Manuals for both products are included as appendices in this book. The latest information on these products is available at the website of Intranet Business Systems, Inc. The URL is intranetsys.

See all Editorial Reviews

Product Details

• Paperback: 360 pages
• Publisher: Prentice Hall PTR (January 9, 1999)
• Language: English
• ISBN-10: 0130809020
• ISBN-13: 978-0130809025
• Product Dimensions: 8.9 x 7.3 x 0.9 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.8 out of 5 stars  See all reviews (5 customer reviews)
• Amazon.com Sales Rank: #794,053 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

12 of 12 people found the following review helpful:

4.0 out of 5 stars Solid Overview Reference for Project Managers & Analysts, October 31, 2000

By	R. Louis Wan (Chicago, Illinois - USA) - See all my reviews

Dispite the 300+ pages, I was able to finish this book in a day. It provides clear and concise information on how to manage a data warehousing project, caveats & pitfalls, and differences between DW technologies & strategies. The first half of the book focuses on step-by-step DW project management and methodology. The second half focuses on technologies and concepts. However, I felt that the second half of the book was not as strong as the first (probably because technology changes constantly). If you want a book that gives you a step-by-step task list that can be easily transferred to a MS Project plan, then this is the book you want!

5 of 5 people found the following review helpful:

5.0 out of 5 stars Good coverages of basics - for managers and non DBAs, March 22, 2001

By	Mike Tarrani "www.tarrani.com" (Deltona, FL USA) - See all my reviews (TOP 500 REVIEWER)    (REAL NAME)    (COMMUNITY FORUM 04)

Data Warehousing covers a lot of territory, but does not go into depth. If you know this in advance it sets your expectations that this book is more of an educational tool for managers than a "how-to" for data architects and DBAs. I recommend The Data Warehouse Lifecycle Toolkit by Ralph Kimball for those who are seeking an in-depth technical treatment of the subject.

This book will give you a solid foundation of the basics, expose the issues and provide a high-level process for planning and implementing a data warehouse. It is divided into sections, the first three covering people, process and technology.

Section One starts with an overview enterprise IT architectures, how data warehousing fits into the scheme of things, and associated business and technical perspectives. I like the way the authors emphasize business perspectives, which is a consistent thread throughout the book. They use a framework called "InfoMotion", which covers all of the requirements, but (to me) is too wrapped-up in "consultant-speak". For example, they litter this section with nonsense such as "InfoMotion = Information/Data * motion. While it makes perfect sense from a conceptual viewpoint, there is no way to compute it, so why express it as a formula? Parenthetically, data is easy to quantify; measuring information is difficult, but can be done. The motion part of the equation is plain silliness because there is no basis given for measurement. But I am nitpicking here.

You are next introduced to data warehouse concepts. This gives a foundation that is complete and covers all key elements, such as reports, definitions of data warehouse and data mart and operational data stores. I thought this was an excellent introduction. Also included is a brief piece on cost/benefit and return on investment. It was short and hit all of the key points, but would have fit better in the prior discussion of the business perspective.

The next section addresses the people part of a data warehousing project, begining with the project sponsor. Answers to some incisive questions are given in this part, such as "how will the data warehouse affect decision-making processes?", "how will it improve financial, marketing and operations processes?" and similar business-focused questions. These draw your attention to the real reasons for data warehousing. This section moves naturally into project management considerations, and exposes some common problems like defining project scope, underestimating time and project overhead or factoring the operational support issues after the data warehouse is rolled out and in production. One of the best parts of this section is how the authors counter common problems and risks with advice on how to eliminate or mitigate them. I liked the approach to measuring results, which gives some sound key performance indications that you can use to baseline some total cost of ownership drivers after the data warehouse is in production. This section continues with roles and responsibilities of the project team. The authors have crafted a sound team structure that consists of business and technical representatives who are overseen by a steering committee. This is an excellent approach. I thought the inclusion of users from various business domains was one of the key strengths, because these people know the data's value to the business a lot better than the technical side of the team. On the other hand, I thought it was naive of the authors to state that this group would be required 80% of the time during the project. While I fully agree with this estimate, it is nearly impossible in practice. I wish the authors would have shared how they sold the business side on making an 80% commitment of their best and brightest.

As this section moves into the actual project there are some things I loved about their approach: breaking the project into four parallel tracks and the proposed rollout strategy. These give you a good understanding of the scope and magnitude of a typical data warehouse project.

Section 4 covers technology, and gets a little too technical for a business user in some places, but is just right for an IT manager who is not a DBA or data architect. I liked the discussion of metadata, why normalization is not appropriate for data warehousing, and the treatment of fact and dimension tables.

The final section discusses maintenance requirements once the data warehouse is in production. This prepares you for the realities of managing these systems. I wish the authors would have addressed some of the workload and scheduling issues that are a part of the territory - refreshing the warehouse is going to require a fine balancing act that is going to affect maintenance windows, other production jobs and a plethora of other production headaches if not planned for in advance.

Overall this is a good book for the audience I cited above. I strongly recommend anyone considering a data warehouse to also read Improving Data Warehouse and Business Information Quality by Larry P. English.

6 of 8 people found the following review helpful:

5.0 out of 5 stars Its a must for project managers, October 22, 1999

By A Customer

Excellent book that explains all the steps necessary to implement successful warehouse project. It approaches it from organizational point of view as oppossed to technical. It will complement many technical warehousing books out there.