Open Access. Powered by Scholars. Published by Universities.®
Articles 1 - 2 of 2
Full-Text Articles in Computer Engineering
Supporting Trajectory Udf Queries And Indexes On Postgis, Pyoung Woo Yang, Kwang Woo Nam
Supporting Trajectory Udf Queries And Indexes On Postgis, Pyoung Woo Yang, Kwang Woo Nam
Free and Open Source Software for Geospatial (FOSS4G) Conference Proceedings
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.
Analyzing The Performance Of Nosql Vs. Sql Databases For Spatial And Aggregate Queries, Sarthak Agarwal, Ks Rajan
Analyzing The Performance Of Nosql Vs. Sql Databases For Spatial And Aggregate Queries, Sarthak Agarwal, Ks Rajan
Free and Open Source Software for Geospatial (FOSS4G) Conference Proceedings
Relational databases have been around for a long time and spatial databases have exploited this feature for close to two decades. The recent past has seen the development of NoSQL non-relational databases, which are now being adopted for spatial object storage and handling, too. While SQL databases face scalability and agility challenges and fail to take the advantage of the cheap memory and processing power available these days, NoSQL databases can handle the rise in the data storage and frequency at which it is accessed and processed - which are essential features needed in geospatial scenarios, which do not deal …