An Efficient Spatial Index Technique in Main Memory Databases


The KIPS Transactions:PartD, Vol. 12, No. 4, pp. 543-552, Aug. 2005
10.3745/KIPSTD.2005.12.4.543,   PDF Download:

Abstract

As random access memory chip gets cheaper, it becomes affordable to realize main memory-based database systems. The disk-based spatial indexing techniques, however, cannot direct apply to main memory databases, because the main purpose of disk-based techniques is to reduce the number of disk accesses. In main memory-based indexing techniques, the node access time is much faster than that in disk-based indexing techniques, because all index nodes reside in a main memory. Unlike disk-based index techniques, main memory-based spatial indexing techniques must reduce key comparing time as well as node access time. In this paper, we propose an efficient spatial index structure for main memory-based databases, called Tmr-tree. Tmr-tree integrates the characteristics of R-tree and T-tree. Therefore, Nodes of Tmr-tree consist of several entries for data objects, main memory pointers to left and right child, and three additional fields. First is a MBR of a self node, which tightly encloses all data MBRs (Minimum Bounding Rectangles) in a current node, and second and third are MBRs of left and right sub-tree, respectively. Because Tmr-tree needs not to visit all leaf nodes, in terms of search time, proposed Tmr-tree outperforms R-tree in our experiments. As node size is increased, search time is drastically decreased followed by a gradual increase. However, in terms of insertion time, the performance of Tmr-tree was slightly lower than R-tree.


Statistics
Show / Hide Statistics

Statistics (Cumulative Counts from September 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article
[IEEE Style]
S. W. Yun and K. C. Kim, "An Efficient Spatial Index Technique in Main Memory Databases," The KIPS Transactions:PartD, vol. 12, no. 4, pp. 543-552, 2005. DOI: 10.3745/KIPSTD.2005.12.4.543.

[ACM Style]
Suk Woo Yun and Kyung Chang Kim. 2005. An Efficient Spatial Index Technique in Main Memory Databases. The KIPS Transactions:PartD, 12, 4, (2005), 543-552. DOI: 10.3745/KIPSTD.2005.12.4.543.