Subject: Data Warehouse Systems (17.E2502 )
Native organizations units: Sub-department for Applied Computer Science and Informatics
Study programmes of the course:
| Type of studies | Title |
|---|---|
| Master Academic Studies | Measurement-Information Technologies and Control Engineering (Year: 1, Semester: Winter) |
| Master Academic Studies | Computing and Control Engineering (Year: 1, Semester: Winter) |
| Master Academic Studies | Software Engineering and Information Technologies (Year: 1, Semester: Winter) |
| Master Academic Studies | Information and Analytics Engineering (Year: 1, Semester: Winter) |
| Master Academic Studies | Information Engineering (Year: 1, Semester: Winter) |
Advanced students' education in the Data Warehouse (DW) system development and its application in Business Intelligence, i.e. software support of strategic and tactic management in organization systems.
To gain necessary skills and knowledge for the design and implementation of business intelligence and data warehouse systems in industry practice, as well as coupling these systems with decision support systems.
Characteristics, tasks and application domains of DW systems. Strategic system analysis as a prerequisite for the development of DW and business intelligence systems. Planning the DW system development process. A common methodology of the DW system development. A common DW system architecture. Enterprise DW systems and Data Mart systems. A common structure and the design of database schemas for DW systems. Methods and techniques of the initial load and subsequent refreshing of a DW database. Extraction, transforming and loading data into a DW database – ETL process. Computation of aggregated data in DW databases. Database Management Systems' mechanisms aimed at providing various DW system implementations. Preserving operational performances of DW systems. Decision support systems. OLAP tools and data analyses. Reporting techniques and tools. Data Mining techniques and tools in DW systems.
Teaching is performed through lessons, oral and computer exercises (in the computer classroom), as well as consultations. Through the teaching process, students are constantly motivated to an intensive discussion, problem oriented reasoning, independent study work and active participation in the whole lecturing process. The prerequisite to enter final exam is to complete all the pre-exam assignments by earning at least 30 points.
| Authors | Title | Year | Publisher | Language |
|---|---|---|---|---|
| 2002 | English | |||
| 2002 | English | |||
| Grupa autora | Priručnici za obezbeđenje upotrebe izabranog softverskog alata za razvoj |
2005 | English | |
| 2009 | English | |||
| 2000 | English |
| Course activity | Pre-examination | Obligations | Number of points |
|---|---|---|---|
| Oral part of the exam | No | Yes | 30.00 |
| Project | Yes | Yes | 30.00 |
| Test | Yes | Yes | 5.00 |
| Project task | Yes | Yes | 15.00 |
| Complex exercises | Yes | Yes | 10.00 |
| Complex exercises | Yes | Yes | 10.00 |
Assoc. Prof. Kordić Slavica
Associate Professor
Lectures
Assoc. Prof. Čeliković Milan
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.