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 条
  • [1] Selectivity estimation for spatial joins
    An, N
    Yang, ZY
    Sivasubramaniam, A
    17TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2001, : 368 - 375
  • [2] Efficient selectivity estimation for distance joins
    Xiong, Wei
    Zhang, Ju
    Jing, Ning
    Chen, Hong-Sheng
    Guofang Keji Daxue Xuebao/Journal of National University of Defense Technology, 2004, 26 (06): : 82 - 85
  • [3] Selectivity Estimation of Inequality Joins in Databases
    Repas, Diogo
    Luo, Zhicheng
    Schoemans, Maxime
    Sakr, Mahmoud
    MATHEMATICS, 2023, 11 (06)
  • [4] Fast computation of spatial selections and joins using graphics hardware
    Bandi, Nagender
    Sun, Chengyu
    Agrawal, Divyakant
    El Abbadia, Amr
    INFORMATION SYSTEMS, 2007, 32 (08) : 1073 - 1100
  • [5] Selectivity Estimation for Relation-Tree Joins
    Zhang, Chao
    Lu, Jiaheng
    PROCEEDINGS OF THE 32TH INTERNATIONAL CONFERENCE ON SCIENTIFIC AND STATISTICAL DATABASE MANAGEMENT, SSDBM 2020, 2020,
  • [6] Selectivity estimation for joins using systematic sampling
    Harangsri, B
    Shepherd, J
    Ngu, A
    EIGHTH INTERNATIONAL WORKSHOP ON DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 1997, : 384 - 389
  • [7] Selectivity and cost estimation for joins based on random sampling
    Haas, PJ
    Naughton, JF
    Seshadri, S
    Swami, AN
    JOURNAL OF COMPUTER AND SYSTEM SCIENCES, 1996, 52 (03) : 550 - 569
  • [8] Selectivity estimation in spatial databases
    Acharya, S
    Poosala, V
    Ramaswamy, S
    SIGMOD RECORD, VOL 28, NO 2 - JUNE 1999: SIGMOD99: PROCEEDINGS OF THE 1999 ACM SIGMOD - INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 1999, : 13 - 24
  • [9] Selectivity Estimation in Spatial Networks
    Tiakas, E.
    Papadopoulos, A. N.
    Nanopoulos, A.
    Manolopoulos, Y.
    APPLIED COMPUTING 2008, VOLS 1-3, 2008, : 852 - 856