Robust Index Selection for Stochastic Dynamic Workloads

Rainer Schlosser,Marcel Weisgut,Leonardo Hübscher,Oliver Nordemann
DOI: https://doi.org/10.1007/s42979-022-01473-7
2022-11-19
SN Computer Science
Abstract:Fast query processing is a primary goal of modern database systems. The use of indexes is crucial to reduce the execution times of database queries. Hence, it is of great interest to determine an efficient selection of indexes for a database management system (DBMS). However, index selection problems are highly challenging as indexes cause additional memory consumption and the individual benefit of an index is influenced by the selection of others. In this paper, we consider index selection problems accounting for non-standard features, such as (i) multiple potential workloads, (ii) different risk-averse objectives, (iii) multi-index configurations, (iv) reconfiguration costs, and (v) anticipation of dynamic workload scenarios. For the different problem extensions, we propose specific model formulations, which can be solved efficiently using solver-based solution techniques. The applicability and performance of our concepts are demonstrated using reproducible synthetic workloads as well as standard TPC-H and TPC-DS-based benchmark workloads.
What problem does this paper attempt to address?