Synopses & Reviews
Everything you need to know to design, develop, and build your data warehouse
The data warehouse solves the problem of getting information out of legacy systems quickly and efficiently. If designed and built right, data warehouses can provide significant freedom of access to data, thereby delivering enormous benefits to any organization. In this unique handbook, W. H. Inmon, "the father of the data warehouse," provides detailed discussion and analysis of all major issues related to the design and construction of the data ware-house, including granularity of data, partitioning data, metadata, lack of creditability of decision support systems (DSS) data, the system of record, migration, and more.
This Second Edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking. It includes a useful review checklist to help evaluate the effectiveness of the design and explains
* How to design and build a data warehouse-including step-by-step guidelines
* Migration to the data warehouse from existing architectures
* Techniques for using the data warehouse to provide companies with a powerful competitive edge
* How to monitor the data warehouse
* The role of the data warehouse in reengineering
* How to get the most from both star joins and data models
* How data marts and OLAP fit with data warehousing techniques
* And much more
Find out what a data warehouse can do for your company and how to build one tailored to your organization's needs in Building the Data Warehouse, Second Edition.
Review
"W.H. Inmon, the father of the data warehouse, provides detailed discussion and analysis of all major issues related to the design and construction of the date warehouse...the second edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking." (Fatbrain.com; Ganthead.com, 9/01)
Review
"...a clear and well thought out textI would recommend it to anyone working in data management or considering setting up a data warehouse..." (Managing Information, 9 October 2002)
"overall, this is a clear and well thought out text. I would recommend this to anyone working in data management or considering setting up a data warehouse" (Managing Information, December 2002)
Synopsis
Learn the most recent advances in data warehousing technology from the "Father of Data Warehousing"
Since it was first published in 1990, W. H. Inmon's Building the Data Warehouse has become the bible of data warehousing-- the first and best introduction to the subject. A lot has changed in data warehousing technology since the last edition appeared in 1996, and this latest volume is completely revised to reflect exciting new techniques and applications, update existing topics, and examine data marts, operational data stores, and the corporate
information factory.
In this Third Edition, Inmon explains what a data warehouse is (and isn't), why it's needed, how it works, and how the traditional data warehouse can be integrated with new technologies, including the Web, to provide enhanced customer service and support. He also addresses the trade-offs between normalized data warehouses and dimensional data marts.
In addition, this unique overview of data warehousing reviews new subjects such as:
* Data warehousing techniques for customer sales and support, both online and offline
* Data warehousing for decision support, including data mining and exploration warehousing
* Adoption of near-line storage techniques to vastly increase the capacity and access speed of data warehouses
* Integration of data warehouses with ERP systems
* The unique requirements for supporting e-businesses, including the capturing and analysis of clickstream data
Description
Includes bibliographical references (p. 381-391) and index.
Table of Contents
Evolution of Decision Support Systems.
The Data Warehouse Environment.
The Data Warehouse and Design.
Granularity in the Data Warehouse.
The Data Warehouse and Technology.
The Distributed Data Warehouse.
Executive Information Systems and the Data Warehouse.
External/Unstructured Data and the Data Warehouse.
Migration to the Architected Environment.
A Data Warehouse Design Review Checklist.
Appendix.
Glossary.
References.
Index.