Technologies and systems for data processing

Study programs

Teaching information

Teachers

doc. Ing. Stanislav Ondáš, PhD. Ing. Ján Staš, PhD.

Schedule

Learning outcomes

The student will gain basic knowledge in the field of data analysis and business intelligence; with the issues of data processing from online transaction processing (OLTP) systems and basic principles and methods used in the creation and operation of data warehouses; acquire knowledge in the field of dimensional data modeling and OLAP analysis; also in the field of reporting, analysis, data visualization, and knowledge discovery in databases; and with the modern technologies and systems for immediate processing of massive big data flow.

Course outline

1. Data warehouse 2. Data consolidattion,the ETL process 3. Metadata in the data warehouse 4. Data warehouse structure 5. Dimensional modeling 6. Data presentation 7. OLAP analysis 8. Implementation variants of OLAP analysis 9. Data analysis using SQL 10. Data analytics 11. Data visualization 12. Knowledge discovery in databases 13. Modern technologies and systems for data processing

Completion conditions

Assessment and completion of the course: Graded credit test Continuous assessment: Final assessment: Student passes the final assessment and passes the examination when he or she meets the requirement to obtain at least 51% out of 100%. Graded credit test Overall assessment: Overall assessment is the sum of the assessments obtained by students in the assessment period. The overall result is determined in accordance with the internal regulations of the Technical University in Košice. (Study Regulations, the internal regulation principles of doctoral studies)

Recommended literature

[1] Inmon, B., et al. (2021) Building the Data Lakehouse. Technics Publications LLC, ISBN 978-1634629669 [2] Ross, M. a Kimball, R. (2013) The Data Warehouse Toolkit (3rd Edition). Wiley, ISBN 978-1118530801 [3] Vaisman, A. a Zimányi, E. (2014) Data Warehouse Systems: Design and Implementation. Springer, ISBN 978-3-642-54654-9 [4] Ponniah, Paulraj (2010) Data Warehousing: Fundamentals for IT Professionals (2nd Edition). Wiley, ISBN 978-0-470-46207-2 [5] Howson, Cindi (2014) Successful Business Intelligence (2nd Edition). McGraw-Hill Education, ISBN 978-0-07-180918-4 [6] Paralič, J. (2003) Objavovanie znalostí v databázach. Elfa Košice, ISBN 80-89066-60-7

Notes

To successfully complete the course, it is necessary to obtain credit and successfully pass the exam. This includes the student's participation in educational activities of direct teaching, lectures, and exercises, as well as independent study and independent creative activity of the student in processing the semester assignment/assignments, project on a specified topic, to a specified extent, in a specified design of a total of 180 hours intensity of the student's work per semester.

Grade distribution

Total graded students: 208