10th International Database Engineering and Applications Symposium (IDEAS'06)
A Tree for All Seasons
Delhi, India
December 11-December 14
ISBN: 0-7695-2577-6
DOI Bookmark:
http://doi.ieeecomputersociety.org/10.1109/IDEAS.2006.6
The performance of in-memory databases is significantly affected by the number of data blocks fetched from memory into the processor-resident cache. In recent years, various tree-based indexes have been proposed for main memory databases. A common assumption in the analysis of these indexes is that there is no data in the cache that can be reused between key lookups, i.e. the system has a cold cache for each lookup. In practice, though, the ?temperature? of the cache is strongly dependent on the application. For example, a warm cache is typical for OLTP applications that query the same index over and over with little computation in between lookups. In this paper, we present a comparative study of the cache behavior of various B+-tree-based indexes which shows that none of them performs best in all cases. Also, we propose a lightweight technique for improving the cache behavior of any B+-tree based index that performs best in all settings.
Citation:
George Mihaila, Ioana Stanoi, "A Tree for All Seasons," ideas, pp.3-10, 10th International Database Engineering and Applications Symposium (IDEAS'06), 2006
Usage of this product signifies your acceptance of the
Terms of Use.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||