This is an old revision of the document!


INFO-H-415 : Exercises

Active databases

Before Session 1

If you are planning on working on your own laptop/computer (which is strongly advised given the state of the computers in the computer rooms), please download and install the following before the first exercise session.

Session 1 : Exercises "PhD"

Sessions 2 and 3 : Exercises "Employees Departments Projects"

Graph databases

Sessions 4, 5, 6

Material for Graph databases sessions

The slides and exercise sessions are available here above. The actual database dumps for the third exercise session are too large for this website and are available on the UV. Please note that you should download and use Neo4j 4.2.19. Solutions: - graphdb_solutions.zip

Temporal databases

Sessions 7, 8 and 9

  • Planning:
    • Session 7: Exercice 1 (relational schema) and queries 1 to 5
    • Session 8: Queries 6 to 8 and constraints
    • Session 9: Queries 9 to 13

Spatial databases (PostGIS)

For the spatial databases exercises, you will to install the following tool on your computer:

The two first exercise sessions will both be devided into a lab part and an exercise part. During the lab part, we will show you how to use the different tools and what we can do with them. This part will not be covered during the exam. During the exercise part, you will need to write some spatial databases requests. This part will be covered during the examination. PostgreSQL and PostGIS should be easy to install and are the two software necessary to perform the exercises. QGIS will only be used for the lab part of the sessions.

Session 10

Session 11

Session 12

 
teaching/infoh415/tp.1667812839.txt.gz · Last modified: 2022/11/07 10:20 by gdejaege