SSD bufferpool extensions for database systems
Open Access
- 1 September 2010
- journal article
- Published by Association for Computing Machinery (ACM) in Proceedings of the VLDB Endowment
- Vol. 3 (1-2) , 1435-1446
Abstract
High-end solid state disks (SSDs) provide much faster access to data compared to conventional hard disk drives. We present a technique for using solid-state storage as a caching layer between RAM and hard disks in database management systems. By caching data that is accessed frequently, disk I/O is reduced. For random I/O, the potential performance gains are particularly significant. Our system continuously monitors the disk access patterns to identify hot regions of the disk. Temperature statistics are maintained at the granularity of an extent, i.e., 32 pages, and are kept current through an aging mechanism. Unlike prior caching methods, once the SSD is populated with pages from warm regions cold pages are not admitted into the cache, leading to low levels of cache pollution. Simulations based on DB2 I/O traces, and a prototype implementation within DB2 both show substantial performance improvements.Keywords
This publication has 14 references indexed in Scilit:
- An object placement advisor for DB2 using solid state storageProceedings of the VLDB Endowment, 2009
- Understanding intrinsic characteristics and system implications of flash memory based solid state drives2009
- A Locality-Aware Cooperative Cache Management Protocol to Improve Network File System Performance2006
- Empirical evaluation of multi-level buffer cache collaboration for storage systemsACM SIGMETRICS Performance Evaluation Review, 2005
- Second-level buffer cache managementIEEE Transactions on Parallel and Distributed Systems, 2004
- Multi-dimensional clustering2003
- On filter effects in web caching hierarchiesACM Transactions on Internet Technology, 2002
- Present and future directions in data warehousingACM SIGMIS Database: the DATABASE for Advances in Information Systems, 1998
- Database architecture for data warehousing: An evolutionary approach1998
- Run-time adaptive cache hierarchy management via reference analysis1997