The RUM-tree: supporting frequent updates in R-trees using memos

被引:0
|
作者
Yasin N. Silva
Xiaopeng Xiong
Walid G. Aref
机构
[1] Purdue University,Department of Computer Sciences
来源
The VLDB Journal | 2009年 / 18卷
关键词
Indexing techniques; Frequent updates; Spatio-temporal databases; Performance;
D O I
暂无
中图分类号
学科分类号
摘要
The problem of frequently updating multi-dimensional indexes arises in many location-dependent applications. While the R-tree and its variants are the dominant choices for indexing multi-dimensional objects, the R-tree exhibits inferior performance in the presence of frequent updates. In this paper, we present an R-tree variant, termed the RUM-tree (which stands for R-tree with update memo) that reduces the cost of object updates. The RUM-tree processes updates in a memo-based approach that avoids disk accesses for purging old entries during an update process. Therefore, the cost of an update operation in the RUM-tree is reduced to the cost of only an insert operation. The removal of old object entries is carried out by a garbage cleaner inside the RUM-tree. In this paper, we present the details of the RUM-tree and study its properties. We also address the issues of crash recovery and concurrency control for the RUM-tree. Theoretical analysis and comprehensive experimental evaluation demonstrate that the RUM-tree outperforms other R-tree variants by up to one order of magnitude in scenarios with frequent updates.
引用
收藏
页码:719 / 738
页数:19
相关论文
共 33 条
  • [1] The RUM-tree: supporting frequent updates in R-trees using memos
    Silva, Yasin N.
    Xiong, Xiaopeng
    Aref, Walid G.
    [J]. VLDB JOURNAL, 2009, 18 (03): : 719 - 738
  • [2] Managing Frequent Updates in R-Trees for Update-Intensive Applications
    Song, MoonBae
    Kitagawa, Hiroyuki
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2009, 21 (11) : 1573 - 1589
  • [3] The LSM RUM-Tree: A Log Structured Merge R-Tree for Update-intensive Spatial Workloads
    Shin, Jaewoo
    Wang, Jianguo
    Aref, Walid G.
    [J]. 2021 IEEE 37TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE 2021), 2021, : 2285 - 2290
  • [4] Incorporating updates in domain indexes: Experiences with oracle spatial R-trees
    Kothuri, RKV
    Ravada, S
    An, N
    [J]. 20TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2004, : 745 - 753
  • [5] A performance comparison among the traditional R-trees, the Hilbert R-tree and the SR-tree
    Ciferri, RR
    Salgado, AC
    Nascimento, MA
    Magalhaes, GC
    [J]. SCCC 2003: XXIII INTERNATIONAL CONFERENCE OF THE CHILEAN COMPUTER SCIENCE SOCIETY, PROCEEDINGS, 2003, : 3 - 12
  • [6] Parallel processing of spatial joins using R-trees
    Brinkhoff, T
    Kriegel, HP
    Seeger, B
    [J]. PROCEEDINGS OF THE TWELFTH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, 1996, : 258 - 265
  • [7] Efficient processing of direction joins using R-trees
    Xiao, YQ
    Li, ZH
    Jing, N
    [J]. PROCEEDINGS OF THE 2003 IEEE INTERNATIONAL CONFERENCE ON INFORMATION REUSE AND INTEGRATION, 2003, : 104 - 111
  • [8] Hierarchical indexing using R-trees for replica detection
    Maret, Yannick
    Marimon, David
    Dufaux, Frederic
    Ebrahimi, Touradj
    [J]. APPLICATIONS OF DIGITAL IMAGE PROCESSING XXIX, 2006, 6312
  • [9] Efficient cost models for spatial queries using R-trees
    Theodoridis, Y
    Stefanakis, E
    Sellis, T
    [J]. IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2000, 12 (01) : 19 - 32
  • [10] Cost models for distance joins queries using R-trees
    Corral, A
    Manolopoulos, Y
    Theodoridis, Y
    Vassilakopoulos, M
    [J]. DATA & KNOWLEDGE ENGINEERING, 2006, 57 (01) : 1 - 36