Distributed moving object data management in MobilityDB
Mohamed S. Bakli, Mahmoud Attia Sakr, Esteban Zimányi · 2019
The availability of moving object data that is being collected nowadays, and the demand of using them in applications, have generated the need for spatiotemporal data management systems. MobilityDB is an open source moving object database system. Its core function is to efficiently store and query moving object trajectories. It is engineered up from PostgreSQL and PostGIS, providing spatiotemporal data management via SQL. In order to store and analyze the massive datasets of trajectories, a scalable version is required. In this paper, we present a solution to distribute MobilityDB using Citus. Citus is a PostgreSQL extension for distributed query processing. We report on the integration architecture, and the types of queries that can be distributed out of the box. The experiments prove the feasibility of the solution, and show a significant speed up in queries.