research-article

Advances in flash memory SSD technology for enterprise database applications

Authors:

Chanik ParkAuthors Info & Claims

SIGMOD '09: Proceedings of the 2009 ACM SIGMOD International Conference on Management of data

Pages 863 - 870

https://doi.org/10.1145/1559845.1559937

Published: 29 June 2009 Publication History

Abstract

The past few decades have witnessed a chronic and widening imbalance among processor bandwidth, disk capacity, and access speed of disk. According to Amdhal's law, the performance enhancement possible with a given improvement is limited by the amount that the improved feature is used. This implies that the performance enhancement of an OLTP system would be seriously limited without a considerable improvement in I/O throughput. Since the market debut of flash memory SSD a few years ago, we have made a continued effort to overcome its poor random write performance and to provide stable and sufficient I/O bandwidth. In this paper, we present three different flash memory SSD models prototyped recently by Samsung Electronics. We then show how the flash memory SSD technology has advanced to reverse the widening trend of performance gap between processors and storage devices. We also demonstrate that even a single flash memory drive can outperform a level-0 RAID with eight enterprise class 15k-RPM disk drives with respect to transaction throughput, cost effectiveness and energy consumption.

References

[1]

Amir Ban and Ramat Hasharon. Flash File System Optimized for Page-Mode Flash Technologies, August 1999. United States Patent 5937425.

[2]

Transaction Processing Performance Council. TPC Benchmark C Standard Specification (Revision 5. 9). http://www.tpc.org, June 2007.

[3]

Brian Dees. Native Command Queuing-Advanced Performance in Desktop Storage. IEEE Potentials 24(4):4--7, Oct/Nov 2005.

[4]

Jim Gray. Rules of Thumb in Data Engineering. In Proceedings of ICDE pages 3--12, 2000.

Digital Library

[5]

John L. Hennessy and David A. Patterson. Computer Architecture: A Quantitative Approach, 4th Edition Morgan Kaufmann, 2007.

Digital Library

[6]

W. W. Hsuand and A. J. Smith. Characteristics of I/O Traffic in Personal Computer and Server Workloads. IBM Systems Journal 42(2): 347--372, 2003.

Digital Library

[7]

W. W. Hsuand and A. J. Smith. The Performance Impact of I/O Optimizations and Disk Improvements. IBM Journal of Research and Development 48(2):255--289, 2004.

Digital Library

[8]

IBM. IBM Power 595 Server Model 9119-FHA Using AIX 5L Version 5. 3 and DB2 Enterprise 9. 5, June 2008. TPC Benchmark C Full Disclosure Report First Edition.

[9]

Sang-Won Lee and Bongki Moon. Design of Flash-based DBMS:an In-Page Logging Approach. In Proceedings of the ACM SIGMOD pages 55--66, 2007.

Digital Library

[10]

Sang-Won Lee, Bongki Moon, Chanik Park, Jae-Myung Kim, and Sang-Woo Kim. A Case for Flash Memory SSD in Enterprise Database Applications. In Proceedings of the ACM SIGMOD pages 1075--1086, 2008.

Digital Library

[11]

Oracle. ORION:Oracle I/O Numbers Calibration Tool. http://www.oracle.com/technology/software/-tech/orion/.

[12]

