Description:

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.

Contents:

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 contents:

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

Recommended literature:

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

Abbreviations used:

Semester:

• W ... winter semester (usually October - February)
• S ... spring semester (usually March - June)
• W,S ... both semesters

Mode of completion of the course:

• A ... Assessment (no grade is given to this course but credits are awarded. You will receive only P (Passed) of F (Failed) and number of credits)
• GA ... Graded Assessment (a grade is awarded for this course)
• EX ... Examination (a grade is awarded for this course)
• A, EX ... Examination (the award of Assessment is a precondition for taking the Examination in the given subject, a grade is awarded for this course)

Weekly load (hours per week):

• P ... lecture
• C ... seminar
• L ... laboratory
• R ... proseminar
• S ... seminar