Paper Info
Title
Lachesis: robust database storage management based on device-specific performance characteristics
Abstract
Database systems work hard to tune I/O performance, but do not always achieve the full performance potential of modern disk systems. Their abstracted view of storage components 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 performance. 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 simplifies manual configuration and restores the optimizer's assumptions 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 Lachesis improves standalone DSS performance by 10% on average. More importantly, when running concurrently with an on-line transaction processing (OLTP) workload, Lachesis improves DSS performance by up to 3×, while OLTP also exhibits a 7% speedup.
Year
DOI
Venue
2003
10.1016/B978-012722442-8/50068-9
VLDB
Keywords
Field
DocType
robust database storage management,o efficiency,o performance,dss performance,disk track boundary,o traffic,full performance potential,high performance,dss query,device-specific characteristic,standalone dss performance,device-specific performance characteristic,database management,database system,computer storage devices
Transaction processing,IBM,Computer science,Computer data storage,Online transaction processing,Exploit,Database storage structures,Database,Speedup,Firmware
Conference
ISBN
Citations 
PageRank 
0-12-722442-4
13
0.97
References 
Authors
21
3
Name
Order
Citations
PageRank
Jiri Schindler141126.82
Anastasia Ailamaki24178349.12
Gregory R. Ganger34560383.16