{"id":"https://openalex.org/W4409218856","doi":"https://doi.org/10.14778/3712221.3712236","title":"PolyBase: Adapting to Data Affinity Changes in Geo-Replicated Database via Row-Level Consensus-Group Affiliation Re-Assignment","display_name":"PolyBase: Adapting to Data Affinity Changes in Geo-Replicated Database via Row-Level Consensus-Group Affiliation Re-Assignment","publication_year":2024,"publication_date":"2024-11-01","ids":{"openalex":"https://openalex.org/W4409218856","doi":"https://doi.org/10.14778/3712221.3712236"},"language":"en","primary_location":{"id":"doi:10.14778/3712221.3712236","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3712221.3712236","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/A5075133929","display_name":"Chaoyi Ruan","orcid":null},"institutions":[{"id":"https://openalex.org/I91090688","display_name":"University of Science and Technology Chittagong","ror":"https://ror.org/00w9tx359","country_code":"BD","type":"education","lineage":["https://openalex.org/I91090688"]}],"countries":["BD"],"is_corresponding":true,"raw_author_name":"Chaoyi Ruan","raw_affiliation_strings":["USTC"],"affiliations":[{"raw_affiliation_string":"USTC","institution_ids":["https://openalex.org/I91090688"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086518888","display_name":"Yingqiang Zhang","orcid":"https://orcid.org/0000-0003-0945-7405"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yingqiang Zhang","raw_affiliation_strings":["AZFT"],"affiliations":[{"raw_affiliation_string":"AZFT","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057897708","display_name":"Juncheng Zhang","orcid":"https://orcid.org/0000-0002-1701-1764"},"institutions":[{"id":"https://openalex.org/I91090688","display_name":"University of Science and Technology Chittagong","ror":"https://ror.org/00w9tx359","country_code":"BD","type":"education","lineage":["https://openalex.org/I91090688"]}],"countries":["BD"],"is_corresponding":false,"raw_author_name":"Juncheng Zhang","raw_affiliation_strings":["USTC"],"affiliations":[{"raw_affiliation_string":"USTC","institution_ids":["https://openalex.org/I91090688"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100354226","display_name":"Cheng Li","orcid":"https://orcid.org/0000-0001-7064-6120"},"institutions":[{"id":"https://openalex.org/I91090688","display_name":"University of Science and Technology Chittagong","ror":"https://ror.org/00w9tx359","country_code":"BD","type":"education","lineage":["https://openalex.org/I91090688"]}],"countries":["BD"],"is_corresponding":false,"raw_author_name":"Cheng Li","raw_affiliation_strings":["USTC"],"affiliations":[{"raw_affiliation_string":"USTC","institution_ids":["https://openalex.org/I91090688"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057826903","display_name":"Xiaosong Ma","orcid":"https://orcid.org/0000-0002-9527-0171"},"institutions":[{"id":"https://openalex.org/I4210113480","display_name":"Mohamed bin Zayed University of Artificial Intelligence","ror":"https://ror.org/0258gkt32","country_code":"AE","type":"education","lineage":["https://openalex.org/I4210113480"]}],"countries":["AE"],"is_corresponding":false,"raw_author_name":"Xiaosong Ma","raw_affiliation_strings":["MBZUAI"],"affiliations":[{"raw_affiliation_string":"MBZUAI","institution_ids":["https://openalex.org/I4210113480"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100353492","display_name":"Hao Chen","orcid":"https://orcid.org/0000-0001-8249-7046"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hao Chen","raw_affiliation_strings":["AZFT"],"affiliations":[{"raw_affiliation_string":"AZFT","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100770464","display_name":"Jie Zhou","orcid":"https://orcid.org/0000-0002-5899-5165"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jie Zhou","raw_affiliation_strings":["AZFT"],"affiliations":[{"raw_affiliation_string":"AZFT","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064326794","display_name":"Feifei Li","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Feifei Li","raw_affiliation_strings":["AZFT"],"affiliations":[{"raw_affiliation_string":"AZFT","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5000702647","display_name":"Xinjun Yang","orcid":"https://orcid.org/0000-0001-8507-4444"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xinjun Yang","raw_affiliation_strings":["AZFT"],"affiliations":[{"raw_affiliation_string":"AZFT","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":9,"corresponding_author_ids":["https://openalex.org/A5075133929"],"corresponding_institution_ids":["https://openalex.org/I91090688"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.34902203,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"18","issue":"3","first_page":"702","last_page":"714"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":1.0,"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/T10772","display_name":"Distributed systems and fault tolerance","score":1.0,"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.9988999962806702,"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/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"}}],"keywords":[{"id":"https://openalex.org/keywords/group","display_name":"Group (periodic table)","score":0.5435630083084106},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4137556552886963},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.39061951637268066},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.32230621576309204},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.3215640187263489},{"id":"https://openalex.org/keywords/chemistry","display_name":"Chemistry","score":0.15119194984436035}],"concepts":[{"id":"https://openalex.org/C2781311116","wikidata":"https://www.wikidata.org/wiki/Q83306","display_name":"Group (periodic table)","level":2,"score":0.5435630083084106},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4137556552886963},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.39061951637268066},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.32230621576309204},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.3215640187263489},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.15119194984436035},{"id":"https://openalex.org/C178790620","wikidata":"https://www.wikidata.org/wiki/Q11351","display_name":"Organic chemistry","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3712221.3712236","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3712221.3712236","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":28,"referenced_works":["https://openalex.org/W1562944819","https://openalex.org/W2016404663","https://openalex.org/W2021651899","https://openalex.org/W2064710146","https://openalex.org/W2085422792","https://openalex.org/W2101939036","https://openalex.org/W2612808231","https://openalex.org/W2734941459","https://openalex.org/W2790634852","https://openalex.org/W2913379027","https://openalex.org/W2962756066","https://openalex.org/W2970956651","https://openalex.org/W2971005438","https://openalex.org/W2996998733","https://openalex.org/W3085924233","https://openalex.org/W3137759927","https://openalex.org/W4200208024","https://openalex.org/W4231524450","https://openalex.org/W4235985664","https://openalex.org/W4237498818","https://openalex.org/W4246662059","https://openalex.org/W4285451014","https://openalex.org/W4286447321","https://openalex.org/W4301461621","https://openalex.org/W4366563391","https://openalex.org/W4380433157","https://openalex.org/W4381329151","https://openalex.org/W6686169942"],"related_works":["https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W4391375266","https://openalex.org/W1979597421","https://openalex.org/W2007980826","https://openalex.org/W2061531152","https://openalex.org/W3002753104","https://openalex.org/W2077600819","https://openalex.org/W2142036596","https://openalex.org/W2072657027"],"abstract_inverted_index":{"Transaction":[0],"performance":[1],"in":[2],"geo-replicated":[3],"databases":[4,148],"heavily":[5],"relies":[6],"on":[7,83,154],"the":[8,15,39,66,102],"request":[9],"location:":[10],"when":[11],"not":[12],"issued":[13],"by":[14],"primary":[16,30,103],"region,":[17,104],"transactions":[18],"are":[19],"forced":[20],"to":[21,45,51,61,176],"involve":[22],"costly":[23],"wide-area":[24,123],"communication.":[25],"While":[26],"existing":[27],"systems":[28],"distribute":[29],"roles":[31],"across":[32],"regions,":[33],"such":[34,63],"assignment":[35],"typically":[36],"occurs":[37],"at":[38],"shard":[40],"level,":[41],"making":[42],"it":[43,144],"difficult":[44],"align":[46],"with":[47,138],"geographically":[48],"dispersed":[49],"access":[50],"individual":[52],"records.":[53],"This":[54],"paper":[55],"introduces":[56],"PolyBase,":[57],"a":[58,157],"pioneering":[59],"architecture":[60],"address":[62],"misalignment,":[64],"leveraging":[65],"widely":[67],"adopted":[68],"Paxos-based":[69],"log":[70,96,129],"replication":[71,97,130],"mechanisms.":[72],"It":[73],"enables":[74],"flexible":[75],"row-level":[76],"consensus":[77],"group":[78],"affiliation":[79],",":[80,88],"which":[81],"runs":[82],"an":[84],"unchanged":[85],"Paxos":[86,95],"protocol":[87],"but":[89],"dynamically":[90],"re-assigns":[91],"database":[92],"rows":[93],"between":[94],"groups,":[98],"whose":[99],"leaders":[100],"become":[101],"enjoying":[105],"faster":[106],"writes":[107],"and":[108,118,142,150,161,171],"up-to-date":[109],"versions":[110],"for":[111],"reads.":[112],"With":[113],"carefully":[114],"designed":[115],"data":[116],"structures":[117],"protocols,":[119],"PolyBase":[120,137,165],"significantly":[121,167],"reduces":[122],"RTTs":[124],"without":[125],"compromising":[126],"transaction":[127,169],"or":[128,132],"consistency":[131],"reliability":[133],"guarantees.":[134],"We":[135],"implemented":[136],"optimized":[139],"re-assignment":[140],"policies":[141],"integrated":[143],"into":[145],"two":[146],"popular":[147],"(RocksDB":[149],"MySQL).":[151],"Our":[152],"evaluation":[153],"AWS,":[155],"using":[156],"production":[158],"e-commerce":[159],"workload":[160],"microbench-marks":[162],"confirms":[163],"that":[164],"offers":[166],"higher":[168],"throughput":[170],"lower":[172],"average/tail":[173],"latency":[174],"compared":[175],"baselines.":[177]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}