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 18:57] 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 [1] 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 [2]. 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 [3] 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: | ||
+ | |||
+ | [1] 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. | ||
+ | [2] Danish Maritine Authority, Historical AIS data https://www.dma.dk/SikkerhedTilSoes/Sejladsinformation/AIS/Sider/default.aspx | ||
+ | [3] MobilityDB Workshop: https://github.com/MobilityDB/MobilityDB-workshop | ||
+ | |||