Abstract
As random access memory chips get cheaper, it becomes affordable to realize main memory-based database systems. The most important issues in main memory database indexing techniques for mobile GIS applications are to improve update performances – since numerous update operations can arise for tracking continuously moving objects – and to reduce cache misses for improving search performances. In this paper, we propose MR-tree, a cache-conscious version of the R-tree for main memory databases. To increase fan-out, the MR-tree applies a novel compression scheme to entry MBRs (Minimum Bounding Rectangles). This scheme represents entry MBRs by relative coordinates in a node. To improve update performance, the MR-tree can become an unbalanced tree as follows: it propagates node splits upward only if one of the internal nodes on the insertion path has empty space, or all height differences between the consecutive nodes on the insertion path are 1 and one of the height differences among its subtrees is equal to some unbalance parameter. Because of this feature, the MR-tree can reduce the number of internal nodes splits and reinsertions significantly. In the case where all internal nodes on the insertion path do not meet the above conditions, a newly created leaf node simply becomes the child of the split leaf, when a leaf node split occurs. This split leaf is called the half-leaf node. Our experimental result shows that the search speed of the proposed two-dimensional MR-tree increases by almost a factor of two compared to the CR-tree and the R-tree variant, which are also main memory based R-trees, while maintaining better update performance.
This work is supported by KOSEF grant # R01-2001-000-00540-0 (2003).
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Kim, K., Cha, S.K., Kwon, K.: Optimizing Multidimensional Index Trees for Main Memory Access. In: Proceedings of ACM SIGMOD Conference, pp. 139–150 (2001)
Kwon, D., Lee, S.J., Lee, S.: Indexing the current positions of moving objects using the lazy update R-tree. In: 3rd International Conference on Mobile Data Management (January 2002)
Bones, P., Manegold, S., Kersten, M.: Database Architecture Optimized for the New Bottleneck: Memory Access. In: Proceedings of VLDB Conference, pp. 54–65 (1999)
Ailamaki, A., DeWitt, D.J., Hill, M.D., Wood, D.A.: DBMSs on a Modern Processor: Where Does Time Go? In: Proceedings of VLDB Conference, pp. 267–277 (1999)
Rao, J., Ross, K.A.: Cache Conscious Indexing for Decision-support in Main Memory. In: Proceedings of VLDB Conference, pp. 78–89 (1999)
Rao, J., Ross, K.A.: Making B+-trees Cache Conscious in Main Memory. In: Proceedings of ACM SIGMOD Conference, pp. 475–486 (2000)
Guttman, A.: R-tree: A Dynamic Index Structure for Spatial Searching. In: Proceedings of ACM SIGMOD Conference, pp. 47–57 (1984)
Beckmann, N., Kriegel, H.-P., Schneider, R., Seeger, B.: The R*-tree: An Efficient and Robust Access Method for Points and Rectangles. In: Proceedings of ACM SIGMOD Conference, pp. 322–331 (1990)
Kamel, I., Faloutsos, C.: Hilbert R-tree: An Improved R-tree Using Fractals. In: Proceedings of VLDB Conference, pp. 500–509 (1994)
Bernstein, P., et al.: The Asilomar report on database research. SIGMOD Records 27(4) (1998)
Wolfson, O., Xu, B., Chamberlaina, S., Jiang, L.: Moving objects databases: Issues and solutions. In: Proc. of the 10th Int’l. Conf. on Scientific and Statistical Database Management, pp. 111–122 (1998)
Xia, Y., Prabhakar, S.: Q+Rtree: Efficient Indexing for Moving Object Databases. In: Proc. of 8th Int’l. Conf. on Database Systems for Advanced Applications, DASFAA (2003)
Gaede, V., Gunher, O.: Multidimensional access methods. ACM Computing Surveys, 170–231 (1998)
Kanth, R., Kothuri, V., Ravada, S., Abugov, D.: Quadtree and R-tree indexes in oracle spatial: a comparison using GIS data. In: Proceedings of ACM SIGMOD Conference (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kim, KC., Yun, SW. (2005). MR-Tree: A Cache-Conscious Main Memory Spatial Index Structure for Mobile GIS. In: Kwon, YJ., Bouju, A., Claramunt, C. (eds) Web and Wireless Geographical Information Systems. W2GIS 2004. Lecture Notes in Computer Science, vol 3428. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11427865_13
Download citation
DOI: https://doi.org/10.1007/11427865_13
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-26004-2
Online ISBN: 978-3-540-31964-1
eBook Packages: Computer ScienceComputer Science (R0)