Modern Database Systems
NDBI040 - SS 2024 [Czech version]
General information:
- Annotation (source: SIS)
- Lecturer: Irena Holubová
- Details:
- The students should have the knowledge corresponding to the course NDBI025 - Database Systems.
- The lectures and practicals will be given only in Czech, the slides will be in English.
- Recordings of the lectures and practicals in English are provided below. The access login is 'student', the password was sent via e-mail - if you didn't get it, let me know.
- Consultations (in English) will take place upon request.
- Project/presentation - see instructions (recording od commentary: instructions.mp4 (113 MB))
- Possibilities for gaining points:
- Optional HW from practicals: 0 - 2 points per practicals (Total: 0 - 20 points)
- Presentation (from the lecturer): 0 - 30 points (0 if the author does not evaluate the quality of assigned presentations)
- Presentation (from colleagues): 0 - 5 points each (Total: 0 - 10 points. In the event that the assessment is missing, the lecturer will complete the assessment.)
- At least 22 points must be obtained for credits, of which at least 15 are for the presentation.
- Overview of results
- Exam:
- It will take the form of a written test, from which it is possible to gain up to 100 points.
- Bonus points from the practicals (i.e., points for the presentation 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
Contents of the lectures:
- Relational data model, relational databases. Historical overview of alternative
data models and database systems. Introduction to Big Data (history, features, data
models).
- Slides : lecture_DBhistory.pdf, lecture_introBigData.pdf
- Recording : NDBI040en-01-history-intro.mp4 (115 MB)
- Practicals : nothing to practise
- Distributed file systems. MapReduce - principle, properties, critique, alternative
approaches.
- Slides : lecture_HDFS.pdf, lecture_mapreduce.pdf
- Recording : NDBI040en-02-hdfs-mapreduce.mp4 (103 MB)
- Practicals : MapReduce - 01_practicals_mapreduce.pdf, 01_practicals_commands.txt, WordCount.java, mapper.py, reducer.py
- More information : Pavel Koupil's practicals
- Recording of the practicals : NDBI040encv-01-mapreduce.mp4 (53 MB)
- Apache Spark. Basic principles of Big Data Management.
- Slides : lecture_spark.pdf, lecture_principles.pdf
- Recording : NDBI040en-03-spark-principles.mp4 (103 MB)
- Practicals : Apache Spark - 02_practicals_spark.pdf, 02_practicals_commands.txt
- More information : Pavel Koupil's practicals
- Recording of the practicals : NDBI040encv-02-spark.mp4 (98 MB)
- Overview and classification of database systems and technologies for efficient
management and processing of Big Data.
- Slides : lecture_technologiesBigData.pdf
- Recording : NDBI040en-04-technologies.mp4 (101 MB)
- Practicals : nothing to practise
- NoSQL databases: key / value
- Slides : lecture_keyvalue.pdf
- Recording : NDBI040en-05-keyvalue.mp4 (85 MB)
- Practicals :
- 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)
- NoSQL databases: column-family
- Slides : lecture_column.pdf
- Recording : NDBI040en-06-column.mp4 (66 MB)
- Practicals : Apache Cassandra - 05_practicals_column.pdf, 05_practicals_commands.txt
- More information : Pavel Koupil's practicals
- Recording of the practicals : NDBI040encv-05-cassandra.mp4 (41 MB)
- NoSQL databases: document
- Slides : lecture_document.pdf
- Recording : NDBI040en-07-document.mp4 (75 MB)
- Practicals : MongoDB - 06_practicals_document.pdf, 06_practicals_commands.txt
- More information : Pavel Koupil's practicals
- Recording of the practicals : NDBI040encv-06-mongodb.mp4 (46 MB)
- Graph data and graph databases
- Slides : lecture_graph.pdf
- Recording : NDBI040en-08-graph.mp4 (83 MB)
- Practicals : Neo4j - 07_practicals_graph.pdf, 07_practicals_commands.txt
- More information : Pavel Koupil's practicals
- Recording of the practicals : NDBI040encv-07-neo4j.mp4 (66 MB)
- Data with multiple models. Multi-model databases.
- Slides : lecture_multimodel.pdf
- Recording : NDBI040en-09-multimodel.mp4 (67 MB)
- Practicals : PostgreSQL - 08_practicals_multimodel.pdf, 08_practicals_commands.txt
- More information : Pavel Koupil's practicals
- Recording of the practicals : NDBI040encv-08-postgresql.mp4 (47 MB)
- Other types of modern DBMSs. SQL language in the world of Big Data. NewSQL
databases. Array databases. Search engine DBMSs.
- Slides : lecture_others.pdf
- Recording : NDBI040en-10-others.mp4 (85 MB)
- Practicals :
- SciDB - 09_practicals_array.pdf, 09_practicals_commands.txt
- Elasticsearch - 10_practicals_elastic.pdf, 10_practicals_commands.txt
- 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)
- Polystores. Adcanced principles of Big Data management.
- Slides : lecture_polystores.pdf, lecture_advanced.pdf
- Recording : NDBI040en-11-polystores-advanced.mp4 (88 MB)
- Practicals : nothing to practise
Literature:
See the references in the slides.