{"id":"https://openalex.org/W1983224729","doi":"https://doi.org/10.1145/1376616.1376711","title":"Automatic virtual machine configuration for database workloads","display_name":"Automatic virtual machine configuration for database workloads","publication_year":2008,"publication_date":"2008-06-09","ids":{"openalex":"https://openalex.org/W1983224729","doi":"https://doi.org/10.1145/1376616.1376711","mag":"1983224729"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376711","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5080750213","display_name":"Ahmed A. Soror","orcid":null},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Ahmed A. Soror","raw_affiliation_strings":["University of Waterloo, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, ON, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032253873","display_name":"Umar Farooq Minhas","orcid":"https://orcid.org/0009-0005-6520-3794"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Umar Farooq Minhas","raw_affiliation_strings":["University of Waterloo, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, ON, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000416532","display_name":"Ashraf Aboulnaga","orcid":"https://orcid.org/0000-0001-6693-7099"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Ashraf Aboulnaga","raw_affiliation_strings":["University of Waterloo, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, ON, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035977189","display_name":"Kenneth Salem","orcid":null},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Kenneth Salem","raw_affiliation_strings":["University of Waterloo, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, ON, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007083724","display_name":"Peter Kokosielis","orcid":null},"institutions":[{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Peter Kokosielis","raw_affiliation_strings":["IBM Toronto Lab, Toronto, ON, Canada"],"affiliations":[{"raw_affiliation_string":"IBM Toronto Lab, Toronto, ON, Canada","institution_ids":["https://openalex.org/I4210113654"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5001983907","display_name":"Sunil Kamath","orcid":null},"institutions":[{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Sunil Kamath","raw_affiliation_strings":["IBM Toronto Lab, Toronto, ON, Canada"],"affiliations":[{"raw_affiliation_string":"IBM Toronto Lab, Toronto, ON, Canada","institution_ids":["https://openalex.org/I4210113654"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":8.71,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":119,"citation_normalized_percentile":{"value":0.94525,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"953","last_page":"966"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":1.0,"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"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":1.0,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9966,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9938,"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":[],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8899044},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.7885054},{"id":"https://openalex.org/C105339364","wikidata":"https://www.wikidata.org/wiki/Q2297740","display_name":"Software deployment","level":2,"score":0.61909866},{"id":"https://openalex.org/C25344961","wikidata":"https://www.wikidata.org/wiki/Q192726","display_name":"Virtual machine","level":2,"score":0.6037933},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5927511},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.58328146},{"id":"https://openalex.org/C513985346","wikidata":"https://www.wikidata.org/wiki/Q270471","display_name":"Virtualization","level":3,"score":0.4954983},{"id":"https://openalex.org/C142355369","wikidata":"https://www.wikidata.org/wiki/Q7698919","display_name":"Temporal isolation among virtual machines","level":4,"score":0.47357902},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.46185884},{"id":"https://openalex.org/C112904061","wikidata":"https://www.wikidata.org/wiki/Q1077480","display_name":"Hypervisor","level":4,"score":0.452449},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.4452869},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.40270314},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.33995837},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.28800225},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.27029115},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.22090423},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.13522017}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376711","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":34,"referenced_works":["https://openalex.org/W115429978","https://openalex.org/W138849684","https://openalex.org/W1480732106","https://openalex.org/W1531774622","https://openalex.org/W1571043125","https://openalex.org/W1604438401","https://openalex.org/W175221152","https://openalex.org/W1949751419","https://openalex.org/W1964297545","https://openalex.org/W1966683859","https://openalex.org/W1971222141","https://openalex.org/W1991257268","https://openalex.org/W1997269120","https://openalex.org/W2037759385","https://openalex.org/W2049263029","https://openalex.org/W2085463701","https://openalex.org/W2097175800","https://openalex.org/W2099023682","https://openalex.org/W2102303750","https://openalex.org/W2103375760","https://openalex.org/W2108060598","https://openalex.org/W2109239225","https://openalex.org/W2116462291","https://openalex.org/W2117406969","https://openalex.org/W2122012536","https://openalex.org/W2124954621","https://openalex.org/W2131726714","https://openalex.org/W2132579178","https://openalex.org/W2135323989","https://openalex.org/W2136290019","https://openalex.org/W2140764275","https://openalex.org/W2142994777","https://openalex.org/W2167942260","https://openalex.org/W4244704438"],"related_works":["https://openalex.org/W871343079","https://openalex.org/W4256143806","https://openalex.org/W4249709097","https://openalex.org/W3142238991","https://openalex.org/W2997368697","https://openalex.org/W2937922288","https://openalex.org/W2545898663","https://openalex.org/W2155350341","https://openalex.org/W1991699991","https://openalex.org/W1985467476"],"abstract_inverted_index":{"Virtual":[0],"machine":[1,78],"monitors":[2],"are":[3,42],"becoming":[4],"popular":[5],"tools":[6],"for":[7],"the":[8,53,57,66,69,82,90,104,110,123,126,134,138,150],"deployment":[9,124],"of":[10,47,55,59,68,107,109,125,140],"database":[11,32,61,92,111],"management":[12,33,62],"systems":[13,63,112],"and":[14,166,168,177],"other":[15],"enterprise":[16],"software":[17],"applications.":[18],"In":[19],"this":[20],"paper,":[21],"we":[22,148,169],"consider":[23],"a":[24,39,44,96,141,154],"common":[25,45],"resource":[26,143],"consolidation":[27],"scenario,":[28],"in":[29,38,72,153],"which":[30,73],"several":[31],"system":[34],"instances,":[35],"each":[36,108],"running":[37],"virtual":[40,70,77],"machine,":[41],"sharing":[43],"pool":[46],"physical":[48,84],"computing":[49],"resources.":[50],"We":[51,94,158],"address":[52],"problem":[54],"optimizing":[56],"performance":[58],"these":[60],"by":[64],"controlling":[65],"configurations":[67,79,116,128],"machines":[71],"they":[74],"run.":[75],"These":[76],"determine":[80],"how":[81],"shared":[83],"resources":[85],"will":[86],"be":[87,130],"allocated":[88],"to":[89,113,132],"different":[91],"instances.":[93],"introduce":[95],"virtualization":[97],"design":[98],"advisor":[99],"that":[100],"uses":[101],"information":[102,120],"about":[103],"anticipated":[105],"workloads":[106],"recommend":[114],"workload-specific":[115],"offine.":[117],"Furthermore,":[118],"runtime":[119],"collected":[121],"after":[122],"recommended":[127],"can":[129],"used":[131],"refine":[133],"recommendation.":[135],"To":[136],"estimate":[137],"effect":[139],"particular":[142],"allocation":[144],"on":[145],"workload":[146],"performance,":[147],"use":[149],"query":[151],"optimizer":[152],"new":[155],"what-if":[156],"mode.":[157],"have":[159,170],"implemented":[160],"our":[161],"approach":[162],"using":[163,175],"both":[164],"PostgreSQL":[165],"DB2,":[167],"experimentally":[171],"evaluated":[172],"its":[173],"effectiveness":[174],"DSS":[176],"OLTP":[178],"workloads.":[179]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1983224729","counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":8},{"year":2014,"cited_by_count":12},{"year":2013,"cited_by_count":18},{"year":2012,"cited_by_count":22}],"updated_date":"2025-01-17T13:19:45.470549","created_date":"2016-06-24"}