University of Novi Sad Technical faculty "Mihajlo Pupin" Zrenjanin



Theoretical classes:

Data Warehouse – complex databases, systems for decision support, comparison of operational data, Time interval, Multidimensionality of data, Projecting of star schema and snowflake schema, Identification of user requirements, logical projecting, extraction of operative data, Generation of queries and Data Mining System projecting. Extension of SQL standard – Data Cube.

 Practical classes:

Students should practice techniques for projecting database schema, query setting, and data manipulation in Data Warehouse environment.



General information


Study program: Information Technologies (Master degree)


Semester: 1

Lectures: 2                                                                                                   

Exercises: 2




Biljana Radulovic, full professor



Course books


1. Mogin P.,LukovicI., Govedarica M., Principles of Databases Projecting (in Serbian), Faculty of Technical Sciences,Novi   Sad, 2000.

2. Lazarevic B., Marjanovic Z., Anicic N., Babarogic S., Databases (in Serbian), Faculty of Organizational Sciences, Belgrade, 2006.

3. Ullman J., Widom J., Database Systems - Complete Book,StanfordUniversity, Addison Wesley 2002