Download Now Free registration required
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