Seon-Yeong Park, Dawoon Jung, Jeong-Uk Kang, Jin-Soo Kim, and Joonwon Lee. CFLRU: a Replacement Algorithm for Flash Memory. In the 2006 International Conference on Compilers, Architecture and Synthesis for Embedded Systems (CASES'06)pages 234--241, October 2006.

Digital Library

[13]

David A. Patterson. Latency Lags Bandwidth. Communications of the ACM 47(10):71--75, October 2004.

Digital Library

[14]

Meikel Poess and Raghunath Othayoth Nambiar. Energy Cost, The Key Challenge of Today's Data Centers: A Power Consumption Analysis of TPC-C Results. In Proceedings of VLDB 2008.

[15]

Chris Ruemmler and John Wilkes. An Introduction to Disk Drive Modeling. IEEE Computer 27:17--28, 1994.

Digital Library

Cited By

Haas GLeis V(2023)What Modern NVMe Storage Can Do, and How to Exploit it: High-Performance I/O for High-Performance Storage EnginesProceedings of the VLDB Endowment10.14778/3598581.359858416:9(2090-2102)Online publication date: 1-May-2023
https://dl.acm.org/doi/10.14778/3598581.3598584
Kim JLee S(2023)Dealloc FTL: Efficiently Managing Temporary Files on SSDs2023 IEEE International Conference on Big Data and Smart Computing (BigComp)10.1109/BigComp57234.2023.00059(298-303)Online publication date: Feb-2023
https://doi.org/10.1109/BigComp57234.2023.00059
An MIm SJung DLee S(2022)Your read is our priority in flash storageProceedings of the VLDB Endowment10.14778/3538598.353861215:9(1911-1923)Online publication date: 1-May-2022
https://dl.acm.org/doi/10.14778/3538598.3538612
Show More Cited By

Index Terms

Advances in flash memory SSD technology for enterprise database applications
1. Information systems
  1. Data management systems
    1. Data structures
      1. Data access methods

Recommendations

A case for flash memory ssd in enterprise database applications
SIGMOD '08: Proceedings of the 2008 ACM SIGMOD international conference on Management of data

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 ...
A Hybrid Flash Memory SSD Scheme for Enterprise Database Applications
APWEB '10: Proceedings of the 2010 12th International Asia-Pacific Web Conference

Flash memory has many advantages such as high performance, low electronic power, non-volatile storage and physical stability, over hard-disks. For this reason, flash memory has been deployed as data storage for mobile devices, including PDAs, MP3 ...
Flash-Aware RAID Techniques for Dependable and High-Performance Flash Memory SSD

Solid-state disks (SSDs), which are composed of multiple NAND flash chips, are replacing hard disk drives (HDDs) in the mass storage market. The performances of SSDs are increasing due to the exploitation of parallel I/O architectures. However, ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGMOD '09: Proceedings of the 2009 ACM SIGMOD International Conference on Management of data

June 2009

1168 pages

ISBN:9781605585512

DOI:10.1145/1559845

Editors:
Carsten Binnig,
Benoit Dageville,
General Chairs:
Uğur Çetintemel
Brown University, USA
,
Stan Zdonik
Brown University, USA
,
Program Chair:
Donald Kossmann
ETH Zurich, Switzerland

Copyright © 2009 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 29 June 2009

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

SIGMOD/PODS '09

Sponsor:

SIGMOD/PODS '09: International Conference on Management of Data

June 29 - July 2, 2009

Rhode Island, Providence, USA

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

87
Total Citations
View Citations
2,369
Total Downloads

Downloads (Last 12 months)43
Downloads (Last 6 weeks)6

Reflects downloads up to 10 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

Haas GLeis V(2023)What Modern NVMe Storage Can Do, and How to Exploit it: High-Performance I/O for High-Performance Storage EnginesProceedings of the VLDB Endowment10.14778/3598581.359858416:9(2090-2102)Online publication date: 1-May-2023
https://dl.acm.org/doi/10.14778/3598581.3598584
Kim JLee S(2023)Dealloc FTL: Efficiently Managing Temporary Files on SSDs2023 IEEE International Conference on Big Data and Smart Computing (BigComp)10.1109/BigComp57234.2023.00059(298-303)Online publication date: Feb-2023
https://doi.org/10.1109/BigComp57234.2023.00059
An MIm SJung DLee S(2022)Your read is our priority in flash storageProceedings of the VLDB Endowment10.14778/3538598.353861215:9(1911-1923)Online publication date: 1-May-2022
https://dl.acm.org/doi/10.14778/3538598.3538612
An MSong ISong YLee SIves ZBonifati AEl Abbadi A(2022)Avoiding Read Stalls on Flash StorageProceedings of the 2022 International Conference on Management of Data10.1145/3514221.3526126(1404-1417)Online publication date: 10-Jun-2022
https://dl.acm.org/doi/10.1145/3514221.3526126
Cadenelli NJun SPolo JWright ACarrera DArvind (2021)Enabling Genomics Pipelines in Commodity Personal Computers With Flash StorageFrontiers in Genetics10.3389/fgene.2021.61595812Online publication date: 29-Apr-2021
https://doi.org/10.3389/fgene.2021.615958
Kim JChoi KLee WKim J(2021)Performance Modeling and Practical Use Cases for Black-Box SSDsACM Transactions on Storage10.1145/344002217:2(1-38)Online publication date: 8-Jun-2021
https://dl.acm.org/doi/10.1145/3440022
Kang YJo YCha JBae WLee WKim S(2021)${\sf FORESEE}$FORESEE: An Effective and Efficient Framework for Estimating the Execution Times of IO Traces on the SSDIEEE Transactions on Computers10.1109/TC.2020.303818970:12(2146-2160)Online publication date: 1-Dec-2021
https://dl.acm.org/doi/10.1109/TC.2020.3038189
Park JChoi SOh GLee S(2021)Gather Interface for Freezing Pages in Flash StorageIEEE Access10.1109/ACCESS.2021.30973869(102542-102548)Online publication date: 2021
https://doi.org/10.1109/ACCESS.2021.3097386
Andrews MBurkle BChaudhari SDi Croce DGleyzer SHeintz UNarain MPaulini MUsai E(2021)Accelerating End-to-End Deep Learning for Particle Reconstruction using CMS open dataEPJ Web of Conferences10.1051/epjconf/202125103057251(03057)Online publication date: 23-Aug-2021
https://doi.org/10.1051/epjconf/202125103057
Kang MChoi SOh GLee S(2020)2RProceedings of the VLDB Endowment10.14778/3407790.340780513:12(2004-2017)Online publication date: 14-Sep-2020
https://dl.acm.org/doi/10.14778/3407790.3407805
Show More Cited By

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents