Advanced Databases

Course Description

The goal of the course is to familiarize students with key concepts and issues related to emerging database technologies, object-oriented , object relational, temporal, spatial and NoSQL databases. Course focuses on advanced applications based on semistructured and spatio-temporal data.

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 Comment: Percent of Grade
Homeworks 40 % 5 % 40 % 5 %
Seminar/Project 50 % 40 % 50 % 40 %
Mid Term Exam: Written 0 % 25 % 0 %
Final Exam: Written 30 % 30 %
Exam: Written 50 % 30 %
Exam: Oral 25 %

Week by Week Schedule

  1. Advanced SQL
  2. Advanced SQL
  3. Object and object-relational databases
  4. Spatial databases
  5. Temporal databases
  6. NoSQL databases - part one
  7. NoSQL databases - part two
  8. Midterm exam
  9. NoSQL databases - part three
  10. NoSQL databases - part four
  11. Semantic web - part one
  12. Semantic web - part two
  13. Semantic web - part three
  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

Grading System

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

General

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