Evaluation of B+-Tree and CSB+-Tree in Main Memory Database

Article Preview

Abstract:

Index is indispensable in database system to speeding up data access. Commonly used indexes in main memory databases are B+-Tree, T-Tree and their variants. Cost model of main memory database are more complex than disk-oriental database, and relatively little work has been done on this area. This paper establishes a cost model for B+-Tree and CSB+-Tree, analyzes their main performance factors. We perform several experiment evaluations on the cost model.

You might also be interested in these eBooks

Info:

Periodical:

Pages:

580-585

Citation:

Online since:

June 2014

Export:

Price:

Permissions CCC:

Permissions PLS:

Сopyright:

© 2014 Trans Tech Publications Ltd. All Rights Reserved

Share:

Citation:

[1] Lehman Tobin J et al. A study of index structures for main memory database management systems[C]. Proceedings of the 12th VLDB Conference, Kyoto, Japan, 1986: 294-303.

Google Scholar

[2] Rao Jun, Ross Kenneth A. Making B+-Trees cache conscious in main memory[C]. Proceedings of the 2000 ACM SIGMOD international Conference on Management of Data, Dallas, Texas, USA, 2000: 475-486.

DOI: 10.1145/335191.335449

Google Scholar

[3] Lee lg-Hoon, Shim Junho et al. CST-trees: Cache sensitive T-trees[C]. Proceedings of the 12th International Conference on Database Systems for Advanced Applications, Bangkok, Thailand. 2007: 398-409.

DOI: 10.1007/978-3-540-71703-4_35

Google Scholar

[4] Shan Wang, Yanqin Xiao . Research of main memory database[J],Computer Application Oct. 2007, vol 27, No. 10 2353-2357, In Chinese.

Google Scholar

[5] Rao Jun, Ross Kenneth A. Making B+-Trees cache conscious in main memory[C]. Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data. Dallas, Texas, USA, 2000: 475-486.

DOI: 10.1145/335191.335449

Google Scholar

[6] Rao Jun, Ross Kenneth A. Cache conscious indexing for decision-support in main memory[C]. Proceedings of the 25th VLDB Conference, Edinburgh. Scotland, U K, 1999: 78-89.

Google Scholar

[7] Lee lg-Hoon, Jae-won Lee. Cache Conscious Trees on Mordern Microprocessors[C], Proceedings of the 4th International Conference on Ubiquitous Information Management and Communication, ICUIMC 2010, Suwon, Republic of Korea, January 14-15, (2010).

DOI: 10.1145/2108616.2108668

Google Scholar