Lectures

References:
[1] Slides on SQL
[2] Exercise on SQL
[3] Slides on DBMS transaction management and recovery management
[4] Slides on DBMS file organization
[5] Slides on DBMS query evaluation
[6] Exercises on DBMS file organization and query evaluation
[7] Introduction to big data and data warehouses
[8] Slides on data warehousing
[9] Slides on graph databases
[10] Exercises on OLAP

1. 22/2/2016 ([1])
   Introduction. The relational data model.
2. 24/2/2016 ([1])
   The relational data model. Relational algebra.
3. 29/2/2016 ([1])
   SQL.
4. 2/3/2016 ([1])
   SQL.
5. 7/3/2016 ([1])
   SQL.
6. 9/3/2016 ([2])
   Exercise on SQL.
7. 14/3/2016 ([3])
   Transaction management in relational database systems.
8. 16/3/2016 ([3])
   Transaction management in relational database systems.
9. 21/3/2016 ([3])
   Recovery management in relational database systems.
10. 23/3/2016
    Evaluation of the first homework assignment.
11. 30/3/2016 ([4])
    File organization in relational database systems: simple organizations.
12. 4/4/2016 ([4])
    File organization in relational database systems: indexed organizations.
13. 6/4/2016 ([4])
    File organization in relational database systems: indexed organizations.
14. 11/4/2016 ([5])
    Query evaluation in relational database systems.
15. 13/4/2016 ([5], [7])
    Query evaluation in relational database systems. Introduction to big data and data warehouses.
16. 18/4/2016 ([6])
    Exercises on SQL query evaluation.
17. 20/4/2016 ([8])
    Data warehouses.
18. 27/4/2016
    Evaluation of the second homework assignment.
19. 2/5/2016 ([8])
    Data warehouses.
20. 4/5/2016 ([9])
    Graph databases.
21. 16/5/2016 ([9])
    RDF databases.
22. 18/5/2016 ([9])
    Linked open data.
23. 23/5/2016 ([10])
    NoSQL aggregated databases.
24. 25/5/2016 ([10,11])
    NoSQL aggregated databases. Exercises on OLAP.