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

1st Edition

Authors: W.H. Inmon Derek Strauss Genia Neushloss
Paperback ISBN: 9780123743190
eBook ISBN: 9780080558332
Imprint: Morgan Kaufmann
Published Date: 25th June 2008
Page Count: 400
Tax/VAT will be calculated at check-out
Compatible Not compatible
VitalSource PC, Mac, iPhone & iPad Amazon Kindle eReader
ePub & PDF Apple & PC desktop. Mobile devices (Apple & Android) Amazon Kindle eReader
Mobi Amazon Kindle eReader Anything else

Institutional Access


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.

Key Features

  • 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.


Professionals in the IT organization, including data architects, DBAs, systems design and development professionals, as well as data warehouse and knowledge management professionals.

Table of Contents

  1. A brief history of data warehousing; 1st generation of data warehouses
  2. DW 2.0 – an overview; the components
  3. DW 2.0 components
    • the interactive sector
    • the integrated sector
    • the near line sector
    • the archival sector
  4. The metadata infrastructure; enterprise metadata; business metadata; technical metadata
  5. Creating the fluid technological infrastructure for DW 2.0
    • the underlying technology approach
    • the separation of static and temporal data
  6. Methodology
    • the waterfall approach for operational – like components
    • the iterative approach for the DSS environment
  7. Statistical and exploration processing
    • the exploration warehouse
    • sources of data for the exploration warehouse
    • heuristic processing
  8. Data modeling for the DW 2.0 environment
  9. Monitoring the DW 2.0 environment
  10. Security in the DW 2.0 environment
  11. Time variant data – data structure representation
  12. Connectivity – how the different parts of the DW 2.0 environment connect
  13. ETL – the role of ETL and the existence of seemingly redundant data
  14. The granularity manager
  15. Performance across the architecture
  16. Migration from 1st generation data warehouses to DW 2.0
  17. Cost justification of DSS processing in DW 2.0
  18. Data quality in DW 2.0
  19. Conditioning unstructured data for entry into the DW 2.0 environment
  20. DW 2.0 and the System of Record
  21. Miscellaneous Topics
  22. Processing in the DW 2.0 Environment
  23. Administering the DW 2.0 Environment


No. of pages:
© Morgan Kaufmann 2008
Morgan Kaufmann
eBook ISBN:
Paperback ISBN:

About the Author

W.H. Inmon

Affiliations and Expertise

Inmon Data Systems, Castle Rock, CO, USA

Derek Strauss

Affiliations and Expertise

CEO and Founder, Gavroshe

Genia Neushloss

Affiliations and Expertise

Co-founder, Gavroshe