000 03521naa a22005057i 4500
001 UMUN-OA-20261005-CS-029
003 local
005 20261005174811.0
006 m o d
007 cr||||||||||||
008 261005s2024 xx o u000 0 eng d
024 7 _a10.1145/3665323
_2doi
035 _a(local)OpenAlex:W4397022312
040 _alocal
_beng
_clocal
041 0 _aeng
100 0 _aMaryam Mozaffari
_eauthor.
245 1 0 _aSelf-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning /
_cMaryam Mozaffari; Anton Dignös; Johann Gamper [and others].
264 1 _a[Place of publication not identified] :
_bAssociation for Computing Machinery,
_c2024.
300 _a1 online resource (1 article).
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
500 _aPublication type: Review article.
500 _aLinked open-access copy: published version.
506 0 _aOpen access; no subscription required for the linked open-access version.
_fUnrestricted online access
_2star
520 3 _aSelf-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.
540 _aCreative Commons Attribution (licence family recorded by the source; version not supplied in metadata).
_uhttps://openalex.org/W4397022312
546 _aIn English.
588 0 _aDescription generated from OpenAlex bibliographic metadata retrieved on 5 October 2026; full text linked from the source.
590 _aCourse allocation: B. Sc. Computer Science.
650 4 _aNoSQL databases
650 4 _arelational databases
650 4 _adatabase performance tuning
653 _aB. Sc. Computer Science
653 _aUMUN open access collection
653 _adatabase systems
655 4 _aReview articles.
700 0 _aAnton Dignös
_eauthor.
700 0 _aJohann Gamper
_eauthor.
700 0 _aUta Störl
_eauthor.
773 0 _tACM Computing Surveys
_gVol. 56, no. 11, (2024), pages/article 1-37
_x0360-0300
856 4 0 _uhttps://doi.org/10.1145/3665323
_yRead open-access publication
_zOpen access. Access and licence reported by the source; this host could not be independently checked by automation.
_70
884 _aCourse selection and automated MARC21 enrichment from OpenAlex metadata.
_g20261005
_khttps://openalex.org/W4397022312
_qlocal
942 _n0
999 _c391
_d391