Modern Database Systems

NDBI040 - WS 2024 [Czech version]

General information:

Annotation (source: SIS)
Time and place of the lectures: Thursday 09:00 S4
Time and place of the practicals: Thursday 10:40 SU2, Thursday 14:00 SW2
Lecturers: Irena Holubová, Stefanie Scherzinger (University of Passau, e-mail)
Details:
- Students are expected to have knowledge in the scope of the course NDBI025 - Database Systems.
- Teaching will take place partially in Czech (Irena Holubová) and partially in English (Stefanie Scherzinger); slides and other resources will be available in English. For the parts of Irena Holubová, recordings of the lectures and practicals in English are available below. The user name to access is 'student'; the password was sent by email. If you did not receive it, let me know.
- Lectures by prof. Scherzinger will take place in a "flipped" mode, i.e. at the latest at the previous lecture, you will receive materials for studying (typically a video or a text), and there will be recapitulation and practice at the respective lecture.
- To work on the project of Stefanie Scherzinger you need to fill in, sign, and submit the Declaration of Authenticity (can be sent by e-mail).
- Consultations will take place based on an individual request.
- To access the nosql server (at some practicals - see instructions below), use the following parameters:
  - SSH: nosql.ms.mff.cuni.cz:42222
  - User name: mds_surname (e.g. Jan Novák has mds_novak)
  - Password: Same as for video recordings (change with passwd)
- Possibilities for gaining points:
  - Optional assignments from practicals: 0 - 2 points for each assignment (Total: 0 - 20 points)
  - miniHive project: 0 - 30 points
- At least 25 points must be obtained to gain the credits.
- Overview of results
- Exam:
  - It will take the form of a written test, from which one can gain up to 100 points.
  - Bonus points from the practicals (i.e., points above the limit needed for the credits) will be added to the points obtained from the test.
  - Conversion of points to a mark: > 60 points = mark 3, > 75 points = mark 2, > 90 points = mark 1
Related topics for Bachelor/Master theses and SW Projects can be found in the SIS and/or here:
- Projects - DSE (topics supervised by I. Holubová / J. Bártík / P. Koupil)
- Jáchym Bártík
- Pavel Koupil

Course of Lectures:

3.10. 2024 - Relational data model, relational databases. Historical overview of alternative data models and database systems. Introduction to Big Data (history, features, data models).
- Lecturer: Irena Holubová
- Materials: lecture_DBhistory.pdf, lecture_introBigData.pdf
- Recordings: NDBI040en-01-history-intro.mp4 (115 MB)
10.10. 2024 - Distributed file systems. MapReduce - principle, properties, critique, alternative approaches.
- Lecturers: Irena Holubová, Stefanie Scherzinger
- Materials: lecture_HDFS.pdf, lecture_mapreduce.pdf
- Recordings: NDBI040en-02-hdfs-mapreduce.mp4 (103 MB)
17.10. 2024 - Relational algebra and canonical translation of SQL into relational algebra.
- Lecturer: Stefanie Scherzinger
- Resources: MDS_Prep1.pdf, MDS_FlippedClassroom1.pdf
24.10. 2024 - Logical optimization in relational algebra.
- Lecturer: Stefanie Scherzinger
- Resources: MDS_Prep2.pdf, MDS_FlippedClassroom2.pdf
31.10. 2024 - Apache Spark. Basic principles of Big Data management.
- Lecturer: Irena Holubová
- Materials: lecture_spark.pdf, lecture_principles.pdf
- Recordings: NDBI040en-03-spark-principles.mp4 (103 MB)
7.11. 2024 - Translation of SQL to MapReduce. Communication costs in MapReduce.
- Lecturer: Stefanie Scherzinger
- Resources: MDS_Prep3.pdf, MDS_FlippedClassroom3.pdf
14.11. 2024 - Optimization of MapReduce workflows.
- Lecturer: Stefanie Scherzinger
- Resources: MDS_Prep4.pdf, MDS_FlippedClassroom4.pdf
21.11. 2024 - Overview and classification of database systems and technologies for efficient management and processing of Big Data. NoSQL key/value databases.
- Lecturer: Irena Holubová
- Materials: lecture_technologiesBigData.pdf, lecture_keyvalue.pdf
- Recordings: NDBI040en-04-technologies.mp4 (101 MB), NDBI040en-05-keyvalue.mp4 (85 MB)
28.11. 2024 - NoSQL columnar databases.
- Lecturer: Irena Holubová
- Materials: lecture_column.pdf
- Recordings: NDBI040en-06-column.mp4 (66 MB)
5.12. 2024 - NoSQL document databases.
- Lecturer: Irena Holubová
- Materials: lecture_document.pdf
- Recordings: NDBI040en-07-document.mp4 (75 MB)
12.12. 2024 - Graph data and graph databases.
- Lecturer: Irena Holubová
- Materials: lecture_graph.pdf
- Recordings: NDBI040en-08-graph.mp4 (83 MB)
19.12. 2024 - Dates with multiple models, multi-model databases. Polystores.
- Lecturer: Irena Holubová
- Materials: lecture_multimodel.pdf, lecture_polystores.pdf
- Recordings: NDBI040en-09-multimodel.mp4 (67 MB), NDBI040en-11-polystores-advanced.mp4 (88 MB) - first half
9.1. 2025 - Other types of modern DBMSs. SQL language in the world of Big Data. NewSQL databases. Array databases. Search engine DBMSs. Advanced principles of Big Data management.
- Lecturer: Irena Holubová
- Materials: lecture_others.pdf, lecture_advanced.pdf
- Recordings: NDBI040en-10-others.mp4 (85 MB), NDBI040en-11-polystores-advanced.mp4 (88 MB) - second half

