Adaptive segmentation for scientific databases
| 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 |
|
| Event | 2008 IEEE 24th International Conference on Data Engineering |
| Pages (from-to) | 1412-1414 |
| Publisher | Piscataway, NJ: IEEE |
| Organisations |
|
| 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
(Final published version)
|
| Downloads | |
| Permalink to this page | |