VO Data Warehouse Systems
Art: Vorlesung (VO2 + PS1, 4+2 = 6ECTS)
LVA-Leiter: Lecture: Prof. Dr. G. Specht,
Proseminar: DI Eva Zangerle
LFU-Online: Informationen im Lehrzielkatalog

This lecture and proseminar is for Master Students Computer Science and for Master Students Information Systems (WI).

Requirements
  • passed Lecture and Proseminar Database Systems
  • at least a minimal reading understand in German is helpful, since the main textbook is in German.
Lecture
Slides (intranet only)
Chap. 1   Introductionpdf
Chap. 2   Reference Architecturepdf
Chap. 3   The Multidimensional Data Model pdf
Chap. 4   Implementations of the Multidimensional Data Model    
pdf

Chap. 5   Index Structures for the Multidimensional Data Model

pdf  
Chap. 5.7 Column Stores
pdf
Chap. 6   Materialized Views pdf 
Chap. 7   Meta Datapdf
Chap. 8   ELT pdf
Chap. 9   OLAP and Data Miningpdf
Chap. 10 Repetitionpdf
Tutorial
 TutorialTopic
 
  1
 Multidimensional Modelling
pdf
  Slides of the first Tutorialpdf
  2
 Physical Modelling
pdf
  Squirrel Installation Manual
pdf
  Squirrel DB2 Drivers
db2jcc.jar db2jcc4.jar
  3
 OLAP on DB2
pdf
  SampleDW: Create Statements
create_dw_db2.sql
  SampleDW: Insert Statements
dump_50k_facts.sql
  4
 OLAP on DB2, Execution Plans
pdf
  5
 OLAP on DB2, Execution Planspdf
  6 Multidim. Arrays, Grid Files
pdf
  7 R-Trees
pdf
  8
 UB-Trees, Bitmap-Indices
pdf
  9 Materialized Views
pdf
 10 Association Rules
pdf
ECTS and Work Load

Our Tip:
Lecture and Proseminar together are 6 ECTS worth. 1 ECTS corresponds to 25 hour (a 60 min) work load. Thus the overall workload is 150 h. Subtracting 3*45min * 13 weeks (= 30 h) lectures and 20 h preparation for the final exam, we gain 100 h/ 13 weeks = 7.5 h/week. Please book fix 7.5 h/week in addition to lecture time in your week plan for post-processing the lecture, reading the textbook and textmaterial, for learning the stuff, for solving the exercises and for preparing next weeks lectures, in order to avoid time problems at the end.

Literature

recommended:

  • Bauer A., Günzel H. (Hrsg):
    Data Warehouse Systeme, Architektur, Entwicklung, Anwendung.
    dpunkt.verlag, 2nd, 2004, 592 S.


in addition:

  • Lehner W.: Datenbanktechnologie für Data-Warehouse-Systeme.
    dpunkt.verlag, 2003, 373 S.
Both availabe in the library at the technic campus.
Exams

The exam will be in written form.

The 1st exam is on February 1st 2012 at 12.00 in HS 10.

The 2nd exam is on March 13th 2012 at 10.00 in HS 11.

The 3rd exam is on April 24th 2012 at 11.00 in HS 10.