{"id":"https://openalex.org/W4414003897","doi":"https://doi.org/10.14778/3749646.3749661","title":"PBench: Workload Synthesizer with Real Statistics for Cloud Analytics Benchmarking","display_name":"PBench: Workload Synthesizer with Real Statistics for Cloud Analytics Benchmarking","publication_year":2025,"publication_date":"2025-07-01","ids":{"openalex":"https://openalex.org/W4414003897","doi":"https://doi.org/10.14778/3749646.3749661"},"language":"en","primary_location":{"id":"doi:10.14778/3749646.3749661","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3749646.3749661","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":"Proceedings of the VLDB Endowment","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/A5115597228","display_name":"Yan Zhou","orcid":"https://orcid.org/0009-0009-4564-4014"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Yan Zhou","raw_affiliation_strings":["Renmin University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Renmin University, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101508204","display_name":"Chunwei Liu","orcid":"https://orcid.org/0000-0003-1481-2678"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chunwei Liu","raw_affiliation_strings":["MIT CSAIL"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030643132","display_name":"Bhuvan Urgaonkar","orcid":"https://orcid.org/0000-0003-3495-6345"},"institutions":[{"id":"https://openalex.org/I4210127693","display_name":"Penn Center for AIDS Research","ror":"https://ror.org/047939x15","country_code":"US","type":"facility","lineage":["https://openalex.org/I102322052","https://openalex.org/I1335321130","https://openalex.org/I4210127693","https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Bhuvan Urgaonkar","raw_affiliation_strings":["Penn State and AWS"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Penn State and AWS","institution_ids":["https://openalex.org/I4210127693"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024281418","display_name":"Zhengle Wang","orcid":null},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhengle Wang","raw_affiliation_strings":["Renmin University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Renmin University, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038236673","display_name":"Magnus Mueller","orcid":null},"institutions":[{"id":"https://openalex.org/I1311688040","display_name":"Amazon (United States)","ror":"https://ror.org/04mv4n011","country_code":"US","type":"company","lineage":["https://openalex.org/I1311688040"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Magnus Mueller","raw_affiliation_strings":["Amazon Web Services"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100460074","display_name":"Chao Zhang","orcid":"https://orcid.org/0000-0001-6418-8370"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chao Zhang","raw_affiliation_strings":["Renmin University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Renmin University, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078175663","display_name":"Songyue Zhang","orcid":null},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Songyue Zhang","raw_affiliation_strings":["Renmin University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Renmin University, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063387634","display_name":"Pascal Pfeil","orcid":"https://orcid.org/0009-0001-6719-604X"},"institutions":[{"id":"https://openalex.org/I1311688040","display_name":"Amazon (United States)","ror":"https://ror.org/04mv4n011","country_code":"US","type":"company","lineage":["https://openalex.org/I1311688040"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Pascal Pfeil","raw_affiliation_strings":["Amazon Web Services"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039503096","display_name":"Dominik Horn","orcid":"https://orcid.org/0009-0009-4489-1638"},"institutions":[{"id":"https://openalex.org/I1311688040","display_name":"Amazon (United States)","ror":"https://ror.org/04mv4n011","country_code":"US","type":"company","lineage":["https://openalex.org/I1311688040"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dominik Horn","raw_affiliation_strings":["Amazon Web Services"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036839849","display_name":"Zhengchun Liu","orcid":"https://orcid.org/0000-0002-2897-8663"},"institutions":[{"id":"https://openalex.org/I1311688040","display_name":"Amazon (United States)","ror":"https://ror.org/04mv4n011","country_code":"US","type":"company","lineage":["https://openalex.org/I1311688040"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zhengchun Liu","raw_affiliation_strings":["Amazon Web Services"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5098770043","display_name":"Davide Pagano","orcid":"https://orcid.org/0009-0002-5746-3527"},"institutions":[{"id":"https://openalex.org/I1311688040","display_name":"Amazon (United States)","ror":"https://ror.org/04mv4n011","country_code":"US","type":"company","lineage":["https://openalex.org/I1311688040"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Davide Pagano","raw_affiliation_strings":["Amazon Web Services"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034086130","display_name":"Tim Kraska","orcid":"https://orcid.org/0009-0003-2414-2759"},"institutions":[{"id":"https://openalex.org/I4210109586","display_name":"Moscow Institute of Thermal Technology","ror":"https://ror.org/021es5e59","country_code":"RU","type":"facility","lineage":["https://openalex.org/I4210109586"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"Tim Kraska","raw_affiliation_strings":["MIT and AWS"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT and AWS","institution_ids":["https://openalex.org/I4210109586"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Samuel Madden","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Samuel Madden","raw_affiliation_strings":["MIT CSAIL"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5005840337","display_name":"Ju Fan","orcid":null},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ju Fan","raw_affiliation_strings":["Renmin University, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Renmin University, China","institution_ids":["https://openalex.org/I78988378"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":14,"corresponding_author_ids":["https://openalex.org/A5115597228"],"corresponding_institution_ids":["https://openalex.org/I78988378"],"apc_list":null,"apc_paid":null,"fwci":8.4146,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.97477299,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":98},"biblio":{"volume":"18","issue":"11","first_page":"3883","last_page":"3895"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9994999766349792,"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":0.9994999766349792,"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.9921000003814697,"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/T12127","display_name":"Software System Performance and Reliability","score":0.9907000064849854,"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/benchmarking","display_name":"Benchmarking","score":0.8584513664245605},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.82234787940979},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.7310619354248047},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.6930091381072998},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.652338981628418},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4828370213508606},{"id":"https://openalex.org/keywords/data-analysis","display_name":"Data analysis","score":0.4295714497566223},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2686593234539032},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.18374976515769958},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.08025085926055908}],"concepts":[{"id":"https://openalex.org/C86251818","wikidata":"https://www.wikidata.org/wiki/Q816754","display_name":"Benchmarking","level":2,"score":0.8584513664245605},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.82234787940979},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.7310619354248047},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.6930091381072998},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.652338981628418},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4828370213508606},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.4295714497566223},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2686593234539032},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.18374976515769958},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.08025085926055908},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3749646.3749661","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3749646.3749661","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W95608104","https://openalex.org/W1976216569","https://openalex.org/W1985229168","https://openalex.org/W2152603468","https://openalex.org/W2396309311","https://openalex.org/W2430301697","https://openalex.org/W2613206411","https://openalex.org/W2776176772","https://openalex.org/W3022398217","https://openalex.org/W3082181878","https://openalex.org/W3174749316","https://openalex.org/W3197943238","https://openalex.org/W3208930906","https://openalex.org/W4281718197","https://openalex.org/W4282556381","https://openalex.org/W4285451014","https://openalex.org/W4312274205","https://openalex.org/W4366492460","https://openalex.org/W4379382789","https://openalex.org/W4396571399","https://openalex.org/W4398234120","https://openalex.org/W4399156224","https://openalex.org/W4400071957","https://openalex.org/W4402041923","https://openalex.org/W6891959504"],"related_works":["https://openalex.org/W2547038763","https://openalex.org/W4226266853","https://openalex.org/W4210252074","https://openalex.org/W3092201768","https://openalex.org/W2796632413","https://openalex.org/W2740083192","https://openalex.org/W2794907032","https://openalex.org/W4255802207","https://openalex.org/W4299701476","https://openalex.org/W2904574413"],"abstract_inverted_index":{"Cloud":[0],"service":[1],"providers":[2],"commonly":[3],"use":[4],"standard":[5],"benchmarks":[6,21,125],"like":[7],"TPC-H":[8],"and":[9,13,27,65,98,119,126,149,189],"TPC-DS":[10],"to":[11,29,161,181,205,224,227],"evaluate":[12],"optimize":[14],"cloud":[15,36,40],"data":[16],"analytics":[17],"systems.":[18],"However,":[19],"these":[20,49],"rely":[22],"on":[23],"fixed":[24],"query":[25],"patterns":[26],"fail":[28],"capture":[30,162],"real":[31,46,81,91,167],"execution":[32,92],"statistics":[33,82],"of":[34,77,145,166],"production":[35],"workloads.":[37],"Although":[38],"some":[39],"database":[41],"vendors":[42],"have":[43],"recently":[44],"released":[45],"workload":[47,78,110,121,130,178,188,208],"traces,":[48],"traces":[50],"alone":[51],"do":[52],"not":[53],"qualify":[54],"as":[55,57],"benchmarks,":[56],"they":[58],"typically":[59],"lack":[60],"essential":[61],"components":[62,122,209],"(i.e.,":[63],"queries":[64],"databases).":[66],"To":[67,101],"overcome":[68],"this":[69,71,103],"limitation,":[70],"paper":[72,133],"studies":[73,134],"a":[74,108,154,171,195],"new":[75,129],"problem":[76],"synthesis":[79],"with":[80],",":[83],"which":[84],"generates":[85],"synthetic":[86,114],"workloads":[87,115],"that":[88,112,175,199,217],"closely":[89],"approximate":[90],"statistics,":[93],"including":[94],"key":[95,136],"performance":[96,147],"metrics":[97,148],"operator":[99,150],"distributions.":[100],"address":[102,142],"problem,":[104],"we":[105,141,169,193],"propose":[106,194],"PBench,":[107],"novel":[109],"synthesizer":[111],"constructs":[113],"by":[116,152,222],"(1)":[117],"selecting":[118],"combining":[120],"from":[123],"existing":[124],"(2)":[127],"augmenting":[128],"components.":[131],"This":[132],"the":[135,143,163,183,186,190],"challenges":[137],"in":[138],"PBench.":[139],"First,":[140],"challenge":[144],"balancing":[146],"distributions":[151],"introducing":[153],"multi-objective":[155],"optimization-based":[156],"component":[157,196],"selection":[158],"method.":[159],"Second,":[160],"temporal":[164],"dynamics":[165],"workloads,":[168],"design":[170],"timestamp":[172],"assignment":[173],"method":[174],"progressively":[176],"reines":[177],"timestamps.":[179],"Third,":[180],"handle":[182],"disparity":[184],"between":[185],"original":[187],"candidate":[191],"workload,":[192],"augmentation":[197],"approach":[198],"leverages":[200],"large":[201],"language":[202],"models":[203],"(LLMs)":[204],"generate":[206],"additional":[207],"while":[210],"maintaining":[211],"statistical":[212],"idelity.":[213],"Experimental":[214],"results":[215],"show":[216],"PBench":[218],"reduces":[219],"approximation":[220],"error":[221],"up":[223],"6X":[225],"compared":[226],"state-of-the-art":[228],"methods.":[229]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2}],"updated_date":"2026-05-05T08:41:31.759640","created_date":"2025-10-10T00:00:00"}