Matching Database Access Patterns to Storage Characteristics (PhD Poster) Jiri Schindler   View Paper (PDF)   Return to Advanced Models and Languages/Architectures for Data Analysis (Session D3) 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. ©2004 Association for Computing Machinery