Self-driving database systems
- 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.
Author details: | Jan KossmannORCiDGND, Rainer SchlosserORCiDGND |
---|---|
DOI: | https://doi.org/10.1007/s10619-020-07288-w |
ISSN: | 0926-8782 |
ISSN: | 1573-7578 |
Title of parent work (English): | Distributed and parallel databases |
Subtitle (English): | a conceptual approach |
Publisher: | Springer |
Place of publishing: | Dordrecht |
Publication type: | Article |
Language: | English |
Date of first publication: | 2020/03/16 |
Publication year: | 2020 |
Release date: | 2022/10/28 |
Tag: | database systems; recursive tuning; robustness; self-driving; workload prediction |
Volume: | 38 |
Issue: | 4 |
Number of pages: | 23 |
First page: | 795 |
Last Page: | 817 |
Funding institution: | Projekt DEAL |
Organizational units: | An-Institute / Hasso-Plattner-Institut für Digital Engineering gGmbH |
DDC classification: | 0 Informatik, Informationswissenschaft, allgemeine Werke / 00 Informatik, Wissen, Systeme / 004 Datenverarbeitung; Informatik |
Peer review: | Referiert |
Publishing method: | Open Access / Hybrid Open-Access |
License (German): | CC-BY - Namensnennung 4.0 International |