Database systems 2

Relations:

It is not possible to register for the course BE4M36DS2 if the student is concurrently registered for or has already completed the course B4M36DS2 (mutually exclusive courses).

During a review of study plans, the course B4M36DS2 can be substituted for the course BE4M36DS2.

It is not possible to register for the course BE4M36DS2 if the student is concurrently registered for or has previously completed the course B4M36DS2 (mutually exclusive courses).

Course guarantor:

Yuliia Prokop

Lecturer:

Yuliia Prokop

Tutor:

Yuliia Prokop

Supervisor:

Department of Computer Science

Synopsis:

The aim of the course is to introduce students to new trends in the field of database systems. We will focus primarily on current issues related to Big Data and the associated challenges of distributed data storage and processing. The course will present the basic types of so-called NoSQL databases, as well as related topics such as cloud computing, data warehouses, and distributed computing over large datasets.

Requirements:

To complete the course, students are required to attend practical classes, work continuously throughout the semester, and submit assigned tasks and the required milestones of the final project on time via the e-learning platform.

Students must prepare the final project according to the assignment, present its results to the teacher, and successfully pass the in-person written exam. All submitted work will be checked using an anti-plagiarism system.

Syllabus of lectures:

1. Introduction to Big Data and NoSQL databases

2. Comparison and classification of NoSQL databases

3. Fundamentals of Big Data management (CAP, distribution, scaling, replication)

4. Key-Value databases

5. Document databases

6. Wide-column databases

7. Graph databases basic principles

8. Graph databases advanced aspects

9. Advanced principles of Big Data (transactions, performance, polyglot persistence)

10. The principle of MapReduce

11. Data warehouses and Big Data

11. Cloud computing

13. Advanced principles of Big Data (transactions, performance, polyglot persistence)

14. Reserve

Syllabus of tutorials:

1. Introduction to Big Data and NoSQL databases

2. Comparison and classification of NoSQL databases

3. Data formats (XML, JSON)

4. Key-Value databases (Redis)

5. Key-Value databases (Redis, Redis Stack)

6. Document databases (MongoDB) creating, updating, and deleting records

7. Document databases (MongoDB) search queries

8. Document databases (MongoDB) aggregation queries

9. Wide-column databases

10. Graph databases basic CRUD operations

11. Graph databases graph traversal and search

12. MapReduce and HDFS

13. Final project demonstration

14. Reserve

Study Objective:

The aim of the study is for students to understand the principles of modern database systems, with a focus on NoSQL databases and working with large-scale and diverse data. Students will learn to distinguish the basic types of NoSQL databases and understand their data models, querying capabilities, and typical areas of application.

After completing the course, students will be able to choose an appropriate database system for a specific task, design a corresponding data model, and justify the chosen solution with regard to the nature of the data, expected queries, scaling, distribution, and performance. Emphasis is also placed on practical work with selected database systems and on the ability to compare their advantages and limitations.

Study materials:

1.http://nosql-database.org/

2.Pramod J. Sadalage - Martin Fowler: NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot

Persistence, 2012

3.Eric Redmond - Jim R. Wilson: Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL

Movement, 2012

4.Sherif Sakr - Eric Pardede: Graph Data Management: Techniques and Applications, 2011

5.Shashank Tiwari: Professional NoSQL, 2011

6.Hadoop: The Definitive Guide, by Tom White, 2nd edition, 2010

7.Martin Kleppmann. Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and

Maintainable Systems, 2017

8.Shannon Bradshaw, Eoin Brazil, Kristina Chodorow. Mongodb: The Definitive Guide: Powerful and Scalable Data,

2020

9.Jeff Carpenter, Eben Hewitt. Cassandra: The Definitive Guide. OReilly Media, 2016

10.Jeremy Nelson. Mastering Redis. Packt Publishing, 2016

Note:

Further information:

https://cw.fel.cvut.cz/wiki/courses/BE4M36DS2

Time-table for winter semester 2025/2026:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon	roomKN:E-301 Prokop Y. 09:15–10:45 (lecture parallel1) Karlovo nám. roomKN:E-311 Prokop Y. 14:30–16:00 (lecture parallel1 parallel nr.102) Karlovo nám.
Tue
Wed
Thu
Fri

Time-table for summer semester 2025/2026:

Time-table is not available yet

The course is a part of the following study plans:

• Open Informatics - Software Engineering (compulsory course of the specialization)
• Open Informatics - Data Science (compulsory course of the specialization)
• Open Informatics - Software Engineering 2026 (PS)
• Open Informatics - Data Science 2026 (PS)