{"id":"https://openalex.org/W4397022312","doi":"https://doi.org/10.1145/3665323","title":"Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning","display_name":"Self-tuning Database Systems: A Systematic Literature Review of Automatic Database Schema Design and Tuning","publication_year":2024,"publication_date":"2024-05-17","ids":{"openalex":"https://openalex.org/W4397022312","doi":"https://doi.org/10.1145/3665323"},"language":"en","primary_location":{"id":"doi:10.1145/3665323","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3665323","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3665323","source":{"id":"https://openalex.org/S157921468","display_name":"ACM Computing Surveys","issn_l":"0360-0300","issn":["0360-0300","1557-7341"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Computing Surveys","raw_type":"journal-article"},"type":"review","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3665323","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5011258989","display_name":"Maryam Mozaffari","orcid":"https://orcid.org/0000-0002-4217-8179"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Maryam Mozaffari","raw_affiliation_strings":["Free University of Bozen-Bolzano, Bolzano, Italy"],"affiliations":[{"raw_affiliation_string":"Free University of Bozen-Bolzano, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037964119","display_name":"Anton Dign\u00f6s","orcid":"https://orcid.org/0000-0002-7621-967X"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Anton Dign\u00f6s","raw_affiliation_strings":["Free University of Bozen-Bolzano, Bolzano, Italy"],"affiliations":[{"raw_affiliation_string":"Free University of Bozen-Bolzano, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043864804","display_name":"Johann Gamper","orcid":"https://orcid.org/0000-0002-7128-507X"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Johann Gamper","raw_affiliation_strings":["Free University of Bozen-Bolzano, Bolzano, Italy"],"affiliations":[{"raw_affiliation_string":"Free University of Bozen-Bolzano, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5004678152","display_name":"Uta St\u00f6rl","orcid":"https://orcid.org/0000-0003-2771-142X"},"institutions":[{"id":"https://openalex.org/I120691247","display_name":"FernUniversit\u00e4t in Hagen","ror":"https://ror.org/04tkkr536","country_code":"DE","type":"education","lineage":["https://openalex.org/I120691247"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Uta St\u00f6rl","raw_affiliation_strings":["Databases and Information Systems, FernUniversit\u00e4t in Hagen, Hagen, Germany"],"affiliations":[{"raw_affiliation_string":"Databases and Information Systems, FernUniversit\u00e4t in Hagen, Hagen, Germany","institution_ids":["https://openalex.org/I120691247"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5011258989"],"corresponding_institution_ids":["https://openalex.org/I171543936"],"apc_list":null,"apc_paid":null,"fwci":2.4009,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.8901016,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"56","issue":"11","first_page":"1","last_page":"37"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9968000054359436,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9955000281333923,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8217231035232544},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.7936307787895203},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.7379539608955383},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.7084227800369263},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.633672833442688},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6309436559677124},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.6043218374252319},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5921876430511475},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5419860482215881},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.538176953792572},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.5251971483230591},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.500847578048706},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.44177931547164917},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.34538552165031433},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3436471223831177},{"id":"https://openalex.org/keywords/gender-schema-theory","display_name":"Gender schema theory","score":0.09409406781196594},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.08681643009185791}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8217231035232544},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.7936307787895203},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7379539608955383},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.7084227800369263},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.633672833442688},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6309436559677124},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.6043218374252319},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5921876430511475},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5419860482215881},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.538176953792572},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.5251971483230591},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.500847578048706},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.44177931547164917},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34538552165031433},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3436471223831177},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.09409406781196594},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.08681643009185791},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3665323","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3665323","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3665323","source":{"id":"https://openalex.org/S157921468","display_name":"ACM Computing Surveys","issn_l":"0360-0300","issn":["0360-0300","1557-7341"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Computing Surveys","raw_type":"journal-article"},{"id":"pmh:oai:unibz.it:11326612110001241","is_oa":true,"landing_page_url":"https://bia.unibz.it/esploro/outputs/journalArticle/Self-tuning-Database-Systems-A-Systematic-Literature/991006901054301241","pdf_url":null,"source":{"id":"https://openalex.org/S4210197018","display_name":"View","issn_l":"2688-268X","issn":["2688-268X","2688-3988"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Article"}],"best_oa_location":{"id":"doi:10.1145/3665323","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3665323","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3665323","source":{"id":"https://openalex.org/S157921468","display_name":"ACM Computing Surveys","issn_l":"0360-0300","issn":["0360-0300","1557-7341"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Computing Surveys","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.5199999809265137}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4397022312.pdf"},"referenced_works_count":106,"referenced_works":["https://openalex.org/W34866348","https://openalex.org/W204909595","https://openalex.org/W371957946","https://openalex.org/W1432073258","https://openalex.org/W1444968430","https://openalex.org/W1510272996","https://openalex.org/W1540259501","https://openalex.org/W1546556292","https://openalex.org/W1585513897","https://openalex.org/W1701114025","https://openalex.org/W1967627943","https://openalex.org/W1991571419","https://openalex.org/W1996711018","https://openalex.org/W1999407826","https://openalex.org/W2001111520","https://openalex.org/W2004291985","https://openalex.org/W2006768352","https://openalex.org/W2015880537","https://openalex.org/W2017052417","https://openalex.org/W2017782374","https://openalex.org/W2027507804","https://openalex.org/W2039795745","https://openalex.org/W2041106018","https://openalex.org/W2047085757","https://openalex.org/W2049730504","https://openalex.org/W2054619472","https://openalex.org/W2059326501","https://openalex.org/W2061200062","https://openalex.org/W2075018787","https://openalex.org/W2078524330","https://openalex.org/W2086529872","https://openalex.org/W2093267241","https://openalex.org/W2098443134","https://openalex.org/W2105889662","https://openalex.org/W2106956101","https://openalex.org/W2114017793","https://openalex.org/W2124511785","https://openalex.org/W2128941761","https://openalex.org/W2135475686","https://openalex.org/W2141647322","https://openalex.org/W2143298762","https://openalex.org/W2143401113","https://openalex.org/W2143515359","https://openalex.org/W2146466202","https://openalex.org/W2148291485","https://openalex.org/W2150101660","https://openalex.org/W2150630976","https://openalex.org/W2153231238","https://openalex.org/W2155595639","https://openalex.org/W2163117299","https://openalex.org/W2170870260","https://openalex.org/W2180737804","https://openalex.org/W2243512312","https://openalex.org/W2260616469","https://openalex.org/W2265048516","https://openalex.org/W2295468252","https://openalex.org/W2334653300","https://openalex.org/W2396309311","https://openalex.org/W2425316268","https://openalex.org/W2439326083","https://openalex.org/W2468802342","https://openalex.org/W2508071492","https://openalex.org/W2537031909","https://openalex.org/W2537849499","https://openalex.org/W2573443553","https://openalex.org/W2605149445","https://openalex.org/W2730037187","https://openalex.org/W2755087487","https://openalex.org/W2769536418","https://openalex.org/W2800277550","https://openalex.org/W2889249015","https://openalex.org/W2892158769","https://openalex.org/W2899739069","https://openalex.org/W2902997364","https://openalex.org/W2907544011","https://openalex.org/W2917247870","https://openalex.org/W2943981449","https://openalex.org/W2954217945","https://openalex.org/W2970918514","https://openalex.org/W2972418141","https://openalex.org/W2976245731","https://openalex.org/W2980733593","https://openalex.org/W2984953282","https://openalex.org/W2990216105","https://openalex.org/W2991266382","https://openalex.org/W2997998108","https://openalex.org/W3011207305","https://openalex.org/W3011572741","https://openalex.org/W3095166039","https://openalex.org/W3096138397","https://openalex.org/W3113933416","https://openalex.org/W3134578347","https://openalex.org/W3139743542","https://openalex.org/W3161984997","https://openalex.org/W3177533024","https://openalex.org/W3196849431","https://openalex.org/W3198839277","https://openalex.org/W3203311072","https://openalex.org/W3217293418","https://openalex.org/W4242860290","https://openalex.org/W4250763448","https://openalex.org/W4289105961","https://openalex.org/W6672336223","https://openalex.org/W6736077337","https://openalex.org/W6749991550","https://openalex.org/W6769917067"],"related_works":["https://openalex.org/W166845585","https://openalex.org/W2153512431","https://openalex.org/W1513459549","https://openalex.org/W2103472145","https://openalex.org/W1483477772","https://openalex.org/W2105315220","https://openalex.org/W1512552654","https://openalex.org/W2142232227","https://openalex.org/W1591654213","https://openalex.org/W49842380"],"abstract_inverted_index":{"Self-tuning":[0],"is":[1,58,74,145],"a":[2,68,86,120,147],"feature":[3],"of":[4,11,40,49,104,170],"autonomic":[5],"databases":[6,31,46],"that":[7,22,109,139],"includes":[8],"the":[9,24,37,41,61,75,102,107,113,163,168],"problem":[10],"automatic":[12,32,91],"schema":[13,21,33,70,92,114,128,143],"design.":[14],"It":[15],"aims":[16],"at":[17],"providing":[18],"an":[19],"optimized":[20],"increases":[23],"overall":[25],"database":[26],"performance.":[27],"While":[28],"in":[29,44,94],"relational":[30],"design":[34,39,71,93,115,129,144],"focuses":[35],"on":[36,90],"automated":[38],"physical":[42],"schema,":[43],"NoSQL":[45,98,159],"all":[47],"levels":[48,103],"representation":[50,105],"are":[51,63,110],"considered:":[52],"conceptual,":[53],"logical,":[54],"and":[55,66,97,106,117,125,150,173],"physical.":[56],"This":[57],"mainly":[59],"because":[60],"latter":[62],"mostly":[64],"schema-less":[65],"lack":[67],"standard":[69],"procedure":[72],"as":[73],"case":[76],"for":[77,112,158,176],"SQL":[78,96],"databases.":[79,99,160],"In":[80],"this":[81],"work,":[82],"we":[83,118],"carry":[84],"out":[85],"systematic":[87],"literature":[88],"survey":[89],"both":[95],"We":[100,161],"identify":[101,174],"methods":[108],"used":[111],"problem,":[116],"present":[119],"novel":[121],"taxonomy":[122],"to":[123,154],"classify":[124],"compare":[126],"different":[127],"solutions.":[130],"Our":[131],"comprehensive":[132],"analysis":[133,172],"demonstrates":[134],"that,":[135],"despite":[136],"substantial":[137],"progress":[138],"has":[140],"been":[141],"made,":[142],"still":[146],"developing":[148],"field":[149],"considerable":[151],"challenges":[152],"need":[153],"be":[155],"addressed,":[156],"notably":[157],"highlight":[162],"most":[164],"important":[165],"findings":[166],"from":[167],"results":[169],"our":[171],"areas":[175],"future":[177],"research":[178],"work.":[179]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":1}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}