PGWinFunc: Optimizing Window Aggregate Functions in PostgreSQL and Its Application for Trajectory Data

Jiansong Ma,Yu Cao,Xiaoling Wang,Chaoyong Wang,Cheqing Jin,Aoying Zhou
DOI: https://doi.org/10.1109/icde.2015.7113398
2015-01-01
Abstract:In modern cities, more and more people drive the vehicles, equipped with the GPS devices, which create a large scale of trajectories. Gathering and analyzing these large-scale trajectory data provide a new opportunity to understand the city dynamics and to reveal the hidden social and economic phenomena. This paper designs and implements a tool, named as PGWinFunc, to analyze trajectory data by extending a traditional relational database. Firstly we introduce some efficient query process and optimization methods for SQL Window Aggregate Functions in PostgreSQL. Secondly, we present how to mine the LBS (Location-Based Service) patterns, such as the average speed and traffic flow, from the large-scale trajectories with SQL expression with Window Aggregate Functions. Finally, the effectiveness and efficiency of the PGWinFunc tool are demonstrated and we also visualized the results by BAIDU MAP.
What problem does this paper attempt to address?