| | |
Summary: Matching Database Access Patterns to Storage Characteristics
Jiri Schindler Anastassia Ailamaki Gregory R. Ganger
Carnegie Mellon University
Abstract
Today's storage interfaces hide device-specific details, simplifying sys-
tem development and device interoperability. However, they prevent
database systems from exploiting devices' unique performance char-
acteristics. 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 man-
ager 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 paral-
lelism to achieve order of magnitude improvements in selective scans.
1 Introduction
Database storage managers employ sophisticated algo-
rithms attempting to exploit the performance available
|
