DW 2.0: The Architecture for the Next Generation of Data Warehousing

  • 5h 5m
  • Derek Strauss, Genia Neushloss, William H. Inmon
  • Elsevier Science and Technology Books, Inc.
  • 2008

Data Warehousing has been around for 20 years and has become part of the information technology infrastructure. Data warehousing originally grew in response to the corporate need for information—not data—and it supplies integrated, granular, and historical data to the corporation.

There are many kinds of data warehouses, in large part due to evolution and different paths of software and hardware vendors. But DW 2.0, defined by this author in many talks, articles, and his b-eye-network newsletter that reaches 65,000 professionals monthly, is the well-identified and defined next generation data warehouse.

The book carries that theme and describes the future of data warehousing that is technologically possible now, at both an architectural level and technology level. The perspective of the book is from the top down: looking at the overall architecture and then delving into the issues underlying the components. The benefit of this for people who are building or using a data warehouse can see what lies ahead, and can determine: what new technology to buy, how to plan extensions to the data warehouse, what can be salvaged from the current system, and how to justify the expense—at the most practical level.

All of this gives the experienced data warehouse professional everything and exactly what is needed in order to implement the new generation DW 2.0.

  • First book on the new generation of data warehouse architecture, DW 2.0.
  • Written by the "father of the data warehouse", Bill Inmon, a columnist and newsletter editor of The Bill Inmon Channel on the Business Intelligence Network.
  • Long overdue comprehensive coverage of the implementation of technology and tools that enable the new generation of the DW: metadata, temporal data, ETL, unstructured data, and data quality control.

About the Authors

W. H. Inmon, the father of data warehousing, has written 49 books translated into nine languages. Bill founded and took public the world's first ETL software company. He has written over 1000 articles and published in most major trade journals.

Bill has conducted seminars and spoken at conferences on every continent except Antarctica. He holds nine software patents. His latest company is Forest Rim Technology, a company dedicated to the access and integration of unstructured data into the structured world. Bill's web site—inmoncif.com—attracts over 1,000,000 visitors a month. His weekly newsletter at b-eye-network.com is one of the most widely read in the industry and goes out to 75,000 subscribers each week.

Derek Strauss is founder, CEO, and a principal consultant of Gavroshe. He has 28 years of IT industry experience, 22 years of which were in the information resource management and business intelligence/data warehousing fields.

Derek has initiated and managed numerous enterprise programs and initiatives in the areas of business intelligence, data warehousing, and data quality improvement. Bill Inmon's Corporate Information Factory and John Zachman's Enterprise Architecture Framework have been the foundational cornerstones of his work. Derek is also a Specialist Workshop Facilitator. He has spoken at several local and international conferences on data warehousing issues. He is a Certified DW 2.0 Architect and Trainer.

Genia Neushloss is a co-founder and principal consultant of Gavroshe. She has a strong managerial and technical background spanning over 30 years of professional experience in the insurance, finance, manufacturing, mining, and telecommunications industries.

Genia has developed and conducted training courses in JAD/JRP facilitation and systems reengineering. She is a codeveloper of a method set for systems reengineering. She has 22 years of specialization in planning, analyzing, designing, and building data warehouses. Genia has presented before audiences in Europe, the United States, and Africa. She is a Certified DW 2.0 Architect and Trainer.

In this Book

  • A Brief History of Data Warehousing and First-Generation Data Warehouses
  • An Introduction to DW 2.0
  • DW 2.0 Components—About the Different Sectors
  • Metadata in DW 2.0
  • Fluidity of the DW 2.0 Technology Infrastructure
  • Methodology and Approach for DW 2.0
  • Statistical Processing and DW 2.0
  • Data Models and DW 2.0
  • Monitoring the DW 2.0 Environment
  • DW 2.0 and Security
  • Time-Variant Data
  • The Flow of Data in DW 2.0
  • ETL Processing and DW 2.0
  • DW 2.0 and the Granularity Manager
  • DW 2.0 and Performance
  • Migration
  • Cost Justification and DW 2.0
  • Data Quality in DW 2.0
  • DW 2.0 and Unstructured Data
  • DW 2.0 and the System of Record
  • Miscellaneous Topics
  • Processing in the DW 2.0 Environment
  • Administering the DW 2.0 Environment