Selectivity estimation for spatial joins with geometric selections

Chengyu Sun, Divyakant Agrawal, Amr El Abbadi

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

25 Citations (Scopus)

Abstract

Spatial join is an expensive operation that is commonly used in spatial database systems. In order to generate efficient query plans for the queries involving spatial join operations, it is crucial to obtain accurate selectivity estimates for these operations. In this paper we introduce a framework for estimating the selectivity of spatial joins constrained by geometric selections. The center piece of the framework is Euler Histogram, which decomposes the estimation process into estimations on vertices, edges and faces. Based on the characteristics of different datasets, different probabilistic models can be plugged into the framework to provide better estimation results. To demonstrate the effectiveness of this framework, we implement it by incorporating two existing probabilistic models, and compare the performance with the Geometric Histogram [1] and the algorithm recently proposed by Mamoulis and Papadias [2].

Original languageEnglish
Title of host publicationLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Pages609-626
Number of pages18
Volume2287 LNCS
Publication statusPublished - 1 Dec 2002
Externally publishedYes
Event8th International Conference on Extending Database Technology, EDBT 2002 - Prague, Czech Republic
Duration: 25 Mar 200227 Mar 2002

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume2287 LNCS
ISSN (Print)03029743
ISSN (Electronic)16113349

Other

Other8th International Conference on Extending Database Technology, EDBT 2002
CountryCzech Republic
CityPrague
Period25/3/0227/3/02

Fingerprint

Selectivity
Join
Probabilistic Model
Histogram
Query
Spatial Database
Database Systems
Euler
Face
Decompose
Framework
Estimate
Demonstrate
Statistical Models

ASJC Scopus subject areas

  • Computer Science(all)
  • Theoretical Computer Science

Cite this

Sun, C., Agrawal, D., & El Abbadi, A. (2002). Selectivity estimation for spatial joins with geometric selections. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (Vol. 2287 LNCS, pp. 609-626). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 2287 LNCS).

Selectivity estimation for spatial joins with geometric selections. / Sun, Chengyu; Agrawal, Divyakant; El Abbadi, Amr.

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 2287 LNCS 2002. p. 609-626 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 2287 LNCS).

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

Sun, C, Agrawal, D & El Abbadi, A 2002, Selectivity estimation for spatial joins with geometric selections. in Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). vol. 2287 LNCS, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 2287 LNCS, pp. 609-626, 8th International Conference on Extending Database Technology, EDBT 2002, Prague, Czech Republic, 25/3/02.
Sun C, Agrawal D, El Abbadi A. Selectivity estimation for spatial joins with geometric selections. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 2287 LNCS. 2002. p. 609-626. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
Sun, Chengyu ; Agrawal, Divyakant ; El Abbadi, Amr. / Selectivity estimation for spatial joins with geometric selections. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 2287 LNCS 2002. pp. 609-626 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
@inproceedings{7f8763edb5e64dffad6730d61cb7cd1e,
title = "Selectivity estimation for spatial joins with geometric selections",
abstract = "Spatial join is an expensive operation that is commonly used in spatial database systems. In order to generate efficient query plans for the queries involving spatial join operations, it is crucial to obtain accurate selectivity estimates for these operations. In this paper we introduce a framework for estimating the selectivity of spatial joins constrained by geometric selections. The center piece of the framework is Euler Histogram, which decomposes the estimation process into estimations on vertices, edges and faces. Based on the characteristics of different datasets, different probabilistic models can be plugged into the framework to provide better estimation results. To demonstrate the effectiveness of this framework, we implement it by incorporating two existing probabilistic models, and compare the performance with the Geometric Histogram [1] and the algorithm recently proposed by Mamoulis and Papadias [2].",
author = "Chengyu Sun and Divyakant Agrawal and {El Abbadi}, Amr",
year = "2002",
month = "12",
day = "1",
language = "English",
isbn = "3540433244",
volume = "2287 LNCS",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
pages = "609--626",
booktitle = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

}

TY - GEN

T1 - Selectivity estimation for spatial joins with geometric selections

AU - Sun, Chengyu

AU - Agrawal, Divyakant

AU - El Abbadi, Amr

PY - 2002/12/1

Y1 - 2002/12/1

N2 - Spatial join is an expensive operation that is commonly used in spatial database systems. In order to generate efficient query plans for the queries involving spatial join operations, it is crucial to obtain accurate selectivity estimates for these operations. In this paper we introduce a framework for estimating the selectivity of spatial joins constrained by geometric selections. The center piece of the framework is Euler Histogram, which decomposes the estimation process into estimations on vertices, edges and faces. Based on the characteristics of different datasets, different probabilistic models can be plugged into the framework to provide better estimation results. To demonstrate the effectiveness of this framework, we implement it by incorporating two existing probabilistic models, and compare the performance with the Geometric Histogram [1] and the algorithm recently proposed by Mamoulis and Papadias [2].

AB - Spatial join is an expensive operation that is commonly used in spatial database systems. In order to generate efficient query plans for the queries involving spatial join operations, it is crucial to obtain accurate selectivity estimates for these operations. In this paper we introduce a framework for estimating the selectivity of spatial joins constrained by geometric selections. The center piece of the framework is Euler Histogram, which decomposes the estimation process into estimations on vertices, edges and faces. Based on the characteristics of different datasets, different probabilistic models can be plugged into the framework to provide better estimation results. To demonstrate the effectiveness of this framework, we implement it by incorporating two existing probabilistic models, and compare the performance with the Geometric Histogram [1] and the algorithm recently proposed by Mamoulis and Papadias [2].

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

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

M3 - Conference contribution

SN - 3540433244

SN - 9783540433248

VL - 2287 LNCS

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 609

EP - 626

BT - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

ER -