Lecturer: prof. Montesi

Lab Sessions, 2017

According to this year’s lessions plan, the part of installing a RDBMS and using Java as a programming language to perform ORM, will not be included. Please refer to this link for all the details!

  • Lesson 1: Relational Algebra (Slides)
  • Lesson 2:
    1. Relational Algebra: Additional Exercises (IT), Q&A.
    2. DBMS Architecture - Query Plans (Slides)
      • Jens Dittrich – Patterns in Data Management [Book, Slides+Video]
      • Jan Van den Bussche, Stijn Vansummeren: Translating SQL into the Relational Algebra. [report, slides]
    3. SQL-3 query language (Slides)
      • Ulf Leser, Felix Naumann: Informationsintegration (DE). dpunkt.verlag. This book contains several ideas on how to use SQL syntax to perform data integration tasks.
  • Lesson 3:
    1. SQL-3 query language: Additional Exercises and Join Algorithms
    2. DBMS Architecture: Indexing: B+ Trees (Slides)
      • For a BTree application in a modern Key-Value architecture, see RocksDB
  • DBMS Architecture: Indexing: Hashing – Part II (Slides)
  • DBMS Architecture: Transactions (Slides, Exercises)
  • The Lab Sessions: Conceptual Data Modelling
  • Final Exam: A Demo. Final Q&A
    • Some examples [1, 2]

Lab Sessions, 2016

  • 2016/10/07 – Relational Algebra – Part I.
  • 2016/10/14 – Relational Algebra – Part II. Q&A, Exercises
  • 2016/10/21 – SQL query language (except “Esercizio 2” and “Esercizio 5”)
  • 2016/10/28 – DBMS Architecture: Query Plans
  • 2016/11/04 – DBMS Architecture: Indexing: B+ Trees – Part I
  • 2016/11/18 – DBMS Architecture: Indexing: Hashing – Part II
  • 2016/11/25 – DBMS Architecture: Transactions
  • 2016/11/30 – The Lab Sessions: Conceptual Data Modelling
  • 2016/12/02 – The Lab Sessions: RDBMS vs. Querying and Programming Languages
    • Please see this link for all the details!
  • 2016/12/07* – Final Exam: A Demo. Final Q&A
    • Some examples [1, 2]