Title :
Online Tuning of Aggregation Tables for OLAP
Author :
Hose, Katja ; Klan, Daniel ; Sattler, Kai-Uwe
Author_Institution :
Database & Inf. Syst. Group, Ilmenau Univ. of Technol., Ilmenau
fDate :
March 29 2009-April 2 2009
Abstract :
Materializing results from complex aggregation queries helps to significantly improve response times in OLAP servers. This problem is known as the view selection problem: choosing the optimal set of aggregation tables (called configuration) for a given workload. In this paper we present an online approach for adjusting the configuration dynamically to the current workload. This approach is implemented as part of an open source OLAP server and acts on the level of multidimensional MDX queries. The work presents the details of cost estimation and optimization of the system demonstrated in [10] and extends it by an online tuning strategy.
Keywords :
data mining; optimisation; query processing; set theory; aggregation table; multidimensional MDX query; online analytical processing; online tuning strategy; open source OLAP server; optimal set; optimization; Cost function; Data engineering; Database languages; Delay; Hoses; Information systems; Multidimensional systems; Pattern analysis; Sorting; Time measurement;
Conference_Titel :
Data Engineering, 2009. ICDE '09. IEEE 25th International Conference on
Conference_Location :
Shanghai
Print_ISBN :
978-1-4244-3422-0
Electronic_ISBN :
1084-4627
DOI :
10.1109/ICDE.2009.155
