1. komponenta

Lecture type	Total
Lectures	30
Exercises	15

* Load is given in academic hour (1 academic hour = 45 minutes)

COURSE AIMS AND OBJECTIVES:
Enable students to:
- critically think about database systems and selection of databases depending on the IT system;
- work with relational databases in everyday production environment.

COURSE DESCRIPTION AND SYLLABUS:
1. Extending the knowledge of relational database management systems. Transactions. Indexes and active objects within a relational database. Complex data types. Temporal and geospatial databases.
2. Distributed databases. Goals, purpose, advantages, and disadvantages of data distribution. Distributed database structure, replication, fragmentation. Distributed transaction protocols.
3. Nonrelational (NoSQL) databases. Basic terms. Genesis of NoSQL databases. Aggregation data model. NoSQL database consistency and CAP theorem. Types of NoSQL databases. Distributed computing in NoSQL databases.
4. Combining relational and nonrelational systems. Hybrid model of information systems. NoSQL features in the relational DBMSs.

1. Baze podataka, drugo izdanje, R. Manger, Element, Zagreb, 2014.
2. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Pramod J. Sadalage, Martin Fowler, Addison Wesley, 2012.
3. NoSQL for Mere Mortals, D. Sullivan, Addison-Wesley Professional, 2015.
4. Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement, L. Perkins, E. Redmond, J. Wilson, Pragmatic Bookshelf, 2018.
5. Database System Concepts, 7th Edition, A. Silberschatz, H.F. Korth, S. Sudarshan, McGraw-Hill, NY, 2019.
6. Principles of Database Management: The Practical Guide to Storing, Managing and Analyzing Big and Small Data, W. Lemahieu, S. vanden Broucke, B. Baesens, Cambridge University Press, 2018.
7. Database Design and Relational Theory - Normal Forms and All That Jazz, 2nd Edition, C.J. Date, Apress, Berkley CA, 2019.

Izborni modul C - Znanost o podacima, 1. godina - Regular study - Computer Science and Mathematics
Ostali izborni predmeti - Regular study - Computer Science and Mathematics
Vezani kolegiji A - Regular study - Computer Science and Mathematics
Vezani kolegiji B - Regular study - Computer Science and Mathematics

Izborni modul C - Znanost o podacima, 1. godina - Regular study - Computer Science and Mathematics
Ostali izborni predmeti - Regular study - Computer Science and Mathematics
Vezani kolegiji A - Regular study - Computer Science and Mathematics
Vezani kolegiji B - Regular study - Computer Science and Mathematics