TY - GEN
T1 - SARD
T2 - 2008 - IEEE 24th International Conference on Data Engineering Workshop, ICDE'08
AU - Debnath, Biplob K.
AU - Lilja, David J
AU - Mokbel, Mohamed F
N1 - Copyright:
Copyright 2008 Elsevier B.V., All rights reserved.
PY - 2008
Y1 - 2008
N2 - Traditionally, DBMSs are shipped with hundreds of configuration parameters. Since the database performance highly depends on the appropriate settings of the configuration parameters, DBAs spend a lot of their time and effort to find the best parameter values for tuning the performance of the application of interest. In many cases, they rely on their experience and some rules of thumbs. However, time and effort may be wasted by tuning those parameters which may have no or marginal effects. Moreover, tuning effects also vary depending on the expertise of the DBAs, but skilled DBAs are increasingly becoming rare and expensive to employ. To address these problems, we present a Statistical Approach for Ranking Database parameters (SARD), which is based on the Plackett & Burman statistical design methodology. SARD takes the query workload and the number of configuration parameters as inputs, and using only a linear number of experiments, generates a ranking of database parameters based on their relative impacts on the DBMS performance. Preliminary experimental results using TPC-H and PostgreSQL show that SARD generated ranking can correctly identify critical configuration parameters.
AB - Traditionally, DBMSs are shipped with hundreds of configuration parameters. Since the database performance highly depends on the appropriate settings of the configuration parameters, DBAs spend a lot of their time and effort to find the best parameter values for tuning the performance of the application of interest. In many cases, they rely on their experience and some rules of thumbs. However, time and effort may be wasted by tuning those parameters which may have no or marginal effects. Moreover, tuning effects also vary depending on the expertise of the DBAs, but skilled DBAs are increasingly becoming rare and expensive to employ. To address these problems, we present a Statistical Approach for Ranking Database parameters (SARD), which is based on the Plackett & Burman statistical design methodology. SARD takes the query workload and the number of configuration parameters as inputs, and using only a linear number of experiments, generates a ranking of database parameters based on their relative impacts on the DBMS performance. Preliminary experimental results using TPC-H and PostgreSQL show that SARD generated ranking can correctly identify critical configuration parameters.
UR - http://www.scopus.com/inward/record.url?scp=50249173350&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=50249173350&partnerID=8YFLogxK
U2 - 10.1109/ICDEW.2008.4498279
DO - 10.1109/ICDEW.2008.4498279
M3 - Conference contribution
AN - SCOPUS:50249173350
SN - 9781424421626
T3 - Proceedings - International Conference on Data Engineering
SP - 11
EP - 18
BT - Proceedings of the 2008 - IEEE 24th International Conference on Data Engineering Workshop, ICDE'08
Y2 - 7 April 2008 through 12 April 2008
ER -