DW 2.0: Next Generation of Data Warehousing 2 Day Seminar	Endorsed by DAMA INTERNATIONAL UK Chapter
Dates: 2-3 December 2008 Location: London To Book ONLINE Now, Click Here! Speaker: Bill Inmon, Inmon Consulting Services

"Very clear and crisp. The best ever lecture I have ever been to on data warehousing topic."
Sridhar Somaraju, Enterprise Architect, Barclays Bank

"Thank you for sharing your great experience."
Laurent Cabrit, Manager, Accenture

In the two decades that data warehousing has been around, there has been much change. Older technologies have matured, there is new technology, and organizations have accepted Business Intelligence as a standard part of the infrastructure. Today there are many different renditions of what a data warehouse is – an active data warehouse, a federated data warehouse, a star schema data warehouse and so forth. Unfortunately none of these types of a data warehouse are the same. There is no integrity in the definition of what a data warehouse is. In addition, 1st generation data warehouses have failed to take into account many important requirements that are now recognized as legitimate aspects of data warehousing. Now there is DW 2.0 which is the definition of data warehouse architecture for the future of data warehousing. This two day seminar describes what DW 2.0 is and addresses what data warehousing for the future will look like.

The audience is anyone building a data warehouse or rebuilding a data warehouse after it was not built properly the first time. This audience includes –

• Data Architects
• Systems Managers
• Systems Designers
• Data Warehouse Managers
• Data Analysts
• Data Managers
• Database Administrators
• Data Administrators

• describe what the architecture for the future of data warehousing looks like,
• describe how metadata fits into DW 2.0,
• describe the levels of data of DW 2.0 – interactive, integrated, near line, archival,
• describe how unstructured data can be gathered and integrated into a data warehouse,
• describe the flow of data from outside of DW 2.0, into DW 2.0 and out of DW 2.0,
• understand why data warehouses do not have to cost a huge amount of money, even when they contain a lot of data and have lots of users,
• understand the fundamental transformation of data that takes place as data passes through ETL processing,
• examine the role of new data warehouse technologies such as Talend, Dataupia, SeaTab, Kalido, and others,
• understand the migration path from existing 1st generation data warehouses to DW 2.0,
• understand the issues of data base design in different parts of the DW 2.0 environment,
• understand the issues of building a data warehouse on a fluid foundation that can be changed as business requirements change.

A brief word about the past

An introduction to DW 2.0

• recognizing the life cycle of data within the data warehouse
• including unstructured data in the DW 2.0 environment
• integrating metadata into the DW 2.0 environment
• changing the DW 2.0 technology infrastructure as business requirements change

DW 2.0 architecture

• the interactive sector
• the integrated sector
• the near line sector
• the archival sector
• the flow of data into, out of, and through the DW 2.0 environment

Data warehouse performance

• SLA for the DSS environment
• Homogeneous workload management
• Monitoring the data warehouse

Data marts

Data warehouse exploration facility

The fluid foundation – making sure that changes to business requirements do not hamstring the development and maintenance efforts

ETL and transformation processing

The granularity manager

Data modeling throughout the DW 2.0 environment

• the ERD model
• the dis model
• the physical data model

The metadata infrastructure

• enterprise metadata
• local metadata
• business metadata
• technical metadata

Integrating Unstructured data

• the issue of terminology
• stemming
• stop words
• external taxonomies
• direct, indirect searches
• textual analytics – using SQL for text searches

The near line extension

• data base utilities
• cross media storage management
• the economics of alternate storage

The exploration facility

• when a facility is needed
• what sort of data goes into an exploration facility
• the users of the exploration facility

Archival sector

• passive indexes
• inverted lists
• periodic rewriting
• internally contained metadata
• release independence

The unstructured data base

• integrating unstructured data
• SOM’s and other visualizations
• creating the unstructured data warehouse
• linking the unstructured data warehouse to the structured data warehouse
• applications of unstructured data in an analytical environment
• managing volumes of unstructured data

Methodology throughout the DW 2.0 environment

• the waterfall SDLC
• the spiral development SDLC
• heuristic processing
• just giving the end users their data

• There will be a discussion of the places where other materials can be had relative the DW 2.0. This includes a review of web sites, newsletters, white papers, seminars, certification courses, and so forth. In addition, vendors that are compliant with DW 2.0 will be discussed as well.

Data Management Series

Data Modelling Fundamentals
23-24 September 2008, 16-17 February 2009, London

Data Modelling Masterclass
25-26 September 2008, 18-19 February 2009, London

DW 2.0: Architecture for the Next Generation of Data Warehousing
2-3 December 2008, London

Unstructured Data: Creating the Analytical Environment
4-5 December 2008, London

Master Data Management
15-16 September 2008, London

SERIES DISCOUNTS
Attend more than one course in this series and you will be entitled to the following discounts:

2nd course 10%
3rd Course 15%
4th Course 20%
5th Course 25%

Group Booking Discounts
If 5 delegates from the same organisation register at the same time for the same or various seminars, then the 5th delegate is free. We regret that this offer cannot be used in conjunction with the Series Discount.

£995 + VAT (174.13) = £1169.13

2-3 December 2008
Venue: myhotel Chelsea, 35 Ixworth Place, London, SW3 3QX
Tel: +44 (0)20 7225 7500
Fax: +44 (0)20 7225 7555
Website: http://www.myhotels.com/default.asp?section=10&page=1509

IRM UK in association with JP Events Ltd has arranged special discounted rates at all venues and at other hotels nearby the venue. Please visit the JP Events website for further information.
E-mail: enquiries@jpeventsltd.com Tel +44 (0)20 7428 9911 Fax +44 (0)20 7428 9966.

For an in-house presentation of this or any other IRM UK seminar, please e-mail jeanette.hall@irmuk.co.uk or call +44 (0)20 8866 8366.

© Copyright IRM UK Strategic IT Training, Bishops Walk House, High Street, Pinner HA5 5PJ UK, Tel +44 (0)20 8866 8366, Fax +44 (0)20 8866 7966, enquiries@irmuk.co.uk, www.irmuk.co.uk.