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

Czech

Number of ECTS credits

6

Mode of study

Not applicable.

Guarantor

Ing. Vladimír Bartík, Ph.D.

Department

Institute of Economics (ÚE)

Learning outcomes of the course unit

Students understand the importance of data warehouses, OLAP techniques and data mining and are able to use it.

Prerequisites

Database systems

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Teaching methods depend on the type of course unit as specified in the article 7 of BUT Rules for Studies and Examinations.

Assesment methods and criteria linked to learning outcomes

- a mid-term test (10 points)
- a written exam (50 points)
- projects (40 points)

Course curriculum

1. Basic terms of data warehousing. Relationship of data warehouses and operational databases.
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

Not applicable.

Aims

Understanding the basic theory of data warehouses and acquirement of practical skills in their design and usage, understanding the basics of OLAP techniques and data mining.

Specification of controlled education, way of implementation and compensation for absences

Design and presentation of projects in due dates. Students can work on the projects in their own free time.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Lacko, L.: Datové sklady, analýza OLAP a dolování dat. Computer Press, 2003, 488 s. ISBN 80-7226-969-0 (CS)
Ponniah, P.: Data Warehousing Fundamentals. John Wiley & Sons, Inc., 2001, 516 s. ISBN 0-471-41254-6 (EN)

Recommended reading

Humphries, M., Hawkins, M. W. a kol.: Data warehousing, Principy a praxe. Computer Press, 2002, 256 s. ISBN 8072265601. (EN)

Classification of course in study plans

  • Programme BAK-MIn Bachelor's

    branch BAK-MIn , 3 year of study, winter semester, compulsory

Type of course unit

 

Lecture

13 hod., optionally

Teacher / Lecturer

doc. Ing. Jaroslav Zendulka, CSc.

Computer-assisted exercise

26 hod., compulsory

Teacher / Lecturer

Ing. Vladimír Bartík, Ph.D.