Exploiting the Impact of Database System Configuration Parameters: A Design of Experiments Approach

Tuning database system configuration parameters to proper values according to the expected query workload plays a very important role in determining DBMS performance. However, the number of configuration parameters in a DBMS is very large. Furthermore, typical query workloads have a large number of constituent queries, which makes tuning very time and effort intensive. To reduce tuning time and effort, database administrators rely on their experience and some rules of thumb to select a set of important configuration parameters for tuning. Nonetheless, as a statistically rigorous methodology is not used, time and effort may be wasted by tuning those parameters which may have no or marginal effects on the DBMS performance for the given query workload. Database administrators also use compressed query workloads to reduce tuning time. If not carefully selected, the compressed query workload may fail to include a query which may reveal important performance bottleneck parameters. In this ar...

• Type: Others
• Year: 2008
• Where: IEEE Data Engineering Bulletin
• Authors: Biplob K. Debnath, Mohamed F. Mokbel, David J. Lilja.
• Keywords: Database Performance, Database Systems, Design Of Experiments