Home

About

Advanced Search

Browse by Discipline

Scientific Societies

E-print Alerts

Add E-prints

E-print Network
FAQHELPSITE MAPCONTACT US


  Advanced Search  

 
Matching Database Access Patterns to Storage Characteristics Jiri Schindler Anastassia Ailamaki Gregory R. Ganger
 

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

  

Source: Ailamaki, Anastassia - School of Computer Science, Carnegie Mellon University

 

Collections: Computer Technologies and Information Sciences