Data Management

Revisiting Database Storage Optimizations on Flash

Download Now Free registration required

Executive Summary

The database storage hierarchy has been heavily optimized for the performance characteristics of disks. Storage managers typically employ row- or column-oriented storage layouts, or a combination, to improve the I/O performance of different query workloads with disks. The recent rise of flash memory-based Solid-State Drives (SSDs) significantly change the performance characteristics of storage: these drives provide an order of magnitude lower read/access latencies, significantly higher read bandwidths, and most importantly, negligible seek overheads. In light of these differences, the authors analyze major storage optimizations for read-optimized databases. They examine the benefits of row and column-oriented storage layouts on flash SSDs.

  • Format: PDF
  • Size: 207 KB