loading...
A Tree for All Seasons
Delhi, India December 11-December 14
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/IDEAS.2006.610th International Database Engineeri ...
 This Article 
 
PDF
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
George Mihaila, IBM T. J. Watson
Ioana Stanoi, IBM T. J. Watson
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.