INFO-H-415 : Exercises

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 1

TP1

Session 2

TP2

Session 3

Mobility databases

Sessions 4, 5, 6

…

Temporal databases

Sessions 7 and 8

Planning:
- Session 7: Exercice 1 (relational schema) and queries 1 to 8
- Session 8: Queries 9 to 13

Active databases

Before Session 9

Please download and install the following before the first exercise session.

For windows:
- Server: SQL Server Express
- GUI: Azure studio or SQL Server Management Studio or DataGrip
For mac:
- Follow this tutorial. Note that for the GUI, you can also use DataGrip.
For linux:
- Server: SQL Server. While choosing the “edition”, please select the free “Express” edition.
- GUI: Azure studio or DataGrip. To connect to your SQL Server express, please indicate server: “localhost”, login: “SA” and the password selected during the installation of SQL Server.

Table of Contents