Home

About

Advanced Search

Browse by Discipline

Scientific Societies

E-print Alerts

Add E-prints

E-print Network
FAQHELPSITE MAPCONTACT US


  Advanced Search  

 
Lachesis: Robust Database Storage Management Based on Device-specific Performance Characteristics
 

Summary: Lachesis: Robust Database Storage Management
Based on Device-specific Performance Characteristics
Jiri Schindler Anastassia Ailamaki Gregory R. Ganger
Carnegie Mellon University
Abstract
Database systems work hard to tune I/O performance, but do
not always achieve the full performance potential of mod-
ern disk systems. Their abstracted view of storage compo-
nents hides useful device-specific characteristics, such as disk
track boundaries and advanced built-in firmware algorithms.
This paper presents a new storage manager architecture, called
Lachesis, that exploits and adapts to observable device-specific
characteristics in order to achieve and sustain high perfor-
mance. For DSS queries, Lachesis achieves I/O efficiency
nearly equivalent to sequential streaming even in the presence
of competing random I/O traffic. In addition, Lachesis sim-
plifies manual configuration and restores the optimizer's as-
sumptions about the relative costs of different access patterns
expressed in query plans. Experiments using IBM DB2 I/O
traces as well as a prototype implementation show that Lach-

  

Source: Ailamaki, Anastassia - School of Computer Science, Carnegie Mellon University
Ganger, Greg - Department of Electrical and Computer Engineering, Carnegie Mellon University

 

Collections: Computer Technologies and Information Sciences