Adaptive and incremental processing for distance join queries

被引:11
|
作者
Shin, H
Moon, B
Lee, S
机构
[1] Samsung Elect, Software Ctr, Seoul 135120, South Korea
[2] Univ Arizona, Dept Comp Sci, Tucson, AZ 85721 USA
[3] Seoul Natl Univ, Sch Comp Sci & Engn, Seoul 151742, South Korea
关键词
spatial databases; k-distance join; incremental distance join; adaptive query processing; multistage query processing; plane sweeping; sweeping index; estimating cutoff distance;
D O I
10.1109/TKDE.2003.1245293
中图分类号
TP18 [人工智能理论];
学科分类号
081104 ; 0812 ; 0835 ; 1405 ;
摘要
A spatial distance join is a relatively new type of operation introduced for spatial and multimedia database applications. Additional requirements for ranking and stopping cardinality are often combined with the spatial distance join in online query processing or Internet search environments. These requirements pose new challenges as well as opportunities for more efficient processing of spatial distance join queries. In this paper, we first present an efficient k-distance join algorithm that uses spatial indexes such as R-trees. Bidirectional node expansion and plane-sweeping techniques are used for fast pruning of distant pairs, and the plane-sweeping is further optimized by novel strategies for selecting a sweeping axis and direction. Furthermore, we propose adaptive multistage algorithms for k-distance join and incremental distance join operations. Our performance study shows that the proposed adaptive multistage algorithms outperform previous work by up to an order of magnitude for both k-distance join and incremental distance join queries, under various operational conditions.
引用
收藏
页码:1561 / 1578
页数:18
相关论文
共 50 条
  • [1] Processing distance join queries with constraints
    Papadopoulos, AN
    Nanopoulos, A
    Manolopoulos, Y
    [J]. COMPUTER JOURNAL, 2006, 49 (03): : 281 - 296
  • [2] Efficient Parallel Processing of Distance Join Queries Over Distributed Graphs
    Zhang, Xiaofei
    Chen, Lei
    Wang, Min
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2015, 27 (03) : 740 - 754
  • [3] Adaptive multi-stage distance join processing
    Shin, HS
    Moon, B
    Lee, S
    [J]. SIGMOD RECORD, 2000, 29 (02) : 343 - 354
  • [4] A Comparison of Distributed Spatial Data Management Systems for Processing Distance Join Queries
    Garcia-Garcia, Francisco
    Corral, Antonio
    Iribarne, Luis
    Mavrommatis, George
    Vassilakopoulos, Michael
    [J]. ADVANCES IN DATABASES AND INFORMATION SYSTEMS, ADBIS 2017, 2017, 10509 : 214 - 228
  • [5] Incremental processing for string similarity join
    Yan, Cairong
    Zhu, Bin
    Gan, Yanglan
    Xu, Guangwei
    [J]. INTERNATIONAL JOURNAL OF COMPUTATIONAL SCIENCE AND ENGINEERING, 2019, 20 (02) : 255 - 268
  • [6] Adaptive Optimization of Very Large Join Queries
    Neumann, Thomas
    Radke, Bernhard
    [J]. SIGMOD'18: PROCEEDINGS OF THE 2018 INTERNATIONAL CONFERENCE ON MANAGEMENT OF DATA, 2018, : 677 - 692
  • [7] Fast Processing of Join Queries with Instant Response
    Hamdi, Mohammed
    Yu, Feng
    Hou, Wen-Chi
    [J]. 2017 COMPUTING CONFERENCE, 2017, : 352 - 362
  • [8] Secure mediation of join queries by processing ciphertexts
    Biskup, Joachim
    Tsatedem, Christian
    Wiese, Lena
    [J]. 2007 IEEE 23RD INTERNATIONAL CONFERENCE ON DATA ENGINEERING WORKSHOP, VOLS 1-2, 2007, : 715 - 724
  • [9] Processing Top-k Join Queries
    Wu, Minji
    Berti-Equille, Laure
    Marian, Amelie
    Procopiuc, Cecilia M.
    Srivastava, Divesh
    [J]. PROCEEDINGS OF THE VLDB ENDOWMENT, 2010, 3 (01): : 860 - 870
  • [10] Efficient processing of multiple structural join queries
    Subramanyam, GV
    Kumar, PS
    [J]. KEY TECHNOLOGIES FOR DATA MANAGEMENT, 2004, 3112 : 112 - 123