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

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

3.9 14
by W.H. Inmon, Derek Strauss, Genia Neushloss
     
 

View All Available Formats & Editions

ISBN-10: 0123743192

ISBN-13: 9780123743190

Pub. Date: 06/25/2008

Publisher: Elsevier Science

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

Overview

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.

Product Details

ISBN-13:
9780123743190
Publisher:
Elsevier Science
Publication date:
06/25/2008
Edition description:
New Edition
Pages:
400
Product dimensions:
7.40(w) x 9.20(h) x 1.10(d)

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

DW 2.0: The Architecture for the Next Generation of Data Warehousing 3.9 out of 5 based on 0 ratings. 14 reviews.
Anonymous More than 1 year ago
Walks in
Anonymous More than 1 year ago
She stands outside with her hands over her eyes.
Anonymous More than 1 year ago
* hurtles against a wall*
Anonymous More than 1 year ago
At depression res 1 voting is held at res 2 see you there!!!!
Anonymous More than 1 year ago
Huhuhuh
Anonymous More than 1 year ago
Touches a weeping angel
Anonymous More than 1 year ago
((Well, I've never seen Supernaturals, so I'm not sure if I'm legible... but give me a TARDIS and I'm set. :P )) "Mhmmm..." She obliquely surveyed the area. "Pretty deserted."
Anonymous More than 1 year ago
Thanks.
Anonymous More than 1 year ago
Do we already have a gender bent Sherlock or a normal Sherlock? If not can I be a gender bent version prolly named Shirly bc thats closest.
Anonymous More than 1 year ago
Nice idea, Trebs!
Anonymous More than 1 year ago
Has the RP died already? Shame, I liked it alot.
Anonymous More than 1 year ago
((Supernatural is about two brothers named Sam and Dean Winchester. They hunt supernatural things and destory them. Ex: Ghosts, Demons, Shapeshifters, the occasional Angel.))
Anonymous More than 1 year ago
._____. Mhmm. Next result, then?
Dominic_Sagar More than 1 year ago
I was thoroughly disappointed with this book. I was excited to pick up the book and start reading it. From that point on, everything went downhill. As an experienced DW professional, I wanted to learn and understand what was new about DW 2.0. I am afraid to say I am still trying to understand what is new. In the preface, the book claims, "Unlike the term 'data warehouse,' DW 2.0 has a crisp, well-defined meaning. That meaning is identified and defined in this book." Unfortunately, that is not the case; it is full of vague generalities and cobbled together concepts that have been around for years. It seems to want to say, "anything you built in the past was wrong, this is right way." That said, it does not really prescribe anything. As far being the "Architecture for the Next Generation of Data Warehousing," that is the biggest stretch for credibility by far. It does cover a lot of data warehousing concepts, sourcing, staging, integrating, and preparing data for consumption. It does highlight the need to extend data warehouses with unstructured data - this may be as close to a new concept as anything in the book - although if you go back to "Building the Data Warehouse," you find that concept there too. The chapter on unstructured data is a pretty good introduction to the subject. The book does talk to metadata, quality, and security. Beyond that, this book is laughable. The chapters on methodology, cost justification, ETL, migration, and life-cycle management are awful. Any Kimball-istas out there will have apoplexy with regard to how data-marts and star schemas are treated - a section in the Miscellaneous chapter. The components of the book that really frustrated me were the illustrations. They were poorly constructed, illuminated, and documented. Often times they had no meaning whatsoever. They were just little squiggles repeated over and over again. My blood would boil when I was told the green box represented one thing while the red box represented something else. For heaven's sake, these were all black and white illustrations. Did anyone edit this book? All in all, I cannot recommend this book to anyone other than experienced data warehouse professionals with untreated hypotension. I think Inmon has done himself a disservice allowing his name to be associated with a book of this poor quality. It is definitely not up to his usual level of thought or insight.