Martin Svoboda

MI-PDB, MIE-PDB: Advanced Database Systems

Basic Information

• Lecturers:
  • Michal Valenta
  • Martin Svoboda
• Schedule MI-PDB (Czech):
  • Lectures: Tuesday 14:30 - 16:00 (TK:BS)
  • Practices (group 103): Tuesday 18:00 - 19:30 (T9:343) (even weeks only)
  • Practices (group 104): Tuesday 16:15 - 17:45 (T9:343) (odd weeks only)
• Schedule MIE-PDB (English):
  • Lectures: Tuesday 12:45 - 14:15 (T9:302)
  • Practices: Tuesday 16:15 - 17:45 (T9:343) (even weeks only)

Lectures

• 15. 03. 2016: 04 - XML, XPath
• 29. 03. 2016: 06 - XQuery
• 05. 04. 2016: 07 - XML databases, SQL/XML, Sedna
• 12. 04. 2016: 08 - Big Data and NoSQL databases
• 19. 04. 2016: 09 - Graph databases, Neo4j, Cypher
• 26. 04. 2016: 10 - MapReduce, Hadoop
• 03. 05. 2016: 11 - RDF, SPARQL
• 10. 05. 2016: 12 - Key-value databases, Riak, Redis
• 17. 05. 2016: 13 - Document databases, MongoDB

Practical Classes

• 23. 2. and 1. 3. 2016: 01 - SQL: Query Evaluation and Optimization I
• 8. and 15. 3. 2016: 02 - SQL: Query Evaluation and Optimization II
• 22. and 29. 3. 2016: 03 - XPath
  • Exercises: overview and assignments, solutions
  • Data files: employees.xml, departments.xml
  • Tools: Altova XMLSpy, Exchanger XML Editor
• 5. and 12. 4. 2016: 04 - XQuery
  • Exercises: overview and assignments, solutions
  • Data files: employees.xml, departments.xml (both the same as for XPath)
• 19. and 26. 4. 2016: 05 - Neo4j: Cypher
  • Exercises: overview and assignments, solutions
  • Data files: data.txt
• 3. and 10. 5. 2016: 06 - SPARQL
  • Exercises: assignments, solutions
  • Data files: data.pdf