Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning /

Maryam Mozaffari

Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning / Maryam Mozaffari; Anton Dignös; Johann Gamper [and others]. - 1 online resource (1 article).

Publication type: Review article. Linked open-access copy: published version.

Open access; no subscription required for the linked open-access version.

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.


Creative Commons Attribution (licence family recorded by the source; version not supplied in metadata).


In English.

10.1145/3665323 doi


NoSQL databases
relational databases
database performance tuning

B. Sc. Computer Science UMUN open access collection database systems


Review articles.