Yet another write-optimized DBMS layer for flash-based solid state storage

Hongchan Roh, Daewook Lee, Sanghyun Park
2010 Proceedings of the 19th ACM international conference on Information and knowledge management - CIKM '10  
Flash-based Solid State Storage (flashSSS) has write-oriented problems such as low write throughput, and limited lifetime. Especially, flashSSDs have a characteristic vulnerable to random-writes, due to its control logic utilizing parallelism between the flash memory chips. In this paper, we present a write-optimized layer of DBMSs to address the write-oriented problems of flashSSS in on-line transaction processing environments. The layer consists of a write-optimized buffer, a corresponding
more » ... space, and an in-memory mapping table, closely associated with a novel logging scheme called InCremental Logging (ICL). The ICL scheme enables DBMSs to reduce page-writes at the least expense of additional page-reads, while replacing randomwrites into sequential-writes. Through experiments, our approach demonstrated up-to an order of magnitude performance enhancement in I/O processing time compared to the original DBMS, increasing the longevity of flashSSS by approximately a factor of two.
doi:10.1145/1871437.1871617 dblp:conf/cikm/RohLP10 fatcat:dg3iu2dnyzakjkw4ene2t6du6e