Repository is empty


No polls currently selected on this page!

Advanced database systems

Code: 61610
ECTS: 5.0
Lecturers in charge: dr. sc. Ognjen Orel , v. pred.
Lecturers: dr. sc. Ognjen Orel , v. pred. - Exercises

1. komponenta

Lecture typeTotal
Lectures 30
Exercises 15
* Load is given in academic hour (1 academic hour = 45 minutes)
COURSE AIMS AND OBJECTIVES: Getting familiar with some advanced topics in the area of database systems, data warehouses, NoSQL paradigm and Big Data processing.

1. Expanding knowledge of relational databases. Complex data types. Distributed databases. Aims, purposes, advantages and flaws of data distribution. Structure of the distributed database, replication, fragmentation. Distributed transactions protocols.
2. NoSQL paradigm. Why NoSQL? Aggregated data model. NoSQL database properties. Consistency and CAP theorem. Types of NoSQL database: key-value, document, graph and column-family databases. Map/reduce algorithm in the NoSQL world.
3. Data warehouses. Aims and purposes. Data warehouse models. The process of data warehouse creation. OLAP. ETL (extract-transform-load) process.
4. Big Data. Distributed file systems. Google FS and HDFS. Apache Hadoop ecosystem. Map/reduce algorithm. Distributed calculations and analyses. Apache Spark.
  1. Pramod J. Sadalage, Martin Fowler: NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence
  2. R. Kimball, M. Ross: The Data Warehouse Toolkit - The Complete Guide to Dimensional Modeling, 2nd edition
  3. Eric Redmond, Jim Wilson: Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement
  4. Alex Holmes: Hadoop in practice
  5. A. Silberschatz, H. F. Korth, S. Sudarshan: Database System Concepts, 4th edition
3. semester
Izborni računarski predmet 1, 2 - Regular study - Mathematics and Computer Science Education

4. semester Not active
Izborni računarski predmet 1, 2 - Regular study - Mathematics and Computer Science Education
Consultations schedule: