CRM & Information Mining II
level of course unit
second cycle, Master
Learning outcomes of course unit
In this advanced course, building on the introduction to basic techniques from ¿CRM & Information Mining I¿, additional topics will be dealt with in depth. These include the following focal points, which are in turn subdivided into the two main areas:
Data warehouse systems: more detailed multidimensional modeling; index structures for data warehouses: multidimensional index structures and the possibilities of optimizing them: star joins and partitioning, optimization of OLAP operations; more detailed discussion of the techniques and tasks in the ETL process; more detailed discussion of the techniques for OLAP operations.
Information mining: more detailed discussion of the techniques in the subtopics of clustering, association rules, classification and machine learning; advanced application examples of web mining, social mining and data mining. In the exercise component of the course the theoretical content acquired in the lecture component will be illustrated using practical examples and implemented within the context of a small project to be completed in a team
prerequisites and co-requisites
The students will acquire specialized knowledge of data warehouse systems. Among other things they will be conversant with extended multidimensional modeling concepts, index structures and also the possibilities of optimizing them, and will be able to use them effectively in systems.
Building on this the students will acquire specialized knowledge on techniques of clustering and machine learning.
recommended or required reading
- Andreas Bauer, Holger Günzel: Data-Warehouse-Systeme : Architektur, Entwicklung, Anwendung, Heidelberg : dpunkt-Verl., 2001;
- Ian H. Witten, Eibe Frank: Data Mining: praktische Werkzeuge und Techniken für das maschinelle Lernen, Hanser, 2001.
- Wolfgang Lehner: Datenbanktechnologie für Data-Warehouse-Systeme : Konzepte und Methoden, Heidelberg, dpunkt, 2003.
assessment methods and criteria
language of instruction
number of ECTS credits allocated
planned learning activities and teaching methods
Lecture, group work, presentation and task discussion
semester/trimester when the course unit is delivered
name of lecturer(s)
Dr. Michael Kohlegger
year of study
recommended optional program components
course unit code
type of course unit
mode of delivery