Spatial queries with k-Nearest-Neighbor and relational predicates

Ahmed M. Aly, Walid G. Aref, Mourad Ouzzani

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

The ubiquity of location-aware devices and smartphones has unleashed an unprecedented proliferation of location-based services that require processing queries with both spatial and relational predicates. Many algorithms and index structures already exist for processing fc-Nearest-Neighbor (kNN, for short) predicates either solely or when combined with textual keyword search. Unfortunately, there has not been enough study on how to efficiently process queries where kNN predicates are combined with general relational predicates, i.e., ones that have selects, joins and group-by's. One major challenge is that because the kNN is a ranking operation, applying a relational predicate before or after a kNN predicate in a query evaluation pipeline (QEP, for short) can result in different outputs, and hence leads to different query semantics. In particular, this renders classical relational query optimization heuristics, e.g., pushing selects below joins, inapplicable. This paper presents various query optimization heuristics for queries that involve combinations of kNN select/join predicates and relational predicates. The proposed optimizations can significantly enhance the performance of these queries while preserving their semantics. Experimental results that are based on queries from the TPC-H benchmark and real spatial data from OpenStreetMap demonstrate that the proposed optimizations can achieve orders of magnitude enhancement in query performance.

Original languageEnglish
Title of host publicationGIS: Proceedings of the ACM International Symposium on Advances in Geographic Information Systems
PublisherAssociation for Computing Machinery
Volume03-06-November-2015
ISBN (Print)9781450339674
DOIs
Publication statusPublished - 3 Nov 2015
Event23rd ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2015 - Seattle, United States
Duration: 3 Nov 20156 Nov 2015

Other

Other23rd ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2015
CountryUnited States
CitySeattle
Period3/11/156/11/15

Fingerprint

Predicate
Nearest Neighbor
Query
heuristics
Semantics
Join
Query Optimization
Location based services
Query processing
Smartphones
spatial data
ranking
Pipelines
Heuristics
Query Evaluation
Keyword Search
Optimization
Query Processing
Spatial Data
Processing

Keywords

  • K-Nearest-Neighbor
  • Query optimization
  • Relational databases

ASJC Scopus subject areas

  • Earth-Surface Processes
  • Computer Science Applications
  • Modelling and Simulation
  • Computer Graphics and Computer-Aided Design
  • Information Systems

Cite this

Aly, A. M., Aref, W. G., & Ouzzani, M. (2015). Spatial queries with k-Nearest-Neighbor and relational predicates. In GIS: Proceedings of the ACM International Symposium on Advances in Geographic Information Systems (Vol. 03-06-November-2015). [a28] Association for Computing Machinery. https://doi.org/10.1145/2820783.2820815

Spatial queries with k-Nearest-Neighbor and relational predicates. / Aly, Ahmed M.; Aref, Walid G.; Ouzzani, Mourad.

GIS: Proceedings of the ACM International Symposium on Advances in Geographic Information Systems. Vol. 03-06-November-2015 Association for Computing Machinery, 2015. a28.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Aly, AM, Aref, WG & Ouzzani, M 2015, Spatial queries with k-Nearest-Neighbor and relational predicates. in GIS: Proceedings of the ACM International Symposium on Advances in Geographic Information Systems. vol. 03-06-November-2015, a28, Association for Computing Machinery, 23rd ACM SIGSPATIAL International Conference on Advances in Geographic Information Systems, ACM SIGSPATIAL GIS 2015, Seattle, United States, 3/11/15. https://doi.org/10.1145/2820783.2820815
Aly AM, Aref WG, Ouzzani M. Spatial queries with k-Nearest-Neighbor and relational predicates. In GIS: Proceedings of the ACM International Symposium on Advances in Geographic Information Systems. Vol. 03-06-November-2015. Association for Computing Machinery. 2015. a28 https://doi.org/10.1145/2820783.2820815
Aly, Ahmed M. ; Aref, Walid G. ; Ouzzani, Mourad. / Spatial queries with k-Nearest-Neighbor and relational predicates. GIS: Proceedings of the ACM International Symposium on Advances in Geographic Information Systems. Vol. 03-06-November-2015 Association for Computing Machinery, 2015.
@inproceedings{77221958c0d34018a4124ba108d6aff3,
title = "Spatial queries with k-Nearest-Neighbor and relational predicates",
abstract = "The ubiquity of location-aware devices and smartphones has unleashed an unprecedented proliferation of location-based services that require processing queries with both spatial and relational predicates. Many algorithms and index structures already exist for processing fc-Nearest-Neighbor (kNN, for short) predicates either solely or when combined with textual keyword search. Unfortunately, there has not been enough study on how to efficiently process queries where kNN predicates are combined with general relational predicates, i.e., ones that have selects, joins and group-by's. One major challenge is that because the kNN is a ranking operation, applying a relational predicate before or after a kNN predicate in a query evaluation pipeline (QEP, for short) can result in different outputs, and hence leads to different query semantics. In particular, this renders classical relational query optimization heuristics, e.g., pushing selects below joins, inapplicable. This paper presents various query optimization heuristics for queries that involve combinations of kNN select/join predicates and relational predicates. The proposed optimizations can significantly enhance the performance of these queries while preserving their semantics. Experimental results that are based on queries from the TPC-H benchmark and real spatial data from OpenStreetMap demonstrate that the proposed optimizations can achieve orders of magnitude enhancement in query performance.",
keywords = "K-Nearest-Neighbor, Query optimization, Relational databases",
author = "Aly, {Ahmed M.} and Aref, {Walid G.} and Mourad Ouzzani",
year = "2015",
month = "11",
day = "3",
doi = "10.1145/2820783.2820815",
language = "English",
isbn = "9781450339674",
volume = "03-06-November-2015",
booktitle = "GIS: Proceedings of the ACM International Symposium on Advances in Geographic Information Systems",
publisher = "Association for Computing Machinery",

}

