Performance Evaluation of Main-Memory R-tree Variants

作者: Sangyong Hwang , Keunjoo Kwon , Sang K. Cha , Byung S. Lee

DOI: 10.1007/978-3-540-45072-6_2

关键词:

摘要: There have been several techniques proposed for improving the performance of main-memory spatial indexes, but there has not a comparative study their performance. In this paper we compare six R-tree variants: R-tree, R*-tree, Hilbert CR-tree, CR*-tree, and CR-tree. CR*-trees CR-trees are respectively natural extension R*-trees R-trees by incorporating CR-trees’ quantized relative minimum bounding rectangle (QRMBR) technique. Additionally, apply optimistic, latch-free index traversal (OLFIT) concurrency control mechanism B-trees to variants while using GiST-link We perform extensive experiments in two categories sequential accesses concurrent accesses, pick following best trees. search, update, mixture them. search if data is uniformly distributed, skewed, also provide detailed observations experimental results, rationalize them based on characteristics individual As far as know, our work first comprehensive variants. The results useful guideline selecting most suitable structure various cases.

参考文章(14)
Ibrahim Kamel, Christos Faloutsos, Hilbert R-tree: An Improved R-tree using Fractals very large data bases. pp. 500- 509 ,(1994)
Marcel Kornacker, C. Mohan, Joseph M. Hellerstein, Concurrency and recovery in generalized search trees international conference on management of data. ,vol. 26, pp. 62- 72 ,(1997) , 10.1145/253260.253272
R. Bayer, M. Schkolnick, Concurrency of operations on B —trees Acta Informatica. ,vol. 9, pp. 216- 226 ,(1994) , 10.1007/BF00263762
Kihong Kim, Sang K. Cha, Keunjoo Kwon, Optimizing multidimensional index trees for main memory access international conference on management of data. ,vol. 30, pp. 139- 150 ,(2001) , 10.1145/375663.375679
Yasushi Sakurai, Masatoshi Yoshikawa, Shunsuke Uemura, Haruhiko Kojima, Spatial indexing of high-dimensional data based on relative approximation The VLDB Journal The International Journal on Very Large Data Bases. ,vol. 11, pp. 93- 108 ,(2002) , 10.1007/S00778-002-0066-9
Shimin Chen, Phillip B. Gibbons, Todd C. Mowry, Improving index performance through prefetching international conference on management of data. ,vol. 30, pp. 235- 246 ,(2001) , 10.1145/375663.375688
Philip L. Lehman, s. Bing Yao, Efficient locking for concurrent operations on B-trees ACM Transactions on Database Systems. ,vol. 6, pp. 650- 670 ,(1981) , 10.1145/319628.319663
Antonin Guttman, R-trees Proceedings of the 1984 ACM SIGMOD international conference on Management of data - SIGMOD '84. ,vol. 14, pp. 47- 57 ,(1984) , 10.1145/602259.602266
Sang K. Cha, Kihong Kim, Sangyong Hwang, Keunjoo Kwon, Cache-Conscious Concurrency Control of Main-Memory Indexes on Shared-Memory Multiprocessor Systems very large data bases. pp. 181- 190 ,(2001)
Juchang Lee, Kihong Kim, S.K. Cha, Differential logging: a commutative and associative logging scheme for highly parallel main memory database international conference on data engineering. pp. 173- 182 ,(2001) , 10.1109/ICDE.2001.914826