TY - GEN AU - Maryam Mozaffari AU - Anton Dignös AU - Johann Gamper AU - Uta Störl TI - Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning PY - 2024/// CY - [Place of publication not identified] PB - Association for Computing Machinery KW - NoSQL databases KW - relational databases KW - database performance tuning KW - B. Sc. Computer Science KW - UMUN open access collection KW - database systems KW - Review articles N1 - Publication type: Review article; Linked open-access copy: published version; Open access; no subscription required for the linked open-access version N2 - 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 UR - https://doi.org/10.1145/3665323 ER -