TY - GEN

T1 - Spatial queries with k-Nearest-Neighbor and relational predicates

AU - Aly, Ahmed M.

AU - Aref, Walid G.

AU - Ouzzani, Mourad

PY - 2015/11/3

Y1 - 2015/11/3

N2 - The ubiquity of location-aware devices and smartphones has unleashed an unprecedented proliferation of location-based services that require processing queries with both spatial and relational predicates. Many algorithms and index structures already exist for processing fc-Nearest-Neighbor (kNN, for short) predicates either solely or when combined with textual keyword search. Unfortunately, there has not been enough study on how to efficiently process queries where kNN predicates are combined with general relational predicates, i.e., ones that have selects, joins and group-by's. One major challenge is that because the kNN is a ranking operation, applying a relational predicate before or after a kNN predicate in a query evaluation pipeline (QEP, for short) can result in different outputs, and hence leads to different query semantics. In particular, this renders classical relational query optimization heuristics, e.g., pushing selects below joins, inapplicable. This paper presents various query optimization heuristics for queries that involve combinations of kNN select/join predicates and relational predicates. The proposed optimizations can significantly enhance the performance of these queries while preserving their semantics. Experimental results that are based on queries from the TPC-H benchmark and real spatial data from OpenStreetMap demonstrate that the proposed optimizations can achieve orders of magnitude enhancement in query performance.

AB - The ubiquity of location-aware devices and smartphones has unleashed an unprecedented proliferation of location-based services that require processing queries with both spatial and relational predicates. Many algorithms and index structures already exist for processing fc-Nearest-Neighbor (kNN, for short) predicates either solely or when combined with textual keyword search. Unfortunately, there has not been enough study on how to efficiently process queries where kNN predicates are combined with general relational predicates, i.e., ones that have selects, joins and group-by's. One major challenge is that because the kNN is a ranking operation, applying a relational predicate before or after a kNN predicate in a query evaluation pipeline (QEP, for short) can result in different outputs, and hence leads to different query semantics. In particular, this renders classical relational query optimization heuristics, e.g., pushing selects below joins, inapplicable. This paper presents various query optimization heuristics for queries that involve combinations of kNN select/join predicates and relational predicates. The proposed optimizations can significantly enhance the performance of these queries while preserving their semantics. Experimental results that are based on queries from the TPC-H benchmark and real spatial data from OpenStreetMap demonstrate that the proposed optimizations can achieve orders of magnitude enhancement in query performance.

KW - K-Nearest-Neighbor

KW - Query optimization

KW - Relational databases

UR - http://www.scopus.com/inward/record.url?scp=84961226201&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84961226201&partnerID=8YFLogxK

U2 - 10.1145/2820783.2820815

DO - 10.1145/2820783.2820815

M3 - Conference contribution

SN - 9781450339674

VL - 03-06-November-2015

BT - GIS: Proceedings of the ACM International Symposium on Advances in Geographic Information Systems

PB - Association for Computing Machinery

ER -