A case for flash memory ssd in enterprise database applications

  • Authors:

  • Sang-Won Lee;Bongki Moon;Chanik Park;Jae-Myung Kim;Sang-Woo Kim

  • Affiliations:

  • Sungkyunkwan University, Suwon, South Korea;University of Arizona, Tucson, AZ, USA;Samsung Electronics Co., Ltd., Hwang, South Korea;Altibase Corp., Seoul, South Korea;Sungkyunkwan University, Suwon, South Korea

  • Venue:
  • Proceedings of the 2008 ACM SIGMOD international conference on Management of data
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

Abstract

Due to its superiority such as low access latency, low energy consumption, light weight, and shock resistance, the success of flash memory as a storage alternative for mobile computing devices has been steadily expanded into personal computer and enterprise server markets with ever increasing capacity of its storage. However, since flash memory exhibits poor performance for small-to-moderate sized writes requested in a random order, existing database systems may not be able to take full advantage of flash memory without elaborate flash-aware data structures and algorithms. The objective of this work is to understand the applicability and potential impact that flash memory SSD (Solid State Drive) has for certain type of storage spaces of a database server where sequential writes and random reads are prevalent. We show empirically that up to more than an order of magnitude improvement can be achieved in transaction processing by replacing magnetic disk with flash memory SSD for transaction log, rollback segments, and temporary table spaces.