Current Public Seminars
"Interesting speaker with the ability to relate to real-world situations and examples."
Andy Rigby, Business Analyst, ATS Euromaster
"Great stories and vast experience help explain what DW 2.0 can do for you."
Jason Perkins, Principal BI Architect, British Telecom
"Excellent speaker, clear communication with audience. The structure of the seminar was well designed."
Istvan Czako, Data Warehouse Developer, BWIN
"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
2-Day Seminar
DW 2.0: Next Generation of Data Warehousing
- Overview
- Learning Objectives
- Seminar Outline
- Audience
- Speaker Biography
- Testimonials
- Seminar Fee
- Group Booking and Series Discounts
- Hotel Venue and Accomodations
Overview
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.
- 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
Audience
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
Special Features
- 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.
|
Bill Inmon, Inmon Consulting Services, - known as the Father of Data Warehouse and one of the 10 IT People Who Mattered in The Last 40 Years - has written 50 books and over 1000 articles. His books have been translated into 9 languages. Bill’s weekly newsletter with b-eye-network is read by over 55,000 recipients. |
In-House Training
If you require a quote for running
this course in-house, please contact us with the following details:
- Subject matter and/or speaker required
- Estimated number of delegates
- Location (town, country)
- Number of days required (if different from the public course)
- Preferred date
Please contact:
Jeanette Hall
E-mail: jeanette.hall@irmuk.co.uk
Telephone: +44 (0)20 8866 8366
Fax: +44 (0)1923 828 770
Speaker: Bill Inmon
Inmon Consulting
Services
Endorsed by:
DAMA International
UK Chapter
Media Sponsor
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.
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%
Data Management Series
DW 2.0: Next Generation of Data Warehousing
29-30 April 2010, London
Data Modelling Fundamentals
15-16 February 2010, London
20-21 September 2010, London
Data Modelling Masterclass
17-18 February 2010, London
22-23 September 2010, London
Information Quality Improvement
12-14 April 2010, London