The VLDB Journal

, Volume 25, Issue 5, pp 673–694

Flash as cache extension for online transactional workloads

Special Issue Paper

DOI: 10.1007/s00778-015-0414-1

Cite this article as:
Kang, WH., Lee, SW. & Moon, B. The VLDB Journal (2016) 25: 673. doi:10.1007/s00778-015-0414-1
  • 446 Downloads

Abstract

Considering the current price gap between hard disk and flash memory SSD storages, for applications dealing with large-scale data, it will be economically more sensible to use flash memory drives to supplement disk drives rather than to replace them. This paper presents FaCE, which is a new low-overhead caching strategy that uses flash memory as an extension to the RAM buffer of database systems. FaCE aims at improving the transaction throughput as well as shortening the recovery time from a system failure. To achieve the goals, we propose two novel algorithms for flash cache management, namely multi-version FIFO replacement and group second chance. This was possible due to flash write optimization as well as disk access reduction obtained by the FaCE caching methods. In addition, FaCE takes advantage of the nonvolatility of flash memory to fully support database recovery by extending the scope of a persistent database to include the data pages stored in the flash cache. We have implemented FaCE in the PostgreSQL open-source database server and demonstrated its effectiveness for TPC-C benchmarks in comparison with existing caching methods such as Lazy Cleaning and Linux Bcache.

Keywords

Flash memory SSDs Cache Recovery 

Funding information

Funder NameGrant NumberFunding Note
Institute for Information & communications Technology Promotion(IITP)
  • R0126-15-1088

Copyright information

© Springer-Verlag Berlin Heidelberg 2015

Authors and Affiliations

  1. 1.School of Information and Communication EngineeringSungkyunkwan UniversitySuwonKorea
  2. 2.Department of Computer Science and EngineeringSeoul National UniversitySeoulKorea

Personalised recommendations