Course: Data Storage and Processing

» List of faculties » PRF » KI
Course title Data Storage and Processing
Course code KI/DUL
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 6
Language of instruction Czech
Status of course Compulsory-optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Fišer Jiří, Mgr. Ph.D.
  • Sýkorová Květuše, Mgr.
  • Kubera Petr, RNDr. Ph.D.
  • Kuba Pavel, Ing. Ph.D.
Course content
1. Basic principles of online analytical processing (OLAP) and online transaction processing (OLTP) 2. Architecture of multidimensional databases 3. Architecture of data models and data warehouses 4. Transformation of relational databases into multidimensional databases and data warehouses 5. Extract, Transform and Load (ETL) phase 6. Creation and accessing methods 7. Reports and client applications 8. Working with OLAP databases 9. Data warehouse development 10. Statistical principles of data mining 11. Data mining: physical and conceptual models 12. Data mining: algorithms, evaluation and verification of models

Learning activities and teaching methods
unspecified
Learning outcomes
The objective of this course is to provide introduction into multidimensional databases and data warehouses and principles of data mining.

Prerequisites
unspecified
KI/DSY

Assessment methods and criteria
unspecified
Recommended literature
  • Berka P. Dobývání znalostí z databází. AV ČR, 2003. ISBN 80-200-1062-9.
  • Humphries M., Hawkins M. W., Dy M. C. Data warehousing: Návrh a implementace. Computer Press, Praha, 2002. ISBN 80-7226-560-1.
  • Laberge R. Datové sklady. Agilní metody a business inteligence.. Computer Press, Brno, 2012. ISBN 978-80-251-3729-1.
  • Lacko L. Business Intelligence v SQL Serveru 2008 : reportovací, analytické a další datové služby. Computer Press, Brno, 2009. ISBN 978-80-251-2887-9.
  • Lacko L. Databáze: Datové sklady, analýza OLAP a dolování dat (s příklady v Microsoft SQL Serveru a Oracle). Computer Press, Brno, 2003. ISBN 80-7226-969-0.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Science Study plan (Version): Information Systems (A14) Category: Informatics courses 3 Recommended year of study:3, Recommended semester: Winter