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 条
  • [41] Self-spatial join selectivity estimation using fractal concepts
    Belussi, A
    Faloutsos, C
    ACM TRANSACTIONS ON INFORMATION SYSTEMS, 1998, 16 (02) : 161 - 201
  • [42] An efficient selectivity estimation method for spatial query optimization with topological relationships
    CHUNG Warn ill
    CHOI Jun ho
    BAE Hae young
    重庆邮电学院学报(自然科学版), 2004, (05) : 113 - 120
  • [43] Generic cumulative annular bucket histogram for spatial selectivity estimation of spatial database management system
    Cheng, Changxiu
    Song, Xiaomei
    Zhou, Chenghu
    INTERNATIONAL JOURNAL OF GEOGRAPHICAL INFORMATION SCIENCE, 2013, 27 (02) : 339 - 362
  • [44] Benchmarking spatial joins A La Carte
    Gunther, O
    Oria, V
    Picouet, P
    Saglio, JM
    Scholl, M
    TENTH INTERNATIONAL CONFERENCE ON SCIENTIFIC AND STATISTICAL DATABASE MANAGEMENT - PROCEEDINGS, 1998, : 32 - 41
  • [45] Joins via Geometric Resolutions: Worst Case and Beyond
    Khamis, Mahmoud Abo
    Ngo, Hung Q.
    Re, Christopher
    Rudra, Atri
    ACM TRANSACTIONS ON DATABASE SYSTEMS, 2016, 41 (04):
  • [46] Optimization of spatial joins on mobile devices
    Mamoulis, N
    Kalnis, P
    Bakiras, S
    Li, XC
    ADVANCES IN SPATIAL AND TEMPORAL DATABASES, PROCEEDINGS, 2003, 2750 : 233 - 251
  • [47] Optimization of spatial joins using filters
    Veenhof, HM
    Apers, PMG
    Houtsma, MAW
    ADVANCES IN DATABASES, 1995, 940 : 136 - 154
  • [48] Managing Spatial Selections With Contextual Snapshots
    Mindek, P.
    Groeller, M. E.
    Bruckner, S.
    COMPUTER GRAPHICS FORUM, 2014, 33 (08) : 132 - 144
  • [49] Improvement of Join Algorithms for Low-Selectivity Joins on MapReduce
    Matono, Akiyoshi
    Ogawa, Hirotaka
    Kojima, Isao
    DATABASES THEORY AND APPLICATIONS, 2015, 9093 : 117 - 128
  • [50] Top-k spatial distance joins
    Qi, Shuyao
    Bouros, Panagiotis
    Mamoulis, Nikos
    GEOINFORMATICA, 2020, 24 (03) : 591 - 631