Title :
Main memory indexing: the case for BD-tree
Author :
Cui, Bin ; Ooi, Beng Chin ; Su, Jianwen ; Tan, Kian-Lee
Author_Institution :
Dept. of Comput. Sci., Nat. Univ. of Singapore, Singapore
fDate :
7/1/2004 12:00:00 AM
Abstract :
We adapt and optimize the BD-tree for main memory data processing. We compare the memory-based BD-tree against the B+-tree and CSB+-tree. We present cost models for exact match query for these indexes, including L2 cache and translation lookahead buffer (TLB) miss model and execution time model. We also implemented these structures and conducted experimental study. Our analytical and experimental results show that a well-tuned BD-tree is superior in most cases.
Keywords :
cache storage; database indexing; memory architecture; storage management; tree data structures; B+-tree; BD-tree; CSB+-tree; cost model; main memory database; main memory indexing; translation lookahead buffer; Computer Society; Computer aided software engineering; Costs; Data processing; Databases; Dynamic range; Hardware; Indexing; Query processing; Tree data structures;
Journal_Title :
Knowledge and Data Engineering, IEEE Transactions on
DOI :
10.1109/TKDE.2004.1318568