Matching Database Access Patterns to Storage Characteristics (2003) [1 citations — 0 self]
Abstract:
Today’s storage interfaces hide device-specific details, simplifying system development and device interoperability. However, they prevent database systems from exploiting devices ’ unique performance characteristics. Abstract and device-independent annotations to existing storage interfaces can cleanly expose key device characteristics that improve performance and simplify manual tuning. By automatically matching access patterns to device strengths, a database storage manager can achieve robust performance even with workloads competing for the same storage resource. For example, disk-optimized accesses result in simultaneous improvement of up to 3x for DSS workloads and 7 % for a competing OLTP workload. As another example, accesses to relational tables can take advantage of MEMS-based storage parallelism to achieve order of magnitude improvements in selective scans. 1
Citations
| 167 | Shoring Up Persistent Applications – Carey, DeWitt, et al. - 1994 |
| 67 | Automated disk drive characterization – Schindler, Ganger - 1999 |
| 51 | Track-aligned extents: Matching access patterns to disk drive characteristics – Schindler, Griffin, et al. - 2002 |
| 22 | Timing-Accurate Storage Emulation – Griffin, Schindler, et al. - 2002 |
| 11 | Lachesis: Robust database storage management based on devicespecific performance characteristics – Schindler, Ganger - 2003 |
