Selectivity estimation for spatial joins with geometric selections

被引:0
|
作者
Sun, C [1 ]
Agrawal, D [1 ]
El Abbadi, A [1 ]
机构
[1] Univ Calif Santa Barbara, Dept Comp Sci, Santa Barbara, CA 93106 USA
关键词
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
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].
引用
收藏
页码:609 / 626
页数:18
相关论文
共 50 条
  • [31] Indexing support for spatial joins
    Koudas, N
    DATA & KNOWLEDGE ENGINEERING, 2000, 34 (02) : 99 - 124
  • [32] Mixing selections and foreign key joins in queries against possibilistic databases
    Bosc, P
    Pivert, O
    FOUNDATIONS OF INTELLIGENT SYSTEMS, PROCEEDINGS, 2002, 2366 : 194 - 202
  • [33] Node and edge selectivity estimation for range queries in spatial networks
    Tiakas, E.
    Papadopoulos, A. N.
    Nanopoulos, A.
    Manolopoulos, Y.
    INFORMATION SYSTEMS, 2009, 34 (03) : 328 - 352
  • [34] Spatial selectivity estimation using cumulative density wavelet histogram
    Cho, Byung Kyu
    ADVANCED INTELLIGENT COMPUTING THEORIES AND APPLICATIONS, PROCEEDINGS: WITH ASPECTS OF ARTIFICIAL INTELLIGENCE, 2007, 4682 : 493 - 504
  • [35] Top-k spatial joins
    Zhu, ML
    Papadias, D
    Zhang, J
    Lee, DL
    IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2005, 17 (04) : 567 - 579
  • [36] Search algorithms for mutiway spatial joins
    Papadias, D
    Arkoumanis, D
    INTERNATIONAL JOURNAL OF GEOGRAPHICAL INFORMATION SCIENCE, 2002, 16 (07) : 613 - 639
  • [37] Benchmarking spatial joins a la carte
    Günther, O
    Picouet, P
    Saglio, JM
    Scholl, M
    Oria, V
    INTERNATIONAL JOURNAL OF GEOGRAPHICAL INFORMATION SCIENCE, 1999, 13 (07) : 639 - 655
  • [38] Parallel Selectivity Estimation for Optimizing Multidimensional Spatial Join Processing on GPUs
    Zhang, Jianting
    You, Simin
    Gruenwald, Le
    2017 IEEE 33RD INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2017), 2017, : 1591 - 1598
  • [39] Euler plus plus : Improved Selectivity Estimation for Rectangular Spatial Records
    Siddique, A. B.
    Eldawy, Ahmed
    Hristidis, Vagelis
    2019 IEEE INTERNATIONAL CONFERENCE ON BIG DATA (BIG DATA), 2019, : 4129 - 4133
  • [40] Spatial joins and R-trees
    Martynov, MG
    ADVANCES IN DATABASES AND INFORMATION SYSTEMS, 1996, : 295 - 304