Martin Svoboda

NIE-PDB: Advanced Database Systems

Lectures | Labs | Assignments | Resources

Annotation

• Lecturer and tutor: Martin Svoboda
• Course webpage
• Schedule:
  • Lectures: Tuesday 16:15 - 17:45 (T9:347)
  • Labs: Tuesday 18:00 - 19:30 (T9:351) (odd calendar weeks only)
• Table with points from practical classes, homework assignments and exam tests
• Exam requirements

Lectures

• Tuesday 24. 09. 2024 - Lecture 01 - Introduction: Big Data, NoSQL Databases - PDF
• Tuesday 01. 10. 2024 - Lecture 02 - Data Formats: XML, JSON, BSON, RDF - PDF
• Tuesday 08. 10. 2024 - Lecture 03 - XML Databases: XPath, XQuery - PDF
• Tuesday 15. 10. 2024 - Lecture 04 - RDF Stores: SPARQL - PDF
• Tuesday 22. 10. 2024 - Lecture 05 - Basic Principles: Scaling, Sharding, Replication, CAP Theorem, Consistency - PDF
• Tuesday 29. 10. 2024 - Lecture 06 - Apache Hadoop: MapReduce, HDFS - PDF
• Tuesday 05. 11. 2024 - Lecture 07 - Key-Value Stores: RiakKV - PDF
• Tuesday 12. 11. 2024 - Lecture 08 - Document Databases: MongoDB - PDF
• Tuesday 19. 11. 2024 - Lecture 09 - Wide Column Stores: Cassandra, CQL - PDF
• Tuesday 26. 11. 2024 - Lecture 10 - Graph Databases: Neo4j, Cypher - PDF
• Tuesday 03. 12. 2024 - Lecture 11 - SQL Evaluation I: External Sort, Nested Loops Join - PDF
• Tuesday 10. 12. 2024 - Lecture 12 - SQL Evaluation II: Sort-Merge Join, Query Evaluation, Query Optimization
• Tuesday 17. 12. 2024 - Not scheduled

Labs

• Tuesday 24. 09. 2024 - Lab 00 - Organization - PDF
• Tuesday 08. 10. 2024 - Lab 01 - XQuery - PDF
  • Data files: data.xml
  • Solutions: queries-xpath.xq, queries-xquery.xq
  • Tools: XPath and XQuery Processor
• Tuesday 22. 10. 2024 - Lab 02 - SPARQL - PDF
  • Data files: data.ttl
  • Solutions: queries.pdf
  • SPARQL endpoint: https://nosql.opendata.cz/sparql
• Tuesday 05. 11. 2024 - Lab 03 - MapReduce - PDF
  • Source files: WordCount.java, InvertedIndex.java
  • See /home/PDB/mapreduce/ directory for input data and Hadoop libraries
• Tuesday 19. 11. 2024 - Lab 04 - MongoDB - PDF
  • Data files: data.js
  • Solutions: queries.js, mapreduce.js
• Tuesday 03. 12. 2024 - Lab 05 - Neo4j - PDF
  • Data files: data.cypher
  • Solutions: queries.cypher
• Tuesday 17. 12. 2024 - Not scheduled

Assignments

• Monday 14. 10. 2024 - Assignment 01 - XQuery - PDF - 20 points
• Monday 28. 10. 2024 - Assignment 02 - SPARQL - PDF - 20 points
• Monday 11. 11. 2024 - Assignment 03 - MapReduce - PDF - 20 points
• Monday 18. 11. 2024 - Assignment 04 - Riak - PDF - 15 points
• Monday 25. 11. 2024 - Assignment 05 - MongoDB - PDF - 20 points
• Monday 02. 12. 2024 - Assignment 06 - Cassandra - PDF - 15 points
• Monday 09. 12. 2024 - Assignment 07 - Neo4j - PDF - 20 points

Resources

• Sadalage, Pramod J. - Fowler, Martin: NoSQL Distilled.
  ISBN: 978-0-321-82662-6.
  Pearson Education, Inc., 2013.
• Wiese, Lena: Advanced Data Management: For SQL, NoSQL, Cloud and Distributed Databases.
  ISBN: 978-3-11-044140-6 (hardcover), 978-3-11-044141-3 (eBook PDF), 978-3-11-043307-4 (eBook EPUB).
  DOI: 10.1515/9783110441413.
  Walter de Gruyter GmbH, 2015.
• Zomaya, Albert Y. - Sakr, Sherif: Handbook of Big Data Technologies.
  ISBN: 978-3-319-49339-8 (hardcover), 978-3-319-49340-4 (eBook).
  DOI: 10.1007/978-3-319-49340-4.
  Springer International Publishing AG, 2017.