Differences

This shows you the differences between two versions of the page.

--- teaching:projh402 [2021/08/18 14:11]
ezimanyi [Symbolic trajectories]
+++ teaching:projh402 [2021/08/31 19:05]
ezimanyi [Trajectory Data Warehouses]
@@ Line 3: / Line 3: @@
 ===== 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 =====
@@ Line 65: / Line 65: @@
 ===== Symbolic trajectories =====
-Symbolic trajectories enable to attach semantic information to geometric trajectories . Essentially, symbolic trajectories are just time-dependent labels representing, for example, the names of roads traversed obtained by map matching, transportation modes, speed profile, cells of a cellular network, behaviors of animals, cinemas within 2km distance, and so forth. Symbolic trajectories can be combined with geometric trajectories to obtain annotated trajectories.
+Symbolic trajectories enable to attach semantic information to geometric trajectories. Essentially, symbolic trajectories are just time-dependent labels representing, for example, the names of roads traversed obtained by map matching, transportation modes, speed profile, cells of a cellular network, behaviors of animals, cinemas within 2km distance, and so forth. Symbolic trajectories can be combined with geometric trajectories to obtain annotated trajectories.
 The goal of this project is to explore how to implement symbolic trajectories in MobilityDB. This implementation will be based on the ttext (temporal text) data type implemented in MobilityDB and will explore how to extend it with regular expressions. This extension can be inspired from the [[https://www.postgresql.org/docs/13/functions-json.html|jsonb]] data type implemented in PostgreSQL.
@@ Line 71: / Line 71: @@
 Links:
   * {{: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 (follow the link "Get historical AIS data"). To download the data you must use an FTP client (such as FileZilla). 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.
+  * [[https://www.dma.dk/SikkerhedTilSoes/Sejladsinformation/AIS/Sider/default.aspx|Danish Maritine Authority]]
+  * [[https://github.com/MobilityDB/MobilityDB-workshop|MobilityDB Workshop]]