Subject: Data Warehouse Design (17.IZOI41 )
Study programmes of the course:
| Type of studies | Title |
|---|---|
| Undergraduate Academic Studies | Information Systems Engineering (Year: 4, Semester: Summer) |
The course provides students with the knowledge about the principles of design and appliance of data warehouse (DW), emphasizing the significance of strategic analysis of organization for the development of DW system. Through mastering general design methodology and general architecture of DW, students should be able to plan the project of DW development, choose the appropriate architecture components and build DW that will be good basement for quality business intelligence system. Given the extremely dynamic development of commercial tools in this area, an important goal is to enable students to a systematic approach to the study of new tools that will enable them to quickly and easily master their use.
Upon completing this course successfully, students will be able to: formulate problem from Universe of Discourse, design and implement database, model and build the system to carry out analytical data from transactional data, using several methods and techniques, and to build a data warehouse. Student will be introduced with the mechanisms of database management systems aimed at data warehouse system support, and with the techniques for the performance improvement of data warehouse systems.
Introduction to data warehouse systems and business intelligence. Strategical analysis of the organization, data warehouse system development and decision support systems. The complexity of the construction and use of data warehouse systems. Architecture of data warehouse system. Data warehouse design methodology. Meta-data management. Methods and techniques for initially loading and refreshing of data warehouse. Methods and techniques to derive analytical data from transactional data. Data transformation and loading. Data base management system mechanisms to support data warehouse system. Performance, safety and security of data warehouse systems.
Lectures; laboratory exercises; individual consultations; team and individual work (assignments, complex exercises and project). Students are encouraged to communicate, to reason critically, to work independently and in the team, and to contribute actively to teaching process.
| Authors | Title | Year | Publisher | Language |
|---|---|---|---|---|
| 2015 | English | |||
| 2013 | English | |||
| 2013 | English | |||
| 2017 | English |
| Course activity | Pre-examination | Obligations | Number of points |
|---|---|---|---|
| Project task | Yes | Yes | 15.00 |
| Test | Yes | Yes | 10.00 |
| Exercise attendance | Yes | Yes | 5.00 |
| Complex exercises | Yes | Yes | 30.00 |
| Oral part of the exam | No | Yes | 30.00 |
| Test | Yes | Yes | 10.00 |
Prof. Ristić Sonja
Full Professor
Lectures
Assistant - Master Antanasijević Dajana
Assistant - Master
Computational classes
Assistant - Master Gladić Dejana
Assistant - Master
Computational classes
Assistant - Master Krstić Dušan
Assistant - Master
Computational classes
Assistant - Master Petrovački Jelena
Assistant - Master
Computational classes
Faculty of Technical Sciences
© 2024. Faculty of Technical Sciences.
Contact:
Address: Trg Dositeja Obradovića 6, 21102 Novi Sad
© 2024. Faculty of Technical Sciences.