{"id":"https://openalex.org/W1967155922","doi":"https://doi.org/10.1145/1670243.1670250","title":"Automatic virtual machine configuration for database workloads","display_name":"Automatic virtual machine configuration for database workloads","publication_year":2008,"publication_date":"2008-02-15","ids":{"openalex":"https://openalex.org/W1967155922","doi":"https://doi.org/10.1145/1670243.1670250","mag":"1967155922"},"language":"en","primary_location":{"id":"doi:10.1145/1670243.1670250","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1670243.1670250","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"type":"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":true,"raw_author_name":"Ahmed A. Soror","raw_affiliation_strings":["University of Waterloo, Ontario","University of Waterloo, Ontario#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Ontario","institution_ids":["https://openalex.org/I151746483"]},{"raw_affiliation_string":"University of Waterloo, Ontario#TAB#","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, Ontario","University of Waterloo, Ontario#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Ontario","institution_ids":["https://openalex.org/I151746483"]},{"raw_affiliation_string":"University of Waterloo, Ontario#TAB#","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, Ontario","University of Waterloo, Ontario#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Ontario","institution_ids":["https://openalex.org/I151746483"]},{"raw_affiliation_string":"University of Waterloo, Ontario#TAB#","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035977189","display_name":"Kenneth Salem","orcid":"https://orcid.org/0000-0003-0409-9725"},"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, Ontario","University of Waterloo, Ontario#TAB#"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Ontario","institution_ids":["https://openalex.org/I151746483"]},{"raw_affiliation_string":"University of Waterloo, Ontario#TAB#","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/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"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","US"],"is_corresponding":false,"raw_author_name":"Peter Kokosielis","raw_affiliation_strings":["IBM Toronto Lab, Toronto, Canada","IBM Toronto Lab., Toronto, Canada#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Toronto Lab, Toronto, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM Toronto Lab., Toronto, Canada#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5001983907","display_name":"Sunil Kamath","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"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","US"],"is_corresponding":false,"raw_author_name":"Sunil Kamath","raw_affiliation_strings":["IBM Toronto Lab, Toronto, Canada","IBM Toronto Lab., Toronto, Canada#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Toronto Lab, Toronto, Canada","institution_ids":["https://openalex.org/I4210113654"]},{"raw_affiliation_string":"IBM Toronto Lab., Toronto, Canada#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5080750213"],"corresponding_institution_ids":["https://openalex.org/I151746483"],"apc_list":null,"apc_paid":null,"fwci":7.873,"has_fulltext":false,"cited_by_count":61,"citation_normalized_percentile":{"value":0.96878756,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"35","issue":"1","first_page":"1","last_page":"47"},"is_retracted":false,"is_paratext":false,"is_xpac":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.9969000220298767,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9930999875068665,"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.9226014018058777},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.7488754391670227},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6727597117424011},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6040835380554199},{"id":"https://openalex.org/keywords/software-deployment","display_name":"Software deployment","score":0.6025534272193909},{"id":"https://openalex.org/keywords/virtual-machine","display_name":"Virtual machine","score":0.5904344320297241},{"id":"https://openalex.org/keywords/virtualization","display_name":"Virtualization","score":0.47747015953063965},{"id":"https://openalex.org/keywords/temporal-isolation-among-virtual-machines","display_name":"Temporal isolation among virtual machines","score":0.4418529272079468},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.4370894134044647},{"id":"https://openalex.org/keywords/hypervisor","display_name":"Hypervisor","score":0.4146645963191986},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.39599794149398804},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.3314417600631714},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.31458765268325806},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.11074143648147583}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9226014018058777},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.7488754391670227},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6727597117424011},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6040835380554199},{"id":"https://openalex.org/C105339364","wikidata":"https://www.wikidata.org/wiki/Q2297740","display_name":"Software deployment","level":2,"score":0.6025534272193909},{"id":"https://openalex.org/C25344961","wikidata":"https://www.wikidata.org/wiki/Q192726","display_name":"Virtual machine","level":2,"score":0.5904344320297241},{"id":"https://openalex.org/C513985346","wikidata":"https://www.wikidata.org/wiki/Q270471","display_name":"Virtualization","level":3,"score":0.47747015953063965},{"id":"https://openalex.org/C142355369","wikidata":"https://www.wikidata.org/wiki/Q7698919","display_name":"Temporal isolation among virtual machines","level":4,"score":0.4418529272079468},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.4370894134044647},{"id":"https://openalex.org/C112904061","wikidata":"https://www.wikidata.org/wiki/Q1077480","display_name":"Hypervisor","level":4,"score":0.4146645963191986},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.39599794149398804},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.3314417600631714},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.31458765268325806},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.11074143648147583}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/1670243.1670250","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1670243.1670250","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.216.8785","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.216.8785","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.uwaterloo.ca/~ashraf/pubs/sigmod08vmconf.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.392.4788","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.392.4788","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://cs.uwaterloo.ca/~ashraf/pubs/tods10vmconf.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.500.2278","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.500.2278","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://cs.uwaterloo.ca/~aakssoro/pubs/soror_sigmod08.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W115429978","https://openalex.org/W138849684","https://openalex.org/W175221152","https://openalex.org/W1480732106","https://openalex.org/W1531774622","https://openalex.org/W1571043125","https://openalex.org/W1604438401","https://openalex.org/W1949751419","https://openalex.org/W1964297545","https://openalex.org/W1966683859","https://openalex.org/W1971222141","https://openalex.org/W1983224729","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","https://openalex.org/W6604836748"],"related_works":["https://openalex.org/W2148749405","https://openalex.org/W4249709097","https://openalex.org/W2104105430","https://openalex.org/W1515917392","https://openalex.org/W2743348030","https://openalex.org/W1973516247","https://openalex.org/W2179519055","https://openalex.org/W1991063492","https://openalex.org/W2155350341","https://openalex.org/W4256143806"],"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,105,111,124,127,135,142,146,158],"deployment":[9,125],"of":[10,47,55,59,68,108,110,126,148],"database":[11,31,61,92,112],"management":[12,32,62],"systems":[13,63,113],"and":[14,137,174,176,185],"other":[15],"enterprise":[16],"software.":[17],"In":[18],"this":[19],"article,":[20],"we":[21,156,177],"consider":[22],"a":[23,38,44,97,149,162],"common":[24,45],"resource":[25,151],"consolidation":[26],"scenario":[27],"in":[28,37,72,141,161],"which":[29,73],"several":[30],"system":[33,93],"instances,":[34],"each":[35,109],"running":[36],"separate":[39],"virtual":[40,70,77],"machine,":[41],"sharing":[43],"pool":[46],"physical":[48,84],"computing":[49],"resources.":[50],"We":[51,95,166],"address":[52],"problem":[54],"optimizing":[56],"performance":[58],"these":[60],"by":[64],"controlling":[65],"configurations":[67,79,117,129],"machines":[71],"they":[74],"run.":[75],"These":[76],"determine":[80],"how":[81],"shared":[83],"resources":[85],"will":[86],"be":[87,131],"allocated":[88],"to":[89,114,133,138],"different":[91],"instances.":[94],"introduce":[96],"virtualization":[98],"design":[99],"advisor":[100],"that":[101],"uses":[102],"information":[103,121],"about":[104],"anticipated":[106],"workloads":[107],"recommend":[115],"workload-specific":[116],"offline.":[118],"Furthermore,":[119],"runtime":[120],"collected":[122],"after":[123],"recommended":[128],"can":[130],"used":[132],"refine":[134],"recommendation":[136],"handle":[139],"changes":[140],"workload.":[143],"To":[144],"estimate":[145],"effect":[147],"particular":[150],"allocation":[152],"on":[153],"workload":[154],"performance,":[155],"use":[157],"query":[159],"optimizer":[160],"new":[163],"what-if":[164],"mode.":[165],"have":[167,178],"implemented":[168],"our":[169],"approach":[170],"using":[171,183],"both":[172],"PostgreSQL":[173],"DB2,":[175],"experimentally":[179],"evaluated":[180],"its":[181],"effectiveness":[182],"DSS":[184],"OLTP":[186],"workloads.":[187]},"counts_by_year":[{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":9},{"year":2014,"cited_by_count":10},{"year":2013,"cited_by_count":11},{"year":2012,"cited_by_count":8}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}