Adaptive segmentation for scientific databases

Open Access
Authors
Publication date 2008
Book title ICDE 2008: proceedings of the 2008 IEEE 24th International Conference on Data Engineering: April 7-12, 2008, Cancun, Mexico
ISBN
  • 9781424418367
Event 2008 IEEE 24th International Conference on Data Engineering
Pages (from-to) 1412-1414
Publisher Piscataway, NJ: IEEE
Organisations
  • Faculty of Science (FNWI) - Informatics Institute (IVI)
Abstract In this paper we explore database segmentation in the context of a column-store DBMS targeted at a scientific database. We present a novel hardware- and scheme-oblivious segmentation algorithm, which learns and adapts to the workload immediately. The approach taken is to capitalize on (intermediate) query results, such that future queries benefit from a more appropriate data layout. The algorithm is implemented as an extension of a complete DBMS and evaluated against a real-life workload. It demonstrates significant performance gains without DBA assistance.
Document type Conference contribution
Language English
Published at https://doi.org/10.1109/ICDE.2008.4497573
Downloads
Permalink to this page
Back