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 条
  • [21] Multiway spatial joins
    Mamoulis, N
    Papadias, D
    ACM TRANSACTIONS ON DATABASE SYSTEMS, 2001, 26 (04): : 424 - 475
  • [22] A panorama on multiscale geometric representations, intertwining spatial, directional and frequency selectivity
    Jacques, Laurent
    Duval, Laurent
    Chaux, Caroline
    Peyre, Gabriel
    SIGNAL PROCESSING, 2011, 91 (12) : 2699 - 2730
  • [23] The selectivity estimation of spatial query based on simple polygon
    Guo, P
    Chen, HZ
    Chen, ZL
    PROCEEDINGS OF THE 11TH JOINT INTERNATIONAL COMPUTER CONFERENCE, 2005, : 670 - 673
  • [24] CDB: Optimizing Queries with Crowd-Based Selections and Joins
    Li, Guoliang
    Chai, Chengliang
    Fan, Ju
    Weng, Xueping
    Li, Jian
    Zheng, Yudian
    Li, Yuanbing
    Yu, Xiang
    Zhang, Xiaohang
    Yuan, Haitao
    SIGMOD'17: PROCEEDINGS OF THE 2017 ACM INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2017, : 1463 - 1478
  • [25] Efficient dynamic programming algorithms for ordering expensive joins and selections
    Scheufele, W
    Moerkotte, G
    ADVANCES IN DATABASE TECHNOLOGY - EDBT'98, 1998, 1377 : 201 - 215
  • [26] Spatial selectivity estimation using compressed histogram information
    Chi, JH
    Kim, SH
    Ryu, KH
    WEB TECHNOLOGIES RESEARCH AND DEVELOPMENT - APWEB 2005, 2005, 3399 : 489 - 494
  • [27] ESTIMATION OF SPATIAL DISTORTION AS A FUNCTION OF GEOMETRIC PARAMETERS OF PERSPECTIVE
    ROSENBERG, C
    BARFIELD, W
    IEEE TRANSACTIONS ON SYSTEMS MAN AND CYBERNETICS, 1995, 25 (09): : 1323 - 1333
  • [28] Toward spatial joins for polygons
    Zhu, HJ
    Su, JW
    Ibarra, OH
    12TH INTERNATIONAL CONFERENCE ON SCIENTIFIC AND STATISTICAL DATABASE MANAGEMENT, PROCEEDINGS, 2000, : 231 - 244
  • [29] Federating datasets with spatial joins
    Page, CG
    ASTRONOMICAL DATA ANALYSIS SOFTWARE AND SYSTEMS XIII, 2004, 314 : 189 - 192
  • [30] Caching strategies for spatial joins
    Abel D.J.
    Gaede V.
    Power R.A.
    Zhou X.
    GeoInformatica, 1999, 3 (1) : 33 - 59