This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
teaching:projh402 [2021/08/18 14:11] ezimanyi [Symbolic trajectories] |
teaching:projh402 [2021/08/31 19:01] ezimanyi [Trajectory Data Warehouses] |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ===== Course objective ===== | ===== Course objective ===== | ||
| - | The course PROJ-H-402 is managed by Dr. Mauro Birattari. Please refer to the course description page http://iridia.ulb.ac.be/proj-h-402/index.php/Main_Page for the rules concerning the project. What follows is a list of project proposals supervised by academic members of the WIT laboratory. | + | The course PROJ-H-402 is managed by Dr. Mauro Birattari. Please refer to the [[http://iridia.ulb.ac.be/wiki/PROJ-H-402_-_Computing_Project:_Rules|course description page]] for the rules concerning the project. What follows is a list of project proposals supervised by academic members of the WIT laboratory. |
| ===== Projects in Mobility Databases ===== | ===== Projects in Mobility Databases ===== | ||
| Line 71: | Line 71: | ||
| Links: | Links: | ||
| * {{:teaching:symbolic_trajectories.pdf|}} | * {{:teaching:symbolic_trajectories.pdf|}} | ||
| + | |||
| + | ===== Trajectory Data Warehouses ===== | ||
| + | Mobility data warehouses are data warehouses that keep location data for a set of moving objects. You can refer to the article below for more information about the subject. The project consists in building a mobility data warehouse for ship trajectories on MobilityDB. | ||
| + | |||
| + | The input data comes from the Danish Maritine Authority. To download the data you must | ||
| + | use an FTP client (such as FileZilla) since the link Get historical AIS data does not work with | ||
| + | common Web browsers such as Chrome. Follow the instructions in Chapter 1 of | ||
| + | the MobilityDB Workshop to load the data into MobilityDB. | ||
| + | |||
| + | You must implement a comprehensive data warehouse application. For this, you will perform in particular the following steps. | ||
| + | * Define a conceptual multidimentional schema for the application. | ||
| + | * Translate the conceptual model into a relational data warehouse. | ||
| + | * Implement the relational data warehouse in MobilityDB. | ||
| + | * Implement analytical queries based on the queries proposed in [1]. | ||
| + | |||
| + | Links: | ||
| + | |||
| + | * A. Vaisman and E. Zimányi. [[https://www.mdpi.com/2220-9964/8/4/170|Mobility data warehouses]]. ISPRS International Journal of GeoInformation, 8(4), 2019. | ||
| + | * Danish Maritine Authority, [[https://www.dma.dk/SikkerhedTilSoes/Sejladsinformation/AIS/Sider/default.aspx|Historical AIS data]] | ||
| + | * [[https://github.com/MobilityDB/MobilityDB-workshop|MobilityDB Workshop]] | ||
| + | |||
| + | |||