Course detail
Advanced Database Systems
FIT-PDBAcad. year: 2023/2024
The course offers broader introduction into the following modern database systems: various kinds of NoSQL databases, NewSQL databases, temporal databases, distributed databases, and advanced relational databases. There are also discussed principles of the modern database systems, their scheme, and techniques for efficient usage of such systems. In the lectures, there are also introduced implementation principles of the modern database systems and data manipulation techniques.
Language of instruction
Number of ECTS credits
Mode of study
Guarantor
Department
Entry knowledge
Rules for evaluation and completion of the course
- Mid-term exam, for which there is only one schedule and, thus, there is no possibility to have another trial.
- One project should be solved and delivered in a given date during a term.
- Mid-term exam - written form, questions, where answers are given in full sentences, no possibility to have a second/alternative trial. (20 points)
- Projects realization - 1 project (program development according to a given specification) with appropriate documentation. (25 points)
- Final exam is performed in written form. Students are given questions, where answers are provided in full sentences. The maximal amount of points one can get is 55 points - the minimal number of points which must be obtained from the final exam is 23, otherwise, no points will be assigned to a student. The exam has one regular and two corrective periods. Regular period is always performed in fully written way only. Corrective periods can be performed either in fully written form or in a combined form (both written and verbal performance in a single day, written in the morning verbal in the afternoon). The form of corrective periods is announced as soon as the previous period is evaluated, while the combined form will be performed in the case when for the particular period is assigned no more than 16 students.
Aims
Students will be able identify clearly post-relational DB systems and, for selected categories, they will also be able to discuss issues of implementation and usage of such systems.
- Student learns terminology in Czech and English language
- Student improves in participation on a small project as a member of a small team
Study aids
Prerequisites and corequisites
Basic literature
Recommended reading
Gaede, V., Günther, O.: Multidimensional Access Methods, ACM Computing Surveys, Vol. 30, No. 2, 1998, pp. 170-231.
Lemahieu, W., Broucke, S., Baesens, B.: Principles of Database Management. Cambridge University Press. 2018, 780 p.
Perkins, L., Redmond, E., Wilson, J.: Seven databases in sevenweeks: a guide to modern databases and the NoSQL movement. Secondedition. Pragmatic Bookshelf, 2018. ISBN 978-1-68050-253-4
Podklady k přednáškám (slajdy, skripty, apod.)
Elearning
Classification of course in study plans
- Programme IT-MSC-2 Master's
branch MIN , 0 year of study, winter semester, compulsory-optional
branch MSK , 1 year of study, winter semester, compulsory-optional
branch MBS , 0 year of study, winter semester, elective
branch MPV , 0 year of study, winter semester, elective
branch MIS , 1 year of study, winter semester, compulsory
branch MGM , 1 year of study, winter semester, compulsory
branch MBI , 1 year of study, winter semester, compulsory
branch MMM , 0 year of study, winter semester, elective - Programme MITAI Master's
specialization NSPE , 0 year of study, winter semester, elective
specialization NBIO , 0 year of study, winter semester, elective
specialization NSEN , 0 year of study, winter semester, elective
specialization NVIZ , 0 year of study, winter semester, elective
specialization NGRI , 0 year of study, winter semester, elective
specialization NADE , 0 year of study, winter semester, elective
specialization NISD , 2 year of study, winter semester, compulsory
specialization NMAT , 0 year of study, winter semester, elective
specialization NSEC , 0 year of study, winter semester, elective
specialization NISY up to 2020/21 , 0 year of study, winter semester, elective
specialization NCPS , 0 year of study, winter semester, elective
specialization NHPC , 0 year of study, winter semester, elective
specialization NNET , 0 year of study, winter semester, elective
specialization NMAL , 0 year of study, winter semester, elective
specialization NVER , 0 year of study, winter semester, elective
specialization NIDE , 0 year of study, winter semester, elective
specialization NEMB , 0 year of study, winter semester, elective
specialization NISY , 0 year of study, winter semester, elective
specialization NEMB up to 2021/22 , 0 year of study, winter semester, elective
Type of course unit
Lecture
Teacher / Lecturer
Syllabus
- Introduction, post-relational database definition, recap (O-R, multimedia, XML, spatial DB)
- NoSQL DB - column DB and their indexing, graph DB
- NoSQL DB - key-value DB, time series
- NoSQL DB - data aggregation, data warehouses
- NewSQL DB
- Column relational DB, comparison with classical storage
- Mid-term exam
- Temporal database systems, introduction
- Temporal data models
- Algorithms used in temporal database systems
- Distributed databases I
- Distributed databases II
- Conclusion, comparison of various database systems, open items discussion, another DBMS (deductive, object, ...)
Seminar
Teacher / Lecturer
Syllabus
- Demonstration: introduction to NoSQL DB, column NoSQL DB, DB key-value.
- Demonstration: No SQL DB + cloud - CQRS.
- Demonstration: temporal databases - introduction to temporal databases, languages (A)TSQL2, interpreters TimeDB2, TSQL2lib, (A)TSQL2 implementation.
Exercise in computer lab
Teacher / Lecturer
Syllabus
- Introductory computer exercise and NoSQL databases - introduction to work with particular types of NoSQL databases, indexing in such databases (column DB, key-value DB)
- NoSQL databases in a cloud - DBMS CQRS, work within cloud, exploitation of DB inside cloud
- Temporal databases - introduction to languages (A)TSQL2 as a temporal DML/DDL, queries over temporal data via (A)TSQL2
- Project demonstration
Project
Teacher / Lecturer
Syllabus
- Design and implementation of database system for particular scalable application exploiting features of CQRS (Command and Query Responsibility Segregation). Thus, operations over data are primarily performed via relational database and reading of the data is performed via scalable NoSQL database.
Elearning