Self-driving database systems: a conceptual approach
Open Access
- 16 March 2020
- journal article
- research article
- Published by Springer Nature in Distributed and Parallel Databases
- Vol. 38 (4) , 795-817
Abstract
Challenges for self-driving database systems, which tune their physical design and configuration autonomously, are manifold: Such systems have to anticipate future workloads, find robust configurations efficiently, and incorporate knowledge gained by previous actions into later decisions. We present a component-based framework for self-driving database systems that enables database integration and development of self-managing functionality with low overhead by relying on separation of concerns. By keeping the components of the framework reusable and exchangeable, experiments are simplified, which promotes further research in that area. Moreover, to optimize multiple mutually dependent features, e.g., index selection and compression configurations, we propose a linear programming (LP) based algorithm to derive an efficient tuning order automatically. Afterwards, we demonstrate the applicability and scalability of our approach with reproducible examples.Keywords
This publication has 26 references indexed in Scilit:
- Oracle Workload Intelligence2015
- Robust estimation of resource consumption for SQL queries using statistical techniquesProceedings of the VLDB Endowment, 2012
- CoPhyProceedings of the VLDB Endowment, 2011
- SchismProceedings of the VLDB Endowment, 2010
- Self-Management Technology in Databases2009
- Automated design of multidimensional clustering tables for relational databases2004
- DB2 Design Advisor2004
- A Genetic Algorithm for the Index Selection ProblemLecture Notes in Computer Science, 2003
- The vision of autonomic computingComputer, 2003
- Primitives for Workload Summarization and Implications for SQL2003