Pg-Trajectory: A PostgreSQL/PostGIS Based Data Model for Spatiotemporal Trajectories
Ahmet Kucuk, Shah Muhammad Hamdi, Berkay Aydin, Michael A. Schuh, Rafal A. Angryk · 2016
Due to the tremendous advances in GPS and location-based web services, highly available spatiotemporal trajectory data poses an important challenge - knowledge discovery from trajectories. Knowledge discovery tasks on trajectory big data such as classification, clustering and outlier detection require a dedicated data model, which can support various utility functions and provide a robust object-relational mapping. This paper introduces PG-TRAJECTORY, a data model extension for the popular open source database management system PostgreSQL. Our data model is built on PostGIS, the spatial database extender of PostgreSQL. Apart from providing a data model, PG-TRAJECTORY contains a wide range of functions for storing and manipulating spatiotemporal trajectories. Throughout the paper, we discuss the basic structure of our data model with the working principles of the functions, and show a set of real life query examples. Finally, we present the results of our experimental evaluation to demonstrate the scalability and effectiveness of our data model.