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

Best known as the “Father of Data Warehousing," Bill Inmon has become the most prolific and well-known author worldwide in the big data analysis, data warehousing and business intelligence arena. In addition to authoring more than 50 books and 650 articles, Bill has been a monthly columnist with the Business Intelligence Network, EIM Institute and Data Management Review. In 2007, Bill was named by Computerworld as one of the “Ten IT People Who Mattered in the Last 40 Years” of the computer profession. Having 35 years of experience in database technology and data warehouse design, he is known globally for his seminars on developing data warehouses and information architectures. Bill has been a keynote speaker in demand for numerous computing associations, industry conferences and trade shows. Bill Inmon also has an extensive entrepreneurial background: He founded Pine Cone Systems, later named Ambeo in 1995, and founded, and took public, Prism Solutions in 1991. Bill consults with a large number of Fortune 1000 clients, and leading IT executives on Data Warehousing, Business Intelligence, and Database Management, offering data warehouse design and database management services, as well as producing methodologies and technologies that advance the enterprise architectures of large and small organizations world-wide. He has worked for American Management Systems and Coopers & Lybrand. Bill received his Bachelor of Science degree in Mathematics from Yale University, and his Master of Science degree in Computer Science from New Mexico State University.

• 1. A brief history of data warehousing; 1st generation of data warehouses2. DW 2.0 – an overview; the components3. DW 2.0 components - the interactive sector - the integrated sector - the near line sector - the archival sector4. The metadata infrastructure; enterprise metadata; business metadata; technical metadata5. Creating the fluid technological infrastructure for DW 2.0 - the underlying technology approach - the separation of static and temporal data6. Methodology - the waterfall approach for operational – like components - the iterative approach for the DSS environment7. Statistical and exploration processing - the exploration warehouse - sources of data for the exploration warehouse - heuristic processing8. Data modeling for the DW 2.0 environment9. Monitoring the DW 2.0 environment10. Security in the DW 2.0 environment11. Time variant data – data structure representation12. Connectivity – how the different parts of the DW 2.0 environment connect13. ETL – the role of ETL and the existence of seemingly redundant data14. The granularity manager15. Performance across the architecture16. Migration from 1st generation data warehouses to DW 2.017. Cost justification of DSS processing in DW 2.018. Data quality in DW 2.019. Conditioning unstructured data for entry into the DW 2.0 environment20. DW 2.0 and the System of Record21. Miscellaneous Topics22. Processing in the DW 2.0 Environment23. Administering the DW 2.0 Environment