Course: DB Systems and Data Processing Methods 2

« Back
Course title DB Systems and Data Processing Methods 2
Course code KIV/DBM2
Organizational form of instruction Lecture + Tutorial
Level of course Master
Year of study not specified
Semester Winter
Number of ECTS credits 6
Language of instruction Czech
Status of course Compulsory, Compulsory-optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Klečková Jana, Doc. Dr. Ing.
  • Kryl Martin, Ing.
Course content
1.Data information, semantics, ontologies and semantic web - RDF, new options for data processing. 2. Basic concepts: data warehouse, ETL, OLAP and OLTP databases. 3. Data warehouses and data marts, facts and dimensions. 4. Models of the data warehouse - the issue of data modeling, data warehouses, business concepts, logical and physical model (diagram of stars, snowflakes), characteristics of the fact tables and dimension, the transformation between different models. 5. Structure for effective data warehouses. 6.Proces extraction, transformation and paste data (1 - extraction. 7. Process of extraction, transformation and insert data (2) - transformation. 8.Proces extraction, transformation and paste data (2) - insertion. 9.SQL structures for data warehouses. 10. Data Mining - description of data mining, data mining tasks, the application used data mining, data mining data-intensive statistical methods, artificial intelligence. 11.Data quallity. 12.Big Data.

Learning activities and teaching methods
Lecture, Practicum
  • Preparation for an examination (30-60) - 40 hours per semester
  • Preparation for comprehensive test (10-40) - 11 hours per semester
  • Contact hours - 65 hours per semester
  • Graduate study programme term essay (40-50) - 40 hours per semester
prerequisite
professional knowledge
explain the principles of relational databases, data integrity, and basic SQL commands
describe the data modeling techniques
explain the basic principles of security of data processing
professional skills
implement and complete an independent project by a specific assignment
work as team members with independent responsibility for a specific part of a large system
navrhnout databázový systém menšího až středního rozsahu
general eligibility
N/A
learning outcomes
professional knowledge
describe and explain trends in processing informací
explain basic principles of data warehouses
orient themselves in the possibilities of database technology with the aim of efficient data processing and knowledge acquisition
understand the principle of the Data Pump - the process of extraction, transformation and storage
explain and illustrate the methods and models for representation and processing of large and / or unstructured data
vysvětlit principy relačních databází, datové integrity a základních SQL příkazů, popsat postupy datového modelování
professional skills
design and optimize extensive data model
select and effectively use methods and technologies for the processing, analysis and representation of large structured and unstructured data
general eligibility
N/A
teaching methods
professional knowledge
Lecture
Practicum
professional skills
Practicum
general eligibility
Lecture
assessment methods
professional knowledge
Seminar work
Combined exam
Project
Group presentation at a seminar
professional skills
Test
Seminar work
Quality of a written report
general eligibility
Combined exam
Recommended literature
  • Griesemer, B. Oracle Warehouse Builder 11g: Getting Started. Packt Publishing, 2009.
  • Laberge, Robert. Datové sklady : agilní metody a business intelligence. 1. vyd. Brno : Computer Press, 2012. ISBN 978-80-251-3729-1.
  • Mohammed J. Zaki, Wagner Meira, Jr. Data Mining and Analysis: Fundamental Concepts and Algorithms,. Cambridge, 2014. ISBN 9780521766333.
  • Smart Mike. Learn Excel 2013 Expert Skills with the Smart Method. 2013. ISBN 1909253065.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Applied Sciences Information Systems (2016) Informatics courses 1 Winter
Faculty of Applied Sciences Medical Informatics (2016) Informatics courses 1 Winter
Faculty of Philosophy and Arts Theory and Philosophy of Communication (14-3) Philosophy, theology 2 Winter
Faculty of Applied Sciences Software Engineering (2017) Special and interdisciplinary fields 2 Winter
Faculty of Applied Sciences Information Systems (2017) Informatics courses 1 Winter
Faculty of Applied Sciences Information Systems (2015) Informatics courses 1 Winter
Faculty of Applied Sciences Software Engineering (2017) Special and interdisciplinary fields 2 Winter
Faculty of Applied Sciences Software Engineering (2015) Special and interdisciplinary fields 2 Winter
Faculty of Applied Sciences Information Systems (2013) Informatics courses 1 Winter
Faculty of Applied Sciences Medical Informatics (2017) Informatics courses 1 Winter
Faculty of Applied Sciences Medical Informatics (2015) Informatics courses 1 Winter
Faculty of Applied Sciences Software Engineering (2015) Special and interdisciplinary fields 2 Winter
Faculty of Philosophy and Arts Theory and Philosophy of Communication (14-1,2) Philosophy, theology 2 Winter