Data Warehousing - Course Material

"Data Warehousing", WS 07/08

NEWS: [Oct 9, 2007]: The Peerweb has been opened for the DAWA groups. Deadline: Wednsday, October 17.

>> Results from examination of Feb 1,2008 >> Module Description >> List of project groups >> List of Windows Servers >> MS Word template for Weekly Reports >> Test Examination >> Test Examination - Solutions >> Examination - Results >> Lab Work & Report - Results

Unit 1 2 3 4 5 6 7

Slides Intro Architecture Design 1
DFM [Bauer/Günzel] Design 2 ETL OLAP
Data Mining

Reading ^* Chap. 1 & 2 Chap. 7 & 9 Chap. 10 Chap. 11 Chap. 12 & 13 Chap. 15 Chap. 17

Additional Reading DFM paper (read page 6 !) starER paper DM Intro

Submission Deadlines of Assignments Assignments 1 and 2 Assignments 3 and 4 Assignments 5 and 6 Assignment 7 Assignment 8, Steps 1 & 2 Assignment 8, Steps 3 & 4

Assignments: 1, 2, 3, 4, 5, 6, 7, 8, (ctc_data.zip)
^* Reading: [Ponniah, Paulraj]: Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals, Wiley, 2001. ISBN: 0-471-41254-6

Unit	1	2	3	4	5	6	7
Slides	Intro	Architecture	Design 1 DFM [Bauer/Günzel]	Design 2	ETL	OLAP	Data Mining
Reading ^*	Chap. 1 & 2	Chap. 7 & 9	Chap. 10	Chap. 11	Chap. 12 & 13	Chap. 15	Chap. 17
Additional Reading			DFM paper (read page 6 !)	starER paper			DM Intro
Submission Deadlines of Assignments		Assignments 1 and 2	Assignments 3 and 4	Assignments 5 and 6	Assignment 7	Assignment 8, Steps 1 & 2	Assignment 8, Steps 3 & 4

Oracle Software for Data Warehousing

Oracle Database Server 10g Version 2, Oracle Warehouse Builder, and Oracle Workflow Manager. The installation files you will find on the specific group servers for this course. Additionally, you can download it from the Oracle web site after registration.

Eduard.Klein@fontys.nl