{"id":"https://openalex.org/W2613600412","doi":"https://doi.org/10.5753/sbbd.2016.24314","title":"Automatic Physical Design Tuning based on Hypothetical Plans","display_name":"Automatic Physical Design Tuning based on Hypothetical Plans","publication_year":2016,"publication_date":"2016-10-04","ids":{"openalex":"https://openalex.org/W2613600412","doi":"https://doi.org/10.5753/sbbd.2016.24314","mag":"2613600412"},"language":"en","primary_location":{"id":"doi:10.5753/sbbd.2016.24314","is_oa":true,"landing_page_url":"https://doi.org/10.5753/sbbd.2016.24314","pdf_url":"https://sol.sbc.org.br/index.php/sbbd/article/download/24314/24137","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Anais do XXXI Simp\u00f3sio Brasileiro de Banco de Dados (SBBD 2016)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://sol.sbc.org.br/index.php/sbbd/article/download/24314/24137","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5103058231","display_name":"Ana Carolina Almeida","orcid":"https://orcid.org/0000-0003-0936-1542"},"institutions":[{"id":"https://openalex.org/I40034438","display_name":"Universidade do Estado do Rio de Janeiro","ror":"https://ror.org/0198v2949","country_code":"BR","type":"education","lineage":["https://openalex.org/I40034438"]}],"countries":["BR"],"is_corresponding":true,"raw_author_name":"Ana Carolina Almeida","raw_affiliation_strings":["Rio de Janeiro State University (UERJ)"],"affiliations":[{"raw_affiliation_string":"Rio de Janeiro State University (UERJ)","institution_ids":["https://openalex.org/I40034438"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066979752","display_name":"\u00c2ngelo Brayner","orcid":"https://orcid.org/0000-0001-9820-9133"},"institutions":[{"id":"https://openalex.org/I243754102","display_name":"Universidade Federal do Cear\u00e1","ror":"https://ror.org/03srtnf24","country_code":"BR","type":"education","lineage":["https://openalex.org/I243754102"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Angelo Brayner","raw_affiliation_strings":["Federal University of Cear\u00e1 (UFC)"],"affiliations":[{"raw_affiliation_string":"Federal University of Cear\u00e1 (UFC)","institution_ids":["https://openalex.org/I243754102"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108651387","display_name":"Jos\u00e9 Maria Monteiro","orcid":null},"institutions":[{"id":"https://openalex.org/I243754102","display_name":"Universidade Federal do Cear\u00e1","ror":"https://ror.org/03srtnf24","country_code":"BR","type":"education","lineage":["https://openalex.org/I243754102"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 Maria Monteiro","raw_affiliation_strings":["Federal University of Cear\u00e1 (UFC)"],"affiliations":[{"raw_affiliation_string":"Federal University of Cear\u00e1 (UFC)","institution_ids":["https://openalex.org/I243754102"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085416987","display_name":"S\u00e9rgio Lifschitz","orcid":"https://orcid.org/0000-0003-3073-3734"},"institutions":[{"id":"https://openalex.org/I2699952","display_name":"Pontif\u00edcia Universidade Cat\u00f3lica do Rio de Janeiro","ror":"https://ror.org/01dg47b60","country_code":"BR","type":"education","lineage":["https://openalex.org/I2699952"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"S\u00e9rgio Lifschitz","raw_affiliation_strings":["Pontifical Catholic University of Rio de Janeiro (PUC-Rio)"],"affiliations":[{"raw_affiliation_string":"Pontifical Catholic University of Rio de Janeiro (PUC-Rio)","institution_ids":["https://openalex.org/I2699952"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5047815116","display_name":"Rafael Pereira de Oliveira","orcid":"https://orcid.org/0009-0005-2697-4668"},"institutions":[{"id":"https://openalex.org/I2699952","display_name":"Pontif\u00edcia Universidade Cat\u00f3lica do Rio de Janeiro","ror":"https://ror.org/01dg47b60","country_code":"BR","type":"education","lineage":["https://openalex.org/I2699952"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Rafael Pereira de Oliveira","raw_affiliation_strings":["Pontifical Catholic University of Rio de Janeiro (PUC-Rio)"],"affiliations":[{"raw_affiliation_string":"Pontifical Catholic University of Rio de Janeiro (PUC-Rio)","institution_ids":["https://openalex.org/I2699952"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5103058231"],"corresponding_institution_ids":["https://openalex.org/I40034438"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.24695594,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"115","last_page":"120"},"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.9995999932289124,"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.9995999932289124,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9991999864578247,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9984999895095825,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8319246768951416},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.6814098954200745},{"id":"https://openalex.org/keywords/physical-design","display_name":"Physical design","score":0.5330798625946045},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5178844928741455},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.4888579249382019},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4750637710094452},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.45883387327194214},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4512655735015869},{"id":"https://openalex.org/keywords/resource","display_name":"Resource (disambiguation)","score":0.42685019969940186},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.320254921913147},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.15276101231575012},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.10539093613624573}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8319246768951416},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.6814098954200745},{"id":"https://openalex.org/C188817802","wikidata":"https://www.wikidata.org/wiki/Q13426855","display_name":"Physical design","level":3,"score":0.5330798625946045},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5178844928741455},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.4888579249382019},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4750637710094452},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.45883387327194214},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4512655735015869},{"id":"https://openalex.org/C206345919","wikidata":"https://www.wikidata.org/wiki/Q20380951","display_name":"Resource (disambiguation)","level":2,"score":0.42685019969940186},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.320254921913147},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.15276101231575012},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.10539093613624573},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C190560348","wikidata":"https://www.wikidata.org/wiki/Q3245116","display_name":"Circuit design","level":2,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.5753/sbbd.2016.24314","is_oa":true,"landing_page_url":"https://doi.org/10.5753/sbbd.2016.24314","pdf_url":"https://sol.sbc.org.br/index.php/sbbd/article/download/24314/24137","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Anais do XXXI Simp\u00f3sio Brasileiro de Banco de Dados (SBBD 2016)","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.5753/sbbd.2016.24314","is_oa":true,"landing_page_url":"https://doi.org/10.5753/sbbd.2016.24314","pdf_url":"https://sol.sbc.org.br/index.php/sbbd/article/download/24314/24137","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Anais do XXXI Simp\u00f3sio Brasileiro de Banco de Dados (SBBD 2016)","raw_type":"proceedings-article"},"sustainable_development_goals":[{"score":0.5899999737739563,"display_name":"Decent work and economic growth","id":"https://metadata.un.org/sdg/8"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2613600412.pdf"},"referenced_works_count":12,"referenced_works":["https://openalex.org/W371957946","https://openalex.org/W1991571419","https://openalex.org/W2020272913","https://openalex.org/W2071508218","https://openalex.org/W2135279969","https://openalex.org/W2168406720","https://openalex.org/W2170870260","https://openalex.org/W2949924328","https://openalex.org/W6612699595","https://openalex.org/W6655725731","https://openalex.org/W6668410969","https://openalex.org/W7014261490"],"related_works":["https://openalex.org/W325713583","https://openalex.org/W2512945146","https://openalex.org/W2483382562","https://openalex.org/W2101197724","https://openalex.org/W2762065037","https://openalex.org/W2626533837","https://openalex.org/W2027048017","https://openalex.org/W2044272255","https://openalex.org/W289370537","https://openalex.org/W2355364777"],"abstract_inverted_index":{"It":[0],"is":[1,10,49,58,69,78,140],"well-known":[2],"that":[3,73,138],"fine":[4],"tuning":[5],"in":[6,89,101],"database":[7,32,87,129],"physical":[8,86,130],"design":[9,131],"an":[11],"important":[12],"strategy":[13],"for":[14,127],"speeding":[15],"up":[16],"data":[17],"access.":[18],"In":[19,54,113],"this":[20,55,102,125],"paper,":[21],"we":[22,99,122],"introduce":[23],"a":[24,108],"new":[25],"approach,":[26,121],"denoted":[27],"HypoPlans,":[28],"to":[29,35,80,91,94,115],"make":[30],"relational":[31],"systems":[33],"able":[34,79],"execute":[36],"self-tuning":[37],"actions,":[38],"based":[39,70],"on":[40,71,83],"the":[41,84,104,117,128],"notion":[42],"of":[43,107,119],"Hypothetical":[44],"Query":[45],"Execution":[46],"Plans.":[47],"HypoPlans":[48,77,139],"non-intrusive":[50],"and":[51,60,143],"completely":[52],"autonomous.":[53],"sense,":[56],"it":[57],"DBMS-independent":[59],"does":[61],"not":[62],"require":[63],"any":[64],"DBA":[65],"intervention.":[66],"Our":[67,135],"approach":[68],"heuristics":[72],"run":[74],"continuously.":[75],"Thus,":[76],"guide":[81],"decisions":[82],"current":[85],"configuration":[88],"order":[90,114],"dynamically":[92],"react":[93],"workload":[95],"changes.":[96],"More":[97],"specifically,":[98],"present":[100],"paper":[103],"software":[105],"architecture":[106],"framework,":[109],"which":[110],"implements":[111],"HypoPlans.":[112],"evaluate":[116],"viability":[118],"our":[120],"have":[123],"instantiated":[124],"framework":[126],"concerning":[132],"index":[133],"(self)tuning.":[134],"experiments":[136],"show":[137],"quite":[141],"effective":[142],"efficient,":[144],"also":[145],"presenting":[146],"low":[147],"resource":[148],"consumption.":[149]},"counts_by_year":[],"updated_date":"2026-02-27T16:54:17.756197","created_date":"2025-10-10T00:00:00"}