Course detail
Data Warehousing
FP-DS_2Acad. year: 2012/2013
Basic terms: relational and multidimensional database model, operational database, data warehouse, data mart, building and running of a data warehouse, modelling a data warehouse - multidimensional model, data cube, OLAP analysis, data mining.
Language of instruction
Number of ECTS credits
Mode of study
Guarantor
Department
Learning outcomes of the course unit
Prerequisites
Co-requisites
Planned learning activities and teaching methods
Assesment methods and criteria linked to learning outcomes
- a written exam (50 points)
- projects (40 points)
Course curriculum
2. Architecture of a data warehouse. Modelling of data warehouses.
3. OLAP operations over a data cube.
4. A case study about using of data warehouses.
5. Introduction to the design of data warehouses.
6. Introduction to data mining in data warehouses.
Work placements
Aims
Specification of controlled education, way of implementation and compensation for absences
Recommended optional programme components
Prerequisites and corequisites
Basic literature
Ponniah, P.: Data Warehousing Fundamentals. John Wiley & Sons, Inc., 2001, 516 s. ISBN 0-471-41254-6 (EN)
Recommended reading
Classification of course in study plans