News

11-02-2017 Table with final scores [results]
11-02-2017 Table with test scores [results]
11-02-2017 Table with lab scores [results]
08-10-2016 The first lecture :)

The aim and the scope of the course

The aim of the course: To get to know how to design and construct data warehouses for efficient data processing.

The scope of the course: We will learn about:

Information about the Course

Schedule of Lectures

08-10-2016Introduction [pdf]
08-10-2016Evolution of database systems [pdf]
23-10-2016Dimensional modeling [pdf]
23-10-2016ETL and OLAP systems [pdf]
10-12-2016Multidimensional queries [pdf]
10-12-2016MOLAP and Multidimensional Queries [pdf]
14-01-2017Processing of very large data[pdf]

Schedule of Labs

15-10-2016 Dimensional modeling and data transformation [pdf] [unique_tracks.zip] [triplets_sample_20p.zip] [report-1.pdf] [report-1.tex]
06-11-2016 Dimensional modeling [pdf] [report-2.pdf] [report-2.tex]
14-01-2017 Process ETL and OLAP Queries in SQL [pdf] [SSIS project]
29-01-2017 OLAP Cubes and MDX [pdf] [MSD.zip]

Evaluation

Lecture:
Test : 75 points (min. 50%)
Labs : 25 points (min. 50%)
Labs:
Regular tasks and exercises : 4x25 points (min. 50%)
Bonus points for all: up to 10 points.

Scale

90% 5.0
80% 4.5
70% 4.0
60% 3.5
50% 3.0

Bibliography

Z. Królikowski, Hurtownie danych: logiczne i fizyczne struktury danych, Wydawnictwo Politechniki Poznańskiej 2007

A. Pelikant, Hurtownie danych. Od przetwarzania analitycznego do raportowania, Helion 2012

R. Kimball, M. Ross, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, John Wiley & Sons 2002

A. Rajaraman, J. D. Ullman, Mining of Massive Datasets, Cambridge University Press, 2011, http://www.mmds.org.

H. Garcia-Molina, J. D. Ullman, J. Widom, Systemy baz danych. Kompletny podręcznik. Wydanie II Helion, 2011.