Repository logo

Infoscience

  • English
  • French
Log In
Logo EPFL, École polytechnique fédérale de Lausanne

Infoscience

  • English
  • French
Log In
  1. Home
  2. Academic and Research Output
  3. Conferences, Workshops, Symposiums, and Seminars
  4. Matching Database Access Patterns to Storage Characteristics
 
conference paper

Matching Database Access Patterns to Storage Characteristics

Schindler, Jiri
•
Ganger, Gregory R.
•
Ailamaki, Anastasia  
2003
Proceedings of the VLDB PhD Workshop
International Conference on Very Large Data Bases

Today’s storage interfaces hide device-specific details, simplifying system development and device interoperability. However, they prevent database systems from exploiting devices’ unique performance characteristics. 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 manager 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 parallelism to achieve order of magnitude improvements in selective scans.

  • Details
  • Metrics
Type
conference paper
Author(s)
Schindler, Jiri
Ganger, Gregory R.
Ailamaki, Anastasia  
Date Issued

2003

Published in
Proceedings of the VLDB PhD Workshop
Editorial or Peer reviewed

NON-REVIEWED

Written at

EPFL

EPFL units
DIAS  
Event nameEvent placeEvent date
International Conference on Very Large Data Bases

Berlin, Germany

2003

Available on Infoscience
August 20, 2015
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/117213
Logo EPFL, École polytechnique fédérale de Lausanne
  • Contact
  • infoscience@epfl.ch

  • Follow us on Facebook
  • Follow us on Instagram
  • Follow us on LinkedIn
  • Follow us on X
  • Follow us on Youtube
AccessibilityLegal noticePrivacy policyCookie settingsEnd User AgreementGet helpFeedback

Infoscience is a service managed and provided by the Library and IT Services of EPFL. © EPFL, tous droits réservés