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

By: Contributor(s): Material type: ArticleLanguage: English Publisher: [Place of publication not identified] : Association for Computing Machinery, 2024Description: 1 online resource (1 article)Content type:
  • text
Media type:
  • computer
Carrier type:
  • online resource
Subject(s): Genre/Form: In: ACM Computing Surveys Vol. 56, no. 11, (2024), pages/article 1-37Abstract: 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.
List(s) this item appears in: Open Access Resources
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
No physical items for this record

Publication type: Review article.

Linked open-access copy: published version.

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

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).

https://openalex.org/W4397022312

In English.

Description generated from OpenAlex bibliographic metadata retrieved on 5 October 2026; full text linked from the source.

Course allocation: B. Sc. Computer Science.

There are no comments on this title.

to post a comment.