Distributed MobilityDB: A Scalable Moving Object Database Management System

Distributed MobilityDB [2] (DistMobilityDB) extends MobilityDB [7], the PostgreSQL/PostGIS-based moving-object database, into a clustered, SQL-native system for large spatiotemporal trajectory datasets. It introduces a distributed architecture that (1) partitions data with spatiotemporal awareness, (2) plans and executes a wide range of distributed spatiotemporal queries (range, distance/knn, intersection, self-joins) across worker nodes, and (3) is delivered as a PostgreSQL extension so it can be deployed on existing servers without recompilation or downtime. Experiments on real (AIS ship) and synthetic (BerlinMOD) datasets across on-prem and cloud clusters show that DistMobilityDB achieves scalable performance while preserving MobilityDB's rich SQL semantics.