| 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).
- passed Lecture and Proseminar Database Systems
- at least a minimal reading understand in German is helpful, since the main textbook is in German.
| Chap. 1 Introduction | |
| Chap. 2 Reference Architecture | |
| 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 | |
| Chap. 5.7 Column Stores | pdf |
| Chap. 6 Materialized Views | pdf |
| Chap. 7 Meta Data | |
| Chap. 8 ELT | |
| Chap. 9 OLAP and Data Mining | |
| Chap. 10 Repetition |
| Tutorial | Topic | |
| 1 | Multidimensional Modelling | pdf |
| Slides of the first Tutorial | pdf | |
| 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 Plans | pdf |
| 6 | Multidim. Arrays, Grid Files | |
| 7 | R-Trees | pdf |
| 8 | UB-Trees, Bitmap-Indices | pdf |
| 9 | Materialized Views | pdf |
| 10 | Association Rules | pdf |
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.
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.
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.
