Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning
Open Access
- 29 June 2024
- journal article
- review article
- Published by Association for Computing Machinery (ACM) in ACM Computing Surveys
- Vol. 56 (11) , 1-37
Abstract
Self-tuning is a feature of autonomic databases that includes the problem of automatic schema design. It aims at providing an optimized schema that increases the overall database performance. While in relational databases automatic schema design focuses on the automated design of the physical schema, in NoSQL databases all levels of representation are considered: conceptual, logical, and physical. This is mainly because the latter are mostly schema-less and lack a standard schema design procedure as is the case for SQL databases. In this work, we carry out a systematic literature survey on automatic schema design in both SQL and NoSQL databases. We identify the levels of representation and the methods that are used for the schema design problem, and we present a novel taxonomy to classify and compare different schema design solutions. Our comprehensive analysis demonstrates that, despite substantial progress that has been made, schema design is still a developing field and considerable challenges need to be addressed, notably for NoSQL databases. We highlight the most important findings from the results of our analysis and identify areas for future research work.Keywords
Funding Information
- National Recovery and Resilience Plan
- Italian Ministry of University and Research
- European Union-NextGenerationEU (PE00000003)
- Italian Ministry of University and Research, CUP (I33C22006890001)
This publication has 175 references indexed in Scilit:
- CONST: Continuous online NoSQL schema tuningSoftware: Practice and Experience, 2020
- Self-driving database systems: a conceptual approachDistributed and Parallel Databases, 2020
- SmartIX: A database indexing agent based on reinforcement learningApplied Intelligence, 2020
- Design methods for the new database era: a systematic literature reviewSoftware and Systems Modeling, 2019
- Parametric schema inference for massive JSON datasetsThe VLDB Journal, 2019
- An experimental evaluation and analysis of database crackingThe VLDB Journal, 2015
- Transactional support for adaptive indexingThe VLDB Journal, 2014
- TOPYDE: A tool for physical database design1995
- Multi-dimensional clustering for data base organizationsInformation Systems, 1977
- The optimal selection of secondary indices for filesInformation Systems, 1975