{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,21]],"date-time":"2026-02-21T18:52:32Z","timestamp":1771699952253,"version":"3.50.1"},"reference-count":29,"publisher":"Association for Computing Machinery (ACM)","issue":"1-2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2010,9]]},"abstract":"<jats:p>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.<\/jats:p>","DOI":"10.14778\/1920841.1921017","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1435-1446","source":"Crossref","is-referenced-by-count":99,"title":["SSD bufferpool extensions for database systems"],"prefix":"10.14778","volume":"3","author":[{"given":"Mustafa","family":"Canim","sequence":"first","affiliation":[{"name":"The University of Texas at Dallas"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"George A.","family":"Mihaila","sequence":"additional","affiliation":[{"name":"IBM T. J. Watson Research Center"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Bishwaranjan","family":"Bhattacharjee","sequence":"additional","affiliation":[{"name":"IBM T. J. Watson Research Center"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kenneth A.","family":"Ross","sequence":"additional","affiliation":[{"name":"IBM T. J. Watson and Columbia University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Christian A.","family":"Lang","sequence":"additional","affiliation":[{"name":"IBM T. J. Watson Research Center"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2010,9]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1147\/sj.52.0078"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687553.1687557"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1555349.1555371"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/1071690.1064230"},{"key":"e_1_2_1_5_1","unstructured":"DB2 for Linux UNIX and Windows. http:\/\/www-01.ibm.com\/software\/data\/db2\/linux-unix-windows.  DB2 for Linux UNIX and Windows. http:\/\/www-01.ibm.com\/software\/data\/db2\/linux-unix-windows."},{"key":"e_1_2_1_6_1","volume-title":"Decoupled logical and physical data storage within a database management system. Patent Application no","author":"Frazier P.","year":"2008","unstructured":"P. Frazier , P. Andersen , G. Boggs , C. Carrillo , D. Holtzman , J. M. Morris , P. K. Muller , and P. Rubio . Decoupled logical and physical data storage within a database management system. Patent Application no . 2008 0281939, May 2007. P. Frazier, P. Andersen, G. Boggs, C. Carrillo, D. Holtzman, J. M. Morris, P. K. Muller, and P. Rubio. Decoupled logical and physical data storage within a database management system. Patent Application no. 20080281939, May 2007."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/313310.313345"},{"key":"e_1_2_1_8_1","volume-title":"Proc 1975 IEEE Intercon","author":"Greenberg B. S.","year":"1975","unstructured":"B. S. Greenberg and S. H. Webber . The multics multilevel paging hierarchy. In IEEE, editor , Proc 1975 IEEE Intercon , 1975 . B. S. Greenberg and S. H. Webber. The multics multilevel paging hierarchy. In IEEE, editor, Proc 1975 IEEE Intercon, 1975."},{"key":"e_1_2_1_9_1","unstructured":"Performance value of solid state drives using IBM i May 2009. http:\/\/www-03.ibm.com\/systems\/resources\/ssd_ibmi.pdf.  Performance value of solid state drives using IBM i May 2009. http:\/\/www-03.ibm.com\/systems\/resources\/ssd_ibmi.pdf."},{"key":"e_1_2_1_10_1","volume-title":"Building the Operational Data Store","author":"Inmon W. H.","year":"1999","unstructured":"W. H. Inmon . Building the Operational Data Store . John Wiley & amp; Sons, Inc., New York, NY, USA, 1999 . W. H. Inmon. Building the Operational Data Store. John Wiley &amp; Sons, Inc., New York, NY, USA, 1999."},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1109\/TC.2007.7"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDCS.2006.9"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/264107.264213"},{"key":"e_1_2_1_14_1","first-page":"13","volume-title":"Proceedings of 4th International Workshop on Software Support for Portable Storage (IWSSPS 2009","author":"Kim S.-H.","year":"2009","unstructured":"S.-H. Kim , D. Jung , J.-S. Kim , and S. Maeng . HeteroDrive: Re-shaping the storage access pattern of oltp workload using ssd . In Proceedings of 4th International Workshop on Software Support for Portable Storage (IWSSPS 2009 ), pages 13 -- 17 , October 2009 . S.-H. Kim, D. Jung, J.-S. Kim, and S. Maeng. HeteroDrive: Re-shaping the storage access pattern of oltp workload using ssd. In Proceedings of 4th International Workshop on Software Support for Portable Storage (IWSSPS 2009), pages 13--17, October 2009."},{"key":"e_1_2_1_15_1","volume-title":"Internet Publication","author":"Koltsidas I.","year":"2009","unstructured":"I. Koltsidas and S. Viglas . The case for flash-aware multi level caching . Internet Publication , 2009 . http:\/\/homepages.inf.ed.ac.uk\/s0679010\/mfcache-TR.pdf. I. Koltsidas and S. Viglas. The case for flash-aware multi level caching. Internet Publication, 2009. http:\/\/homepages.inf.ed.ac.uk\/s0679010\/mfcache-TR.pdf."},{"key":"e_1_2_1_16_1","volume-title":"Utility-aware multi-device caching","author":"Koltsidas I.","year":"2009","unstructured":"I. Koltsidas and S. Viglas . Utility-aware multi-device caching , 2009 . I. Koltsidas and S. Viglas. Utility-aware multi-device caching, 2009."},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2007.368972"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/1364782.1364796"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.5555\/1251028.1251037"},{"key":"e_1_2_1_20_1","first-page":"115","volume-title":"In Proceedings of the 2003 Conference on File and Storage Technologies (FAST","author":"Megiddo N.","year":"2003","unstructured":"N. Megiddo and D. Modha . ARC: A self-tuning, low overhead replacement cache . In In Proceedings of the 2003 Conference on File and Storage Technologies (FAST , pages 115 -- 130 , 2003 . N. Megiddo and D. Modha. ARC: A self-tuning, low overhead replacement cache. In In Proceedings of the 2003 Conference on File and Storage Technologies (FAST, pages 115--130, 2003."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1109\/MC.2004.1297303"},{"key":"e_1_2_1_22_1","volume-title":"Internet Publication","author":"A","year":"2009","unstructured":"A technical overview of the Sun Oracle Exadata storage server and database machine . Internet Publication , September 2009 . http:\/\/www.oracle.com\/technology\/products\/bi\/db\/exadata\/pdf\/Exadata_Smart_Flash_Cache_TWP_v5.pdf. A technical overview of the Sun Oracle Exadata storage server and database machine. Internet Publication, September 2009. http:\/\/www.oracle.com\/technology\/products\/bi\/db\/exadata\/pdf\/Exadata_Smart_Flash_Cache_TWP_v5.pdf."},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/872757.872835"},{"key":"e_1_2_1_24_1","volume-title":"Database Management Systems","author":"Ramakrishnan R.","year":"2003","unstructured":"R. Ramakrishnan and J. Gehrke . Database Management Systems . McGraw-Hill , 2003 . R. Ramakrishnan and J. Gehrke. Database Management Systems. McGraw-Hill, 2003."},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.5555\/648311.754748"},{"key":"e_1_2_1_26_1","unstructured":"TPC-C On-Line Transaction Processing Benchmark. http:\/\/www.tpc.org\/tpcc\/.  TPC-C On-Line Transaction Processing Benchmark. http:\/\/www.tpc.org\/tpcc\/."},{"key":"e_1_2_1_27_1","unstructured":"TPC-H Decision Support Benchmark. http:\/\/www.tpc.org\/tpch\/.  TPC-H Decision Support Benchmark. http:\/\/www.tpc.org\/tpch\/."},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/503334.503337"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1109\/TPDS.2004.13"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1920841.1921017","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T11:38:50Z","timestamp":1672227530000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1920841.1921017"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2010,9]]},"references-count":29,"journal-issue":{"issue":"1-2","published-print":{"date-parts":[[2010,9]]}},"alternative-id":["10.14778\/1920841.1921017"],"URL":"https:\/\/doi.org\/10.14778\/1920841.1921017","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2010,9]]}}}