Data Warehouses

News

(06 July 2007) Final results of the exam are available here.

Exam

The exam will take place on June 15 from 9am - 11am in CAB G51 (regular time, regular lecture hall).

You may bring to the exam your print-outs of the lecture slides. If your print-outs of the slides contain annotations, those annotations will be allowed. Therefore, you do not need to make a fresh print-out. Except for the print-outs of the lecture slides, you are NOT allowed to bring any material (books, notes, exercise sheets, etc) to the exam.

You will have 60 minutes to solve the exam.

Credit Suisse Workshop (June 8, 8:15 - 12:00)

On June 8, Credit Suisse will present their IT architecture. This workshop will take place from 8:15am - 12:00 (noon) in CAB G51 (regular lecture hall). Of course, there will be breaks and refreshments served. If possible, please, plan to attend the whole workshop.

Contents

This course presents the principles of decision support systems and so-called online-analytic processing (OLAP). The course will cover the following topics:

1. Motivation and Architecture
2. Modelling for OLAP: Star Schemas and Snow Flake Schemas
3. SQL Extensions for Decision Support (Cube, Aggregation sets, Pivot, etc.)
4. Demo of a Business Intelligence Tool (BTell)
5. Implementation Techniques (bitmap indexes, materialized views, star joins, ...)
6. Query optimization on virtual databases (federated, heterogeneous databases)
7. Data mining (classification trees, association rule mining, outlier detection)
8. Data cleaning, identity reconciliation
9. Probabilistic databases, data lineage
10. Dataspace Management
11. Industry talks (Applix TM 1, Credit Suisse)

Lecture Notes

1. Introduction
2. Top N
3. Skyline Queries
4. Query Processing and Indexing
5. Parallel Query Processing and Indexing
6. Data Cleaning (updated)
7. Probabilistic Databases
8. Industry Talk: Applix TM 1
9. Data Mining
10. Industry Talk: Credit Suisse (June 8)
11. Dataspaces (June 22)

References

Articles of the research literature on databases and information systems (e.g., SIGMOD and VLDB). Exact references will be given in the lecture notes.

Lecturers

Prof. Dr. Donald Kossmann

Dr. Jens-Peter Dittrich

Schedule

Lecture: 2V1U, Fridays 9-11 in CAB G 51

Exercises: 1st group on Fridays 11-12 in CAB G59, 2nd group on Fridays 12-13 in CAB G59

Exercises

Marcos Salles

Exam

The final exam will take place on Friday, June 15, at 9:15 am (room to be announced.) There will be no midterm exam. No "Testat" is given for this course.

Language

English

Podcast

Podcasts of the lectures are available here.

Requirements

ISG (Introduction to database systems, ER/UML modelling, normalization, SQL). Architecture & Implementation of Database Systems course is very helpful.