Spatial queries with two kNN predicates

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

Research output: Chapter in Book/Report/Conference proceedingChapter

11 Citations (Scopus)

Abstract

The widespread use of location-aware devices has led to countless location-based services in which a user query can be arbitrarily complex, i.e., one that embeds multiple spatial selection and join predicates. Amongst these predicates, the k-Nearest-Neighbor (kNN) predicate stands as one of the most important and widely used predicates. Unlike related research, this paper goes beyond the optimization of queries with single kNN predicates, and shows how queries with two kNN predicates can be optimized. In particular, the paper addresses the optimization of queries with: (i) two kNN-select predicates, (ii) two kNN-join predicates, and (iii) one kNN-join predicate and one kNN-select predicate. For each type of queries, conceptually correct query evaluation plans (QEPs) and new algorithms that optimize the query execution time are presented. Experimental results demonstrate that the proposed algorithms outperform the conceptually correct QEPs by orders of magnitude.

Original languageEnglish
Title of host publicationProceedings of the VLDB Endowment
Pages1100-1111
Number of pages12
Volume5
Edition11
Publication statusPublished - Jul 2012

Fingerprint

Location based services

ASJC Scopus subject areas

  • Computer Science (miscellaneous)
  • Computer Science(all)

Cite this

Aly, A. M., Aref, W. G., & Ouzzani, M. (2012). Spatial queries with two kNN predicates. In Proceedings of the VLDB Endowment (11 ed., Vol. 5, pp. 1100-1111)

Spatial queries with two kNN predicates. / Aly, Ahmed M.; Aref, Walid G.; Ouzzani, Mourad.

Proceedings of the VLDB Endowment. Vol. 5 11. ed. 2012. p. 1100-1111.

Research output: Chapter in Book/Report/Conference proceedingChapter

Aly, AM, Aref, WG & Ouzzani, M 2012, Spatial queries with two kNN predicates. in Proceedings of the VLDB Endowment. 11 edn, vol. 5, pp. 1100-1111.
Aly AM, Aref WG, Ouzzani M. Spatial queries with two kNN predicates. In Proceedings of the VLDB Endowment. 11 ed. Vol. 5. 2012. p. 1100-1111
Aly, Ahmed M. ; Aref, Walid G. ; Ouzzani, Mourad. / Spatial queries with two kNN predicates. Proceedings of the VLDB Endowment. Vol. 5 11. ed. 2012. pp. 1100-1111
@inbook{fc4e25723f354cfa9183f8ebed397a77,
title = "Spatial queries with two kNN predicates",
abstract = "The widespread use of location-aware devices has led to countless location-based services in which a user query can be arbitrarily complex, i.e., one that embeds multiple spatial selection and join predicates. Amongst these predicates, the k-Nearest-Neighbor (kNN) predicate stands as one of the most important and widely used predicates. Unlike related research, this paper goes beyond the optimization of queries with single kNN predicates, and shows how queries with two kNN predicates can be optimized. In particular, the paper addresses the optimization of queries with: (i) two kNN-select predicates, (ii) two kNN-join predicates, and (iii) one kNN-join predicate and one kNN-select predicate. For each type of queries, conceptually correct query evaluation plans (QEPs) and new algorithms that optimize the query execution time are presented. Experimental results demonstrate that the proposed algorithms outperform the conceptually correct QEPs by orders of magnitude.",
author = "Aly, {Ahmed M.} and Aref, {Walid G.} and Mourad Ouzzani",
year = "2012",
month = "7",
language = "English",
volume = "5",
pages = "1100--1111",
booktitle = "Proceedings of the VLDB Endowment",
edition = "11",

}

TY - CHAP

T1 - Spatial queries with two kNN predicates

AU - Aly, Ahmed M.

AU - Aref, Walid G.

AU - Ouzzani, Mourad

PY - 2012/7

Y1 - 2012/7

N2 - The widespread use of location-aware devices has led to countless location-based services in which a user query can be arbitrarily complex, i.e., one that embeds multiple spatial selection and join predicates. Amongst these predicates, the k-Nearest-Neighbor (kNN) predicate stands as one of the most important and widely used predicates. Unlike related research, this paper goes beyond the optimization of queries with single kNN predicates, and shows how queries with two kNN predicates can be optimized. In particular, the paper addresses the optimization of queries with: (i) two kNN-select predicates, (ii) two kNN-join predicates, and (iii) one kNN-join predicate and one kNN-select predicate. For each type of queries, conceptually correct query evaluation plans (QEPs) and new algorithms that optimize the query execution time are presented. Experimental results demonstrate that the proposed algorithms outperform the conceptually correct QEPs by orders of magnitude.

AB - The widespread use of location-aware devices has led to countless location-based services in which a user query can be arbitrarily complex, i.e., one that embeds multiple spatial selection and join predicates. Amongst these predicates, the k-Nearest-Neighbor (kNN) predicate stands as one of the most important and widely used predicates. Unlike related research, this paper goes beyond the optimization of queries with single kNN predicates, and shows how queries with two kNN predicates can be optimized. In particular, the paper addresses the optimization of queries with: (i) two kNN-select predicates, (ii) two kNN-join predicates, and (iii) one kNN-join predicate and one kNN-select predicate. For each type of queries, conceptually correct query evaluation plans (QEPs) and new algorithms that optimize the query execution time are presented. Experimental results demonstrate that the proposed algorithms outperform the conceptually correct QEPs by orders of magnitude.

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

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

M3 - Chapter

VL - 5

SP - 1100

EP - 1111

BT - Proceedings of the VLDB Endowment

ER -