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 条
  • [41] Efficient and adaptive processing of multiple continuous queries
    Tok, WH
    Bressan, S
    [J]. ADVANCES IN DATABASE TECHNOLOGY - EDBT 2002, 2002, 2287 : 215 - 232
  • [42] Distributed approach of continuous queries with KNN join processing in spatial data warehouse
    Gorawski, Marcin
    Gebczyk, Wojciech
    [J]. ICEIS 2007: PROCEEDINGS OF THE NINTH INTERNATIONAL CONFERENCE ON ENTERPRISE INFORMATION SYSTEMS: DATABASES AND INFORMATION SYSTEMS INTEGRATION, 2007, : 131 - 136
  • [43] Presenting a New Method for Optimizing Join Queries Processing in Heterogeneous Distributed Databases
    Zafarani, Elnaz
    Derakhshi, Mohammad Reza Feizi
    Asil, Hasan
    Asil, Amir
    [J]. THIRD INTERNATIONAL CONFERENCE ON KNOWLEDGE DISCOVERY AND DATA MINING: WKDD 2010, PROCEEDINGS, 2010, : 379 - 382
  • [44] Processing sliding window join aggregate in continuous queries over data streams
    Wang, WP
    Li, JZ
    Zhang, DD
    Guo, LJ
    [J]. ADVANCES IN DATABASES AND INFORMATION SYSTEMS, PROCEEDINGS, 2004, 3255 : 348 - 363
  • [45] Efficient Processing of Skyline-Join Queries over Multiple Data Sources
    Nagendra, Mithila
    Candan, K. Selcuk
    [J]. ACM TRANSACTIONS ON DATABASE SYSTEMS, 2015, 40 (02):
  • [46] Realization of continuous queries with NN join processing in spatial telemetric data warehouse
    Gorawski, Marcin
    Gebczyk, Wojciech
    [J]. SEVENTEENTH INTERNATIONAL CONFERENCE ON DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 2006, : 632 - +
  • [47] Integrity for Join Queries in the Cloud
    di Vimercati, Sabrina De Capitani
    Foresti, Sara
    Jajodia, Sushil
    Paraboschi, Stefano
    Samarati, Pierangela
    [J]. IEEE TRANSACTIONS ON CLOUD COMPUTING, 2013, 1 (02) : 187 - 200
  • [48] Adaptive Algorithms for Join Processing in Distributed Database Systems
    Peter Scheuermann
    Eugene Inseok Chong
    [J]. Distributed and Parallel Databases, 1997, 5 : 233 - 269
  • [49] Tie-breaking strategies for fast distance join processing
    Shin, H
    Moon, B
    Lee, S
    [J]. DATA & KNOWLEDGE ENGINEERING, 2002, 41 (01) : 67 - 83
  • [50] Adaptive Multi-Join Query Processing in PDBMS
    Wu, Sai
    Vu, Quang Hieu
    Li, Hanzhong
    Tan, Kian-Lee
    [J]. ICDE: 2009 IEEE 25TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, VOLS 1-3, 2009, : 1239 - +