Advanced database systems

Repository

Repository is empty

Poll

No polls currently selected on this page!

Advanced database systems

Code: 255137
ECTS: 5.0
Lecturers in charge: dr. sc. Ognjen Orel , v. pred.
Lecturers: Lectures:
dr. sc. Ognjen Orel , v. pred.

Exercises:
dr. sc. Ognjen Orel , v. pred.
Take exam: Studomat
Load:

1. komponenta

Lecture typeTotal
Lectures 30
Exercises 15
Description:
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.
Literature:
  1. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Pramod J. Sadalage, Martin Fowler, Addison Wesley, 2012.
  2. The Data Warehouse Toolkit - The Complete Guide to Dimensional Modeling, 2nd edition, R. Kimball, M. Ross, John Wiley & Sons, 2002.
  3. Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement, Eric Redmond, Jim Wilson, Pragmatic Bookshelf, 2012.
  4. Hadoop in practice, Alex Holmes, Manning, 2012.
Prerequisit for:
Enrollment :
Passed : Database systems
2. semester
Izborni predmet 3 - Regular study - Financial and Business Mathematics

3. semester Course not offered
Izborni predmet 4, 5, 6 - Regular study - Financial and Business Mathematics

4. semester
Izborni predmet 4, 5, 6 - Regular study - Financial and Business Mathematics
Consultations schedule:
  • For consultation hours, please contact the course lecturers.