Flashing databases: expectations and limitations

Authors:
Stephan Baumann;Giel de Nijs;Michael Strobel;Kai-Uwe Sattler
Affiliations:
Ilmenau Univ. of Technology, Germany;VectorWise, Netherlands;Ilmenau Univ. of Technology, Germany;Ilmenau Univ. of Technology, Germany
Venue:
Proceedings of the Sixth International Workshop on Data Management on New Hardware
Year:
2010

Citing 10
Cited 0

Multi-dimensional clustering: a new data layout scheme in DB2

Proceedings of the 2003 ACM SIGMOD international conference on Management of data
C-store: a column-oriented DBMS

VLDB '05 Proceedings of the 31st international conference on Very large data bases
Linux Kernel Development (2nd Edition) (Novell Press)

Linux Kernel Development (2nd Edition) (Novell Press)
FlashDB: dynamic self-tuning database for NAND flash

Proceedings of the 6th international conference on Information processing in sensor networks
Design of flash-based DBMS: an in-page logging approach

Proceedings of the 2007 ACM SIGMOD international conference on Management of data
An efficient B-tree layer implementation for flash-memory storage systems

ACM Transactions on Embedded Computing Systems (TECS)
The five-minute rule 20 years later (and how flash memory changes the rules)

Communications of the ACM - Barbara Liskov: ACM's A.M. Turing Award Winner
Understanding intrinsic characteristics and system implications of flash memory based solid state drives

Proceedings of the eleventh international joint conference on Measurement and modeling of computer systems
Query processing techniques for solid state drives

Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
The Star Schema Benchmark and Augmented Fact Table Indexing

Performance Evaluation and Benchmarking

Quantified Score

Hi-index	0.00

Visualization

Abstract

Flash devices (solid state disks) promise a significant performance improvement for disk-based database processing. However, database storage structures and processing strategies originally designed for magnetic disks prevent the optimal utilization of SSDs. Based on previous work on bench-marking SSDs and a detailed discussion of I/O methods, in this paper, we analyze appropriate execution methods for database processing as well as important parameters and boundaries and present a tool which helps to derive these parameters.