SIG Meeting April

IRMAC Data Warehousing Special Interest Group in Toronto is sponsoring a FULL DAY SEMINAR. Space is limited, please reserve early!

ADVANCED DATA MODELLING FOR WAREHOUSING

Our speaker will be Diane Vint, Curriculum Manager - Data Warehousing, for Platinum Solutions Inc. Diane is an expert in Data Warehousing theory and as well has many warehousing modelling projects to her credit. She is a scheduled speaker at the DCI Database and Client/Server World Conference which will be in Toronto April 15-17 1997.

OUTLINE OF COURSE:

Introduction to Data Warehouse Modelling

• Getting started
• Operational vs. Informational
• Common Steps
• Scope and Levels of Modeling
• Overview of three tyoes of data models

Denormalization Method - Corporate Data Warehouse

• Usage and Requirements
• Steps to Building a Denormalized data warehouse data model
• Accommodating Various Levels of Summarization
• Case Study

Multi-Dimensional Data Design - Star Schema Method

• Usage and Requirements
• Varieties of Star Schemas : Snowflake and Constellations
• Steps to building a Star Schema data warehouse data model
• Accommodating Various Levels of Summarization
• Case Study

The Operational Data Store (ODS)

• Definition of the Operational Data Store
• Comparison between Operational ODS and Data Warehouse
• Data Modelling for ODS Structures
• Managing and Feeding the ODS

Metadata Synchronization

• What is Metadata
• Classes of Metadata
• Requirements and Usage of Metadata
• Metadata Management
• Interfaces and Components

Data Warehouse Trends and Directions

• Critical Success Factors
• Cost Information and Benefits
• Directions in Data Warehouse Technology
• Summary and Conclusions

TIME AND LOCATION OF THE SEMINAR:

Wednesday April 2 1997 9-4pm

Metro Toronto Central Library, Beeton Room West

The library is at Yonge and Asquith in Toronto, one block north of Bloor St.

For this special seminar we have arranged GREATLY REDUCED FEES!:

IRMAC members $70: Non-members $95 for the full day. Take away materials will only be copies of overhead slides. Please bring your own note paper!

No lunch will be served, but coffee will be made available am and pm breaks.

For more information, please contact:
Deborah Henderson (416) 592-2669
Patrick Sue (416) 449-0738
Diane Vint

REGISTRATION FORM

Name:________________________Title:_____________________________

Company: ___________________________________

Address: ________________________________________________________________

City: ____________________________________ PC: ___________

Phone Number: ____________________________

Please enclose $70 (IRMAC members) or $95 (non-members) as appropriate.

Make Cheques payable to IRMAC.

Mail to:

IRMAC: DW Data Modelling Course
PO Box 5639, Station A, Toronto M5W 1N8.

Revised: February 24, 1997