Advanced Databases

Course Description

The goal of the course is to familiarize students with key concepts and issues related to NoSQL databases, data streams, temporal and spatial databases. The course includes projects implemented using aforementioned technologies.

General Competencies

Students will be able to design and implement databases consisting of semistructured, multimedia and spatio-temporal data. The acquired knowledge will be applied on projects and applications.

Learning Outcomes

  1. design object-relational, temporal, spatial and NoSQL databases
  2. use object-relational, temporal, spatial, stream and NoSQL databases
  3. interpret semi-structured and structured data
  4. explain the concepts of different data models
  5. explain the principle of data warehouse development

Forms of Teaching

Lectures

Theoretical fundations and paradigms exposed during the lectures are illustrated with practical examples

Laboratory Work

Applying the knowledge acquired on lectures.

Grading Method

Continuous Assessment Exam
Type Threshold Percent of Grade Threshold Percent of Grade
Homeworks 40 % 10 % 40 % 10 %
Seminar/Project 50 % 40 % 50 % 40 %
Mid Term Exam: Written 0 % 25 % 0 %
Final Exam: Written 30 % 25 %
Exam: Written 50 % 25 %
Exam: Oral 25 %

Week by Week Schedule

  1. Storing and searching text in relational DBMS
  2. Advanced SQL
  3. Advanced SQL
  4. Object and object-relational databases
  5. Spatial databases
  6. Temporal databases
  7. NoSQL databases - part one
  8. Midterm exam
  9. NoSQL databases - part two
  10. NoSQL databases - part three
  11. NoSQL databases - part four
  12. Semantic web - part one
  13. Semantic web - part two
  14. Data Streams
  15. Final exam

Study Programmes

University graduate
Computer Engineering (profile)
Specialization Course (1. semester) (3. semester)
Computer Science (profile)
Specialization Course (1. semester) (3. semester)
Software Engineering and Information Systems (profile)
Theoretical Course (1. semester)

Prerequisites for

Literature

Pramod J. Sadalage, Martin Fowler (2012.), NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Addison Wesley
Eric Redmond, Jim R. Wilson (2012.), Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement, The Pragmatic Bookshelf
Raghu Ramakrishnan, Johannes Gehrke (2002.), Database Management Systems, McGraw-Hill

General

ID 34539
  Winter semester
5 ECTS
L2 English Level
L1 e-Learning
45 Lectures
0 Exercises
0 Laboratory exercises
0 Project laboratory

Grading System

87,5 Excellent
75 Very Good
62,5 Good
50 Acceptable