Description
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)
ECTS: 6
Semester: 1
Lectures: 2
Exercises: 2
Lecturer
Biljana Radulovic, full professor
Email: bradulov@tfzr.uns.ac.rs
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