Course of Practicals:

3.10. 2024 - cancelled (we have nothing to practice)
- Task for the next practicals: If you do not know Python, take the first lessons of the free course at Udacity Introduction to Programming in Python (up to and without the "Functions" chapter). You have to register on Udacity, but the course is free.
10.10. 2024 - MapReduce
- Lecturer: Stefanie Scherzinger
- Sources: MDS_Prague_Labs1.pdf
17.10. 2024 - Kick-off of the 1st milestone (deadline: 28.10. 2024).
- Lecturer: Stefanie Scherzinger
- Sources: MDS_Prague_Labs2.pdf, miniHiveMilestone1.pdf
24.10. 2024 - Kick-off of the 2nd milestone (deadline: 11.11. 2024).
- Lecturer: Stefanie Scherzinger
- Sources: Manual_Praktomat.pdf, miniHiveMilestone2.pdf
31.10. 2024 - Spark: 02_practicals_spark.pdf, 02_practicals_commands.txt
- Lecturer: Irena Holubová
- More information: Pavel Koupil's practicals
- Recording of the practicals: NDBI040encv-02-spark.mp4 (98 MB)
7.11. 2024 - Kick-off of the 3rd milestone (deadline: 2.12. 2024).
- Lecturer: Stefanie Scherzinger
- Sources: miniHiveMilestone3.pdf
14.11. 2024 - Kick-off of the 4th milestone (deadline: 16.12. 2024).
- Lecturer: Stefanie Scherzinger
- Sources: miniHiveMilestone4.pdf
21.11. 2024 - Redis: 03_practicals_redis.pdf, 03_practicals_commands.txt
Riak: 04_practicals_riak.pdf, 04_practicals_commands.txt
- Lecturer: Irena Holubová
- More information:
  - Redis - Pavel Koupil's practicals
  - Riak - Pavel Koupil's practicals
- Recording of the practicals:
  - Redis - NDBI040encv-03-redis.mp4 (39 MB)
  - Riak - NDBI040encv-04-riak.mp4 (40 MB)
28.11. 2024 - Apache Cassandra: 05_practicals_column.pdf, 05_practicals_commands.txt
- Lecturer: Irena Holubová
- More information: Pavel Koupil's practicals
- Recording of the practicals: NDBI040encv-05-cassandra.mp4 (41 MB)
5.12. 2024 - MongoDB: 06_practicals_document.pdf, 06_practicals_commands.txt
- Lecturer: Irena Holubová
- More information: Pavel Koupil's practicals
- Recording of the practicals: NDBI040encv-06-mongodb.mp4 (46 MB)
12.12. 2024 - Neo4j: 07_practicals_graph.pdf, 07_practicals_commands.txt
- Lecturer: Irena Holubová
- More information: Pavel Koupil's practicals
- Recording of the practicals: NDBI040encv-07-neo4j.mp4 (66 MB)
19.12. 2024 - PostgreSQL: 08_practicals_multimodel.pdf, 08_practicals_commands.txt
- Lecturer: Irena Holubová
- More information: Pavel Koupil's practicals
- Recording of the practicals: NDBI040encv-08-postgresql.mp4 (47 MB)
9.1. 2025 - SciDB: 09_practicals_array.pdf, 09_practicals_commands.txt
Elasticsearch: 10_practicals_elastic.pdf, 10_practicals_commands.txt
- Lecturer: Irena Holubová
- More information:
  - SciDB - Pavel Koupil's practicals
  - Elasticsearch - Pavel Koupil's practicals
- Recording of the practicals:
  - SciDB - NDBI040encv-09-scidb.mp4 (43 MB)
  - Elasticsearch - NDBI040encv-10-elastic.mp4 (43 MB)