Graph partition based multi-way spatial joins

被引:0
|
作者
Lin, XM [1 ]
Lu, HX [1 ]
Zhang, Q [1 ]
机构
[1] Univ New S Wales, Sch Engn & Comp Sci, Sydney, NSW 2052, Australia
关键词
spatial databases; spatial joins; query processing;
D O I
10.1109/IDEAS.2002.1029653
中图分类号
TP3 [计算技术、计算机技术];
学科分类号
0812 ;
摘要
In this paper we investigate the problem of efficiently computing a multi-way spatial join without spatial indexes. We propose a novel and effective filtering algorithm based on a two phase partitioning technique. To avoid missing hits due to an inherent difficulty in multi-way spatial joins, we propose to firstly partition a join graph into sub-graphs whenever necessary. In the second phase, we partition the spatial data sets; and then the sub-joins will be executed simultaneously in each partition to minimise the I/O costs. Finally, a multi-way relational join will be applied to merge together the sub-join results. Our experiment results demonstrated the effectiveness and efficiency of the proposed algorithm.
引用
收藏
页码:23 / 32
页数:10
相关论文
共 50 条
  • [1] On multi-way spatial joins with direction predicates
    Zhu, HJ
    Su, JW
    Ibarra, OH
    [J]. ADVANCES IN SPATIAL AND TEMPORAL DATABASES, PROCEEDINGS, 2001, 2121 : 217 - 235
  • [2] On estimating result sizes of multi-way spatial joins
    Park, HH
    [J]. COMPUTATIONAL SCIENCE AND ITS APPLICATIONS - ICCA 2003, PT 3, PROCEEDINGS, 2003, 2669 : 856 - 865
  • [3] Optimizing Multi-Way Spatial Joins of Web Feature Services
    Lan, Guiwen
    Zhang, Qiang
    Yang, Zhao
    Li, Tong
    [J]. ISPRS INTERNATIONAL JOURNAL OF GEO-INFORMATION, 2017, 6 (04)
  • [4] Are Multi-way Joins Actually Useful?
    Henderson, Michael
    Lawrence, Ramon
    [J]. ICEIS: PROCEEDINGS OF THE 15TH INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS, VOL 1, 2013, : 13 - 22
  • [5] Accelerating multi-way joins on the GPU
    Zhuohang Lai
    Xibo Sun
    Qiong Luo
    Xiaolong Xie
    [J]. The VLDB Journal, 2022, 31 : 529 - 553
  • [6] Accelerating multi-way joins on the GPU
    Lai, Zhuohang
    Sun, Xibo
    Luo, Qiong
    Xie, Xiaolong
    [J]. VLDB JOURNAL, 2022, 31 (03): : 529 - 553
  • [7] Optimizing Multiple Multi-Way Stream Joins
    Dossinger, Manuel
    Michel, Sebastian
    [J]. 2021 IEEE 37TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2021), 2021, : 1985 - 1990
  • [8] Multi-way spatial join selectivity for the ring join graph
    Min, JK
    Park, HH
    Chung, CW
    [J]. INFORMATION AND SOFTWARE TECHNOLOGY, 2005, 47 (12) : 785 - 795
  • [9] Faster joins, self-joins and multi-way joins using join indices
    Lei, H
    Ross, KA
    [J]. DATA & KNOWLEDGE ENGINEERING, 1999, 29 (02) : 179 - 200
  • [10] Faster joins, self-joins and multi-way joins using join indices
    Lei, H
    Ross, KA
    [J]. DATA & KNOWLEDGE ENGINEERING, 1998, 28 (03) : 277 - 298