2025/2026

Exercises for the course Data Bases II, taught by Prof. Paraboschi.

Course page here.

Topics include:

• Transactions and scheduling
• Locking
• Distributed deadlock detection
• XML, XPath and XQuery
• FLWOR expressions

For any questions, please write an email using your student account.

Schedule

• 14/10/2025, 14:00—17:00, Schedules [slides]
• 15/10/2025, 08:30—10:00
  • Locks [slides]
  • Distributed deadlock [slides]
• 28/10/2025, 14:00—17:00
  • Warm restart [slides]
  • Recap for the exam
• 29/10/2025, 08:30—10:30, Recap for the exam
• 25/11/2025, 14:00—18:00
  • Introduction to XML [slides]
  • XPath [slides, exercises] and XQuery [slides, exercises]
  • Software to test XPath and XQuery [online, offline]
  • Sigmod Record [data, dtd], courtesy of Washington EDU
  • Factbook [xml]
  • Check older editions for more XQuery exercises
• 03/12/2025, 08:30—10:30, Triggers [slides]
• 10/12/2025, 08:30—10:30
  • Query optimization [slides]
  • Fragmentation [slides]
• 16/12/2025, 14:00—18:00
  • More Xquery [slides]
• 17/12/2025, 08:30—10:30
  • Some old exams [2015, 2012]

Solutions for the 2nd half of the in-course exam: [Part A], [Part B], [Part C].

Old editions

• 2024/2025
• 2023/2024
• 2022/2023
• 2017/2018, only the second part