Creative Commons License
This work is licensed under a Creative Commons Attribution-Noncommercial 4.0 License
In this paper, we propose a system model for querying and indexing the GPS trajectory of moving objects on PostGIS/PostgreSQL. We developed moving object data types including MPoint(moving point), MDouble(moving double) for GPS trajectories. Also, various moving objects UDFs(user-defined functions) are implemented for moving objects queries. For efficient query processing, r-tree index is extended for trajectory, and pre-materialization techniques are proposed for fast UDF processing. Experimental results show that the pre-materialization techniques are about 1.2 times faster than naïve query processing using r-tree index.
Yang, Pyoung Woo and Nam, Kwang Woo
"Supporting Trajectory UDF Queries and Indexes on PostGIS,"
Free and Open Source Software for Geospatial (FOSS4G) Conference Proceedings: Vol. 17
, Article 26.
Available at: https://scholarworks.umass.edu/foss4g/vol17/iss1/26