TRAJECTORY DATA WAREHOUSE MODELING AND IMPLEMENTATION FOR TRAJECTORY DATA EXPLORATION

• Main Author: Dwi Putra Perkasa, Rio
• Format: Final Project
• Language: Indonesia
• Online Access: https://digilib.itb.ac.id/gdl/view/43800
• Institution: Institut Teknologi Bandung

The use of location-related technologies such as GPS and wireless communication is currently very extensive, resulting in large spatiotemporal or trajectory data. But trajectory data cannot produce useful information, so there is a need for a data warehouse that can handle data trajectory or trajectory data warehouse. Some previously trajectory data warehouse modeling are still many domain-based or general modeling. For this reason, it is necessary to choose the most appropriate model for the general trajectory data warehouse model that trajectory data exploration can be performed. Trajectory data warehouse modeling is done by comparing existing trajectory data warehouse models. Then the most appropriate model for general trajectory and easier to explore trajectory is chosen. From this it was found that the Mobility Data Warehouse model was chosen as the model adopted for the trajectory data warehouse model in this final project. This model was chosen because it stores spatial information in its measure so that trajectory exploration is easy to do. The selected model is implemented and used to solve problems or queries that have been provided. This final project uses trajectory data from taxis in Beijing and surrounding areas. Using this model, a test is carried out by running a combination of OLAP operations and spatial functions in the taxi's trajectory data. The result is the model can be used for exploration of trajectory data by performing ordinary OLAP operations, spatial functions, or a combination of OLAP operations in a trajectory data warehouse.