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 exercice session.
For windows:
For mac:
For linux:
SQL Server. While choosing the “edition”, please select the free “Express” edition.
Azure studio. To connect to your SQL Server express, please indicate server: “localhost”, login: “SA” and the password selected during the installation of SQL Server.
Session 1 : Exercises "PhD"
Sessions 2 and 3 : Exercises "Employees Departments Projects"
Temporal databases
Sessions 4, 5 and 6
Planning:
Session 4: Exercice 1 (relational schema) and queries 1 to 5
Session 5: Queries 6 to 8 and constraints
Session 6: Queries 9 to 13
Graph databases
Sessions 7, 8, 9
The commands needed to start the server are written here under. Do not forget to first select the correct databasa as written in the assignment.
In Linux, login, then open a terminal window and type the following commands:
$ cd /tmp
$ tar xJf /serveur/neo4j.tar.xz
$ cd neo4j
$ ./bin/neo4j console
This will launch the server. The address where you can execute your queries should appear in the terminal.
Spatial databases (PostGIS)
Session 10
Session 11
Session 12