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 15:03] ezimanyi [Course objective] |
teaching:projh402 [2021/08/31 18:59] ezimanyi [Trajectory Data Warehouses] |
||
---|---|---|---|
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: | ||
+ | |||
+ | * 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]] | ||
+ | * [[https://github.com/bmwcarit/barefoot|Barefoot]] | ||
+ | |||