Paper Info
Title
Pg-Trajectory: A PostgreSQL/PostGIS Based Data Model for Spatiotemporal Trajectories
Abstract
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.
Year
DOI
Venue
2016
10.1109/BDCloud-SocialCom-SustainCom.2016.23
2016 IEEE International Conferences on Big Data and Cloud Computing (BDCloud), Social Computing and Networking (SocialCom), Sustainable Computing and Communications (SustainCom) (BDCloud-SocialCom-SustainCom)
Keywords
Field
DocType
Spatiotemporal Trajectories,Database Applications,Spatiotemporal Data Management
Data mining,Anomaly detection,Data modeling,Computer science,Knowledge extraction,Cluster analysis,Data model,Big data,Spatial database,Scalability
Conference
ISBN
Citations 
PageRank 
978-1-5090-3937-1
1
0.35
References 
Authors
25
5
Name
Order
Citations
PageRank
Ahmet Kucuk132.42
Shah Muhammad Hamdi232.76
Berkay Aydin34010.75
Michael A. Schuh4718.03
Rafal A. Angryk527145.56