Copyright © 2008 The Institute of Electronics, Information and Communication Engineers
Regular Section -- Papers -- Database |
The Optimization of In-Memory Space Partitioning Trees for Cache Utilization
1 The authors are with the Department of Computer and Communication Engineering, Chungbuk National University, Cheongju, Korea. E-mail: yjs{at}cbnu.ac.kr, 2 The author is with Electronics and Telecommunications Research Institute (ETRI), Daejeon, Korea., 3 The author is with Korea Advanced Institute of Science and Technology (KAIST), Daejeon, Korea.
| Abstract |
|---|
In this paper, a novel cache conscious indexing technique based on space partitioning trees is proposed. Many researchers investigated efficient cache conscious indexing techniques which improve retrieval performance of in-memory database management system recently. However, most studies considered data partitioning and targeted fast information retrieval. Existing data partitioning-based index structures significantly degrade performance due to the redundant accesses of overlapped spaces. Specially, R-tree-based index structures suffer from the propagation of MBR (Minimum Bounding Rectangle) information by updating data frequently. In this paper, we propose an in-memory space partitioning index structure for optimal cache utilization. The proposed index structure is compared with the existing index structures in terms of update performance, insertion performance and cache-utilization rate in a variety of environments. The results demonstrate that the proposed index structure offers better performance than existing index structures.
Key Words: cache conscious, in-memory, index structure, KDB-tree
Manuscript received April 6, 2007. Manuscript revised September 1, 2007.