Efficient Computation of Trips with Friends and Families

A group of friends located at their working places may want to plan a trip to visit a shopping center, have dinner at a restaurant, watch a movie at a theater, and then finally return to their homes with the minimum total trip distance. For a group of spatially dispersed users a group trip planning (GTP) query returns points of interests (POIs) of different types such as a shopping center, a restaurant and a movie theater that minimize the aggregate trip distance for the group. The aggregate trip distance could be the sum or maximum of the trip distances of all users in the group, where the users travel from their source locations via the jointly visited POIs to their individual destinations. In this paper, we develop both optimal and approximation algorithms for GTP queries for both Euclidean space and road networks. Processing GTP queries in real time is a computational challenge as trips involve POIs of multiple types and computation of aggregate trip distances. We develop novel techniques to refine the POI search space for a GTP query based on geometric properties of ellipses, which in turn significantly reduces the number of aggregate trip distance computations. An extensive set of experiments on a real and synthetic datasets shows that our approach outperforms the most competitive approach on an average by three orders of magnitude in terms of processing time.

[1]  Tanzima Hashem,et al.  Privacy preserving group nearest neighbor queries , 2010, EDBT '10.

[2]  Kyriakos Mouratidis,et al.  Group nearest neighbor queries , 2004, Proceedings. 20th International Conference on Data Engineering.

[3]  Yufei Tao,et al.  Query Processing in Spatial Network Databases , 2003, VLDB.

[4]  Hanxiong Chen,et al.  Efficient Bounds in Finding Aggregate Nearest Neighbors , 2008, DEXA.

[5]  Feifei Li,et al.  On Trip Planning Queries in Spatial Databases , 2005, SSTD.

[6]  Tanzima Hashem,et al.  A Group Based Approach for Path Queries in Road Networks , 2013, SSTD.

[7]  Antonin Guttman,et al.  R-trees: a dynamic index structure for spatial searching , 1984, SIGMOD '84.

[8]  Vassilis J. Tsotras,et al.  Parameterized algorithms for generalized traveling salesman problems in road networks , 2013, SIGSPATIAL/GIS.

[9]  Hui Xiong,et al.  Exploiting a page-level upper bound for multi-type nearest neighbor queries , 2006, GIS '06.

[10]  Walid G. Aref,et al.  Casper*: Query processing for location services without compromising privacy , 2006, TODS.

[11]  Raffaele Perego,et al.  Where shall we go today?: planning touristic tours with tripbuilder , 2013, CIKM.

[12]  Cyrus Shahabi,et al.  The optimal sequenced route query , 2008, The VLDB Journal.

[13]  Elham Ahmadi,et al.  Group Trip Planning Queries in Spatial Databases , 2017 .

[14]  Hans-Peter Kriegel,et al.  The R*-tree: an efficient and robust access method for points and rectangles , 1990, SIGMOD '90.

[15]  Dimitris Papadias,et al.  Aggregate nearest neighbor queries in road networks , 2005, IEEE Transactions on Knowledge and Data Engineering.

[16]  Tanzima Hashem,et al.  Protecting privacy for group nearest neighbor queries with crowdsourced data and computing , 2013, UbiComp.

[17]  Tanzima Hashem,et al.  Group nearest neighbor queries in the presence of obstacles , 2014, SIGSPATIAL/GIS.

[18]  Kyriakos Mouratidis,et al.  Constrained Shortest Path Computation , 2005, SSTD.

[19]  Vassilis J. Tsotras,et al.  Engineering Generalized Shortest Path queries , 2013, 2013 IEEE 29th International Conference on Data Engineering (ICDE).

[20]  Hanan Samet,et al.  Ranking in Spatial Databases , 1995, SSD.

[21]  Tanzima Hashem,et al.  Safeguarding Location Privacy in Wireless Ad-Hoc Networks , 2007, UbiComp.

[22]  Yaron Kanza,et al.  TARS: traffic-aware route search , 2014, GeoInformatica.

[23]  Tanzima Hashem,et al.  Shared Execution of Path Queries on Road Networks , 2012, ArXiv.

[24]  Dennis Shasha,et al.  Warping indexes with envelope transforms for query by humming , 2003, SIGMOD '03.

[25]  Roger Zimmermann,et al.  The multi-rule partial sequenced route query , 2008, GIS '08.

[26]  Jing Li,et al.  Efficient notification of meeting points for moving groups via independent safe regions , 2013, 2013 IEEE 29th International Conference on Data Engineering (ICDE).

[27]  Hans-Peter Kriegel,et al.  Optimal multi-step k-nearest neighbor search , 1998, SIGMOD '98.

[28]  Hua Lu,et al.  Two ellipse-based pruning methods for group nearest neighbor queries , 2005, GIS '05.