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/31 18:54] ezimanyi [Trajectory Data Warehouses] |
teaching:projh402 [2021/08/31 19:01] ezimanyi [Trajectory Data Warehouses] |
||
|---|---|---|---|
| Line 73: | Line 73: | ||
| ===== Trajectory Data Warehouses ===== | ===== 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 | + | 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 [2]. To download the data you must | + | 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 | 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 | common Web browsers such as Chrome. Follow the instructions in Chapter 1 of | ||
| - | the MobilityDB Workshop [3] to load the data into MobilityDB. | + | 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. | 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. | + | * Define a conceptual multidimentional schema for the application. |
| - | * Translate the conceptual model into a relational data warehouse. | + | * Translate the conceptual model into a relational data warehouse. |
| - | * Implement the relational data warehouse in MobilityDB. | + | * Implement the relational data warehouse in MobilityDB. |
| - | * Implement analytical queries based on the queries proposed in [1]. | + | * Implement analytical queries based on the queries proposed in [1]. |
| Links: | Links: | ||
| - | [1] A. Vaisman and E. Zimányi. Mobility data warehouses. ISPRS International Journal of Geo- | + | * 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. |
| - | Information, 8(4), 2019. https://www.mdpi.com/2220-9964/8/4/170. | + | * Danish Maritine Authority, [[https://www.dma.dk/SikkerhedTilSoes/Sejladsinformation/AIS/Sider/default.aspx|Historical AIS data]] |
| - | [2] Danish Maritine Authority, Historical AIS data https://www.dma.dk/SikkerhedTilSoes/Sejladsinformation/AIS/Sider/default.aspx | + | * [[https://github.com/MobilityDB/MobilityDB-workshop|MobilityDB Workshop]] |
| - | [3] MobilityDB Workshop: https://github.com/MobilityDB/MobilityDB-workshop | + | |