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.
Students should practice techniques for projecting database schema, query setting, and data manipulation in Data Warehouse environment.
Study program: Information Technologies (Master degree)
Biljana Radulovic, full professor
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