Flash-enabled database storage

Ioannis Koltsidas, Stratis Viglas

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Flash memory has emerged as a high-performing and viable storage alternative to magnetic disks for data-intensive applications. In our work we study how the storage layer of a database system can benefit from the presence of a flash disk. Due to the varying price and I/O characteristics of flash disks the optimal design decisions vary widely across different setups. We study how the system can take advantage of the random read efficiency of inexpensive flash disks by using the latter at the same level of memory hierarchy as magnetic disks in a hybrid setup; our algorithms provide efficient and adaptive data placement that leads to substantial performance improvement. We propose techniques to accurately predict the main memory cache behavior for systems consisting of heterogeneous storage media and selectively allocate memory buffers to devices; thereby, the I/O cost of the system drops significantly, even offsetting wrong data placement decisions. We also explore the design space for a system that uses flash memory as a cache to the underlying storage and propose techniques towards high performance. The experimental results, we believe, exhibit both the potential and necessity of our techniques in future database systems.
Original languageEnglish
Title of host publicationWorkshops Proceedings of the 26th International Conference on Data Engineering, ICDE 2010, March 1-6, 2010, Long Beach, California, USA
PublisherInstitute of Electrical and Electronics Engineers (IEEE)
Pages309-312
Number of pages4
ISBN (Electronic)978-1-4244-6521-7
ISBN (Print)978-1-4244-6522-4
DOIs
Publication statusPublished - 2010

Fingerprint

Dive into the research topics of 'Flash-enabled database storage'. Together they form a unique fingerprint.

Cite this