Students can present homeworks during the lectures. There will be three homework assignments, which will be announced on this web page.
For every homework, every student will get a score ranging from -4 to +1. The final exam score will be computed as follows:
final_score = hw_1 + hw_2 + hw_3 + 30
where hw_n is the score of homework n (if final_score > 30, then the final score is 30 cum laude).
Choose an application domain and, using a relational DBMS, build a database. This can be done in two ways:
The work must be done by groups of two students.
Students can use publicly available DBMSs like MySQL or PostgreSQL (see below), or other, commercial DBMSs.
The queries defined by the students should comprise all the aspects of SQL queries analyzed during the course lectures and exercises (joins, aggregations, nested queries, queries with negated subqueries). The complexity of the queries produced should be (at least) comparable to the specification appearing in the following exercise on SQL.
Starting from the database developed in the first homework, every group has to identify at least 4 SQL queries that pose performance problems to the DBMS. The students have to show both the "slow" and the "fast" execution of the queries, where the fast version is obtained by:
The first homework will be presented, together with the second one, in the week April 12 - April 16. The presentation of the work done wlll consist of a short (10-15 minutes) session in which the students will show the work done by directly interacting with the relational DBMS on their own laptop.
Use a NoSQL tool (property-graph database, RDF triple store, document-based database, key-value database, column-family database) to manage and query a dataset. Ideally, the groups should use the same dataset used in the first and second homework. Examples of such systems include (but are not limited to) Neo4J, GraphDB, MongoDB, Redis, Cassandra (see the course material on aggregate databases, graph and RDF databases for more details).
The work must be done by the same student groups who presented the first and second homework assignments (i.e., current project groups cannot be modified).
The presentation of the work done wlll consist of a short session (15 minutes at most) in which the students will show the work done by directly interacting with the NoSQL system on their own laptop, highlighting the differences with respect to a standard (SQL) relational database system.
The presentations of the third homework will be held during the lectures of May 24 and May 26, 2021. The order of presentations will be the same as the one for homeworks 1 and 2: so, the groups who presented HW 1 and 2 on April 12 will present HW 3 on May 24, and the groups who presented HW 1 and 2 on April 14 will present HW 3 on May 26 (a list with a more detailed presentation schedule will be published on Google Classroom).