Browse > Article

lpCSB+- tree : An Enhanced Main Memory Index Structure Employing the Level Prefetching Technique  

Hong Hyun Taek (LG전자 단말기연구소)
Pee Jun Il (충북대학교 정보통신공학과)
Song Seok Il (충주대학교 컴퓨터공학과)
Yoo Jae Soo (충북대학교 전기전자컴퓨터공학부 및 컴퓨터ㆍ정보통신연구소)
Publication Information
Journal of KIISE:Databases / v.31, no.6, 2004 , pp. 675-683 More about this Journal
Abstract
In main-memory resident index structures, secondary cache misses considerably have an effect on the performance of index structures. Recently, several main-memory resident index structures that consider cache have been proposed to reduce the impact of secondary cache misses. However they still suffer from full secondary cache misses whenever visiting each level of a index tree. In this paper, we propose a new index structure that eliminates cache misses even when visiting each level of index tree. The proposed index structure prefetches the grandchildren of a current node. The basic structure of the proposed index structure is from CSB+-tree that uses the concepts of the node group to increase fan-out. However the insert algorithm of the proposed index structure reduces the cost of a split significantly. Also, we show the superiority of our algorithm through various performance evaluation.
Keywords
Main memory; DBMS; Index; Cache;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Jun Rao and Kenneth A. Ross, 'Making B+-Trees Cache Conscious in Main Memory,' In proceedings of ACM SIGMOD Conference, pp. 475-486, 2000   DOI
2 Shimin Chen, Phillip B. Gibbons and Todd C. Mowry, 'Improving Index Performance through Prefetching,' In proceedings of ACM SIGMOD Conference, pp. 235-246, 2001   DOI
3 Intel Corporation, 'IA-32 Intel Architecture Software Developer's Manual,' Intel Corporation Order Number 245470-007, 2002
4 Stefan Manegold, Peter A. Boncz and Martin L. Kersten, 'Optimizing database architecture for the new bottleneck: memory access,' In VLDB Journal 9(3), pp. 231-246, 2000   DOI
5 Jun Rao and Kenneth A. Ross, 'Cache Conscious Indexing for Decision-Support in Main Memory,' In proceedings of VLDB conference, pp. 78-79, 1999
6 Philip Bohannon, Peter Mcllroy and Rajeev Rastogi, 'Main-Memory Index Structures with Fixed-Size Partial Keys,' In proceedings of ACM SIGMOD Conference, pp. 163-174, 2001   DOI
7 Anastassia Ailamaki, David J. DeWitt, Mark D Hill and David A. Wood, 'DBMSs on a Modern Processor: Where Does Time Go?,' In Proceedings of VLDB Conference, pp. 266-277, 1999