DocumentCode :
3324522
Title :
Adaptive Segmentation for Scientific Databases
Author :
Ivanova, Milena ; Kersten, Martin L. ; Nes, Niels
Author_Institution :
CWI, Amsterdam
fYear :
2008
fDate :
7-12 April 2008
Firstpage :
1412
Lastpage :
1414
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.
Keywords :
database management systems; adaptive segmentation; database segmentation; scientific database; scientific databases; Algebra; Assembly; Data structures; Database systems; Human resource management; Monitoring; Open source software; Performance gain; Tail;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Data Engineering, 2008. ICDE 2008. IEEE 24th International Conference on
Conference_Location :
Cancun
Print_ISBN :
978-1-4244-1836-7
Electronic_ISBN :
978-1-4244-1837-4
Type :
conf
DOI :
10.1109/ICDE.2008.4497573
Filename :
4497573
Link To Document :
بازگشت