Main page | Study Branches/Specializations | Groups of Courses | All Courses | Roles                Instructions

A course is the basic teaching unit, it's design as a medium for a student to acquire comprehensive knowledge and skills indispensable in the given field. A course guarantor is responsible for the factual content of the course.
For each course, there is a department responsible for the course organisation. A person responsible for timetabling for a given department sets a time schedule of teaching and for each class, s/he assigns an instructor and/or an examiner.
Expected time consumption of the course is expressed by a course attribute extent of teaching. For example, extent = 2 +2 indicates two teaching hours of lectures and two teaching hours of seminar (lab) per week.
At the end of each semester, the course instructor has to evaluate the extent to which a student has acquired the expected knowledge and skills. The type of this evaluation is indicated by the attribute completion. So, a course can be completed by just an assessment ('pouze zápočet'), by a graded assessment ('klasifikovaný zápočet'), or by just an examination ('pouze zkouška') or by an assessment and examination ('zápočet a zkouška') .
The difficulty of a given course is evaluated by the amount of ECTS credits.
The course is in session (cf. teaching is going on) during a semester. Each course is offered either in the winter ('zimní') or summer ('letní') semester of an academic year. Exceptionally, a course might be offered in both semesters.
The subject matter of a course is described in various texts.

NIE-PDB Advanced Database Systems Extent of teaching: 2P+1C
Instructor: Svoboda M. Completion: Z,ZK
Department: 18102 Credits: 5 Semester: Z

Annotation:
Students orient themselves in problems of evaluation and optimization of SQL queries. The next part of the course deals with new concepts of database machines (so called NoSQL databases), with the related new data models (XML, graph databases, column databases) and languages for working with them (XQuery, XPath, CYPHER, Gremlin). The last part of the course deals with performance evaluation of database machines. This course is equivalent to the course MIE-PDB.

Lecture syllabus:
1. (2) SQL optimization and evaluation.
3. BIG data, data models of NoSQL database machines.
4. CAP theorem, concepts BASE vs ACIT, shard replication.
5. Document-oriented databases.
6. (3) Graph databases.
9. (2) XML database, XQuery language.
11. Key-value and wide-column databases.
12. Big Data Processing Platforms (Haddop, Spark).
13. Benchmarks. Trends in database system development.

Seminar syllabus:
1. Revision of RDBMS, object-relational features of SQL
2. Evaluation and optimization of SQL
3. Mongo DB - practical questioning
4. Cypher - practical questioning
5. XQuery - practical questioning
6. semester test

Literature:
Elmasri, R. - Navathe, B. S. : Fundamentals of Database Systems (7th Edition). Pearson, 2015. ISBN 978-0133970777.

Requirements:
The basic knowledge of conceptual data modeling, relational data model, and relational algebra. Good knowledge of SQL (only relational part, on the level of SQL92), especially SELECT statement, DML, and DDL.

https://courses.fit.cvut.cz/MIE-PDB/.

The course is also part of the following Study plans:
Study Plan Study Branch/Specialization Role Recommended semester
NIE-PSS.21 Computer Systems and Networks 2021 V 3
NIE-PB.21 Computer Security 2021 V 3
NIE-DBE.2023 Digital Business Engineering PV 1
NIE-SI.21 Software Engineering 2021 PS 3
NIE-TI.21 Computer Science 2021 VO 3
NIE-NPVS.21 Design and Programming of Embedded Systems 2021 V 3


Page updated 28. 3. 2024, semester: Z/2023-4, L/2019-20, L/2022-3, Z/2019-20, Z/2022-3, L/2020-1, L/2023-4, Z/2020-1, Z,L/2021-2, Send comments to the content presented here to Administrator of study plans Design and implementation: J. Novák, I. Halaška