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

DW 2.0: The Architecture for the Next Generation of Data Warehousing is the first book on the new generation of data warehouse architecture, DW 2.0, by the father of the data warehouse. The book describes the future of data warehousing that is technologically possible today, 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. This allows people who are building or using a data warehouse to see what lies ahead and 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. This book gives experienced data warehouse professionals everything they need in order to implement the new generation DW 2.0. It is designed for professionals in the IT organization, including data architects, DBAs, systems design and development professionals, as well as data warehouse and knowledge management professionals. * 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. CHAPTER 16 Migration -- Houses and cities -- Migration in a perfect world -- The perfect world almost never happens -- Adding components incrementally -- Adding the Archival Sector -- Creating enterprise metadata -- Building the metadata infrastructure -- "Swallowing" source systems -- ETL as a shock absorber -- Migration to the unstructured environment -- From the perspective of the business user -- Summary -- CHAPTER 17 Cost justification and DW 2.0 -- Is DW 2.0 worth it? -- Macro-level justification -- A micro-level cost justification -- Company B has DW 2.0 -- Creating new analysis -- Executing the steps -- So how much does all of this cost? -- Consider company B -- Factoring the cost of DW 2.0 -- Reality of information -- The real economics of DW 2.0 -- The time value of information -- The value of integration -- Historical information -- First-generation DW and DW 2.0-the economics -- From the perspective of the business user -- Summary -- CHAPTER 18 Data quality in DW 2.0 -- The DW 2.0 data quality tool set -- Data profiling tools and the reverse-engineered data model -- Data model types -- Data profiling inconsistencies challenge top-down modeling -- Summary -- CHAPTER 19 DW 2.0 and unstructured data -- DW 2.0 and unstructured data -- Reading text -- Where to do textual analytical processing -- Integrating text -- Simple editing -- Stop words -- Synonym replacement -- Synonym concatenation -- Homographic resolution -- Creating themes -- External glossaries/taxonomies -- Stemming -- Alternate spellings -- Text across languages -- Direct searches -- Indirect searches -- Terminology -- Semistructured data/VALUE = NAME data -- The technology needed to prepare the data -- The relational data base -- Structured/unstructured linkage -- From the perspective of the business user -- Summary -- CHAPTER 20 DW 2.0 and the system of record 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.