{"id":"https://openalex.org/W2970432078","doi":"https://doi.org/10.14778/3352063.3352133","title":"Choosing a cloud DBMS","display_name":"Choosing a cloud DBMS","publication_year":2019,"publication_date":"2019-08-01","ids":{"openalex":"https://openalex.org/W2970432078","doi":"https://doi.org/10.14778/3352063.3352133","mag":"2970432078"},"language":"en","primary_location":{"id":"doi:10.14778/3352063.3352133","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3352063.3352133","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":true,"oa_status":"green","oa_url":"https://hdl.handle.net/1721.1/132276","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5085531657","display_name":"Junjay Tan","orcid":null},"institutions":[{"id":"https://openalex.org/I175594653","display_name":"John Brown University","ror":"https://ror.org/02ct41q97","country_code":"US","type":"education","lineage":["https://openalex.org/I175594653"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Junjay Tan","raw_affiliation_strings":["Brown University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Brown University","institution_ids":["https://openalex.org/I175594653"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073977219","display_name":"Thanaa M. Ghanem","orcid":"https://orcid.org/0009-0002-3673-1756"},"institutions":[{"id":"https://openalex.org/I99069390","display_name":"Metropolitan State University","ror":"https://ror.org/056rp9e47","country_code":"US","type":"education","lineage":["https://openalex.org/I91221267","https://openalex.org/I99069390"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Thanaa Ghanem","raw_affiliation_strings":["Metropolitan State University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Metropolitan State University","institution_ids":["https://openalex.org/I99069390"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002099464","display_name":"Matthew Perron","orcid":"https://orcid.org/0000-0002-2879-977X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Matthew Perron","raw_affiliation_strings":["MIT CSAIL"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100734491","display_name":"Xiangyao Yu","orcid":"https://orcid.org/0009-0001-0785-2519"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xiangyao Yu","raw_affiliation_strings":["MIT CSAIL"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074724644","display_name":"Michael Stonebraker","orcid":"https://orcid.org/0000-0001-9184-9058"},"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":"Michael Stonebraker","raw_affiliation_strings":["MIT CSAIL and Tamr, Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT CSAIL and Tamr, Inc","institution_ids":["https://openalex.org/I4210109586"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055300310","display_name":"David J. DeWitt","orcid":"https://orcid.org/0009-0007-5037-5205"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"David DeWitt","raw_affiliation_strings":["MIT CSAIL"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068345732","display_name":"Marco Serafini","orcid":"https://orcid.org/0000-0003-3125-1841"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Marco Serafini","raw_affiliation_strings":["University of Massachusetts"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Massachusetts","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000416532","display_name":"Ashraf Aboulnaga","orcid":"https://orcid.org/0000-0001-6693-7099"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ashraf Aboulnaga","raw_affiliation_strings":["HBKU"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"HBKU","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034086130","display_name":"Tim Kraska","orcid":"https://orcid.org/0009-0003-2414-2759"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Tim Kraska","raw_affiliation_strings":["MIT CSAIL"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":9,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":5.9954,"has_fulltext":false,"cited_by_count":37,"citation_normalized_percentile":{"value":0.96435967,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"12","issue":"12","first_page":"2170","last_page":"2182"},"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.9998999834060669,"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.9998999834060669,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9994000196456909,"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/T11478","display_name":"Caching and Content Delivery","score":0.998199999332428,"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.8596588373184204},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.728575587272644},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.7087423801422119},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.6645028591156006},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.565091073513031},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.4903907775878906},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.43504905700683594},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.3675961494445801},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3104814291000366},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.2740858197212219},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.17911845445632935},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.1708635687828064}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8596588373184204},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.728575587272644},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.7087423801422119},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6645028591156006},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.565091073513031},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.4903907775878906},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.43504905700683594},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.3675961494445801},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3104814291000366},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.2740858197212219},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.17911845445632935},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.1708635687828064},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.14778/3352063.3352133","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3352063.3352133","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"},{"id":"pmh:oai:dspace.mit.edu:1721.1/132276","is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/132276","pdf_url":null,"source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"VLDB Endowment","raw_type":"http://purl.org/eprint/type/ConferencePaper"},{"id":"pmh:oai:dspace.mit.edu:1721.1/132276.2","is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/132276.2","pdf_url":null,"source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"VLDB Endowment","raw_type":"Article"}],"best_oa_location":{"id":"pmh:oai:dspace.mit.edu:1721.1/132276","is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/132276","pdf_url":null,"source":{"id":"https://openalex.org/S4306400425","display_name":"DSpace@MIT (Massachusetts Institute of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I63966007","host_organization_name":"Massachusetts Institute of Technology","host_organization_lineage":["https://openalex.org/I63966007"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"VLDB Endowment","raw_type":"http://purl.org/eprint/type/ConferencePaper"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W1964078557","https://openalex.org/W1967091776","https://openalex.org/W1985229168","https://openalex.org/W1987659801","https://openalex.org/W2006296837","https://openalex.org/W2028383826","https://openalex.org/W2052739751","https://openalex.org/W2070511907","https://openalex.org/W2091765165","https://openalex.org/W2106771621","https://openalex.org/W2110086534","https://openalex.org/W2125364593","https://openalex.org/W2132497824","https://openalex.org/W2281494333","https://openalex.org/W2295252432","https://openalex.org/W2430301697","https://openalex.org/W2612759782","https://openalex.org/W2766579252","https://openalex.org/W2799170327","https://openalex.org/W2949762319","https://openalex.org/W3098223641"],"related_works":["https://openalex.org/W1988774479","https://openalex.org/W2123931473","https://openalex.org/W1799555191","https://openalex.org/W3012397820","https://openalex.org/W2382658894","https://openalex.org/W2791024100","https://openalex.org/W4312096174","https://openalex.org/W195952546","https://openalex.org/W1551562200","https://openalex.org/W1503756376"],"abstract_inverted_index":{"As":[0],"analytic":[1],"(OLAP)":[2],"applications":[3],"move":[4],"to":[5,21,110,149,169],"the":[6,27,35,47,64],"cloud,":[7],"DBMSs":[8],"have":[9,51],"shifted":[10],"from":[11],"employing":[12],"a":[13,22,68,75,93],"pure":[14],"shared-nothing":[15,38],"design":[16,24,119],"with":[17,34],"locally":[18],"attached":[19],"storage":[20,171],"hybrid":[23],"that":[25,121,145,158],"combines":[26],"use":[28,36],"of":[29,37,70],"shared-storage":[30],"(e.g.,":[31],"AWS":[32],"S3)":[33],"query":[39,88,163],"execution":[40],"mechanisms.":[41],"This":[42],"paper":[43],"sheds":[44],"light":[45],"on":[46,79],"resulting":[48],"tradeoffs,":[49],"which":[50],"not":[52],"been":[53],"properly":[54],"identified":[55],"in":[56,74,106],"previous":[57],"work.":[58],"To":[59],"this":[60],"end,":[61],"it":[62],"evaluates":[63],"TPC-H":[65],"benchmark":[66],"across":[67],"variety":[69],"DBMS":[71],"offerings":[72,85],"running":[73],"cloud":[76,95,111],"environment":[77],"(AWS)":[78],"fast":[80],"10Gb+":[81],"networks,":[82],"specifically":[83],"database-as-a-service":[84],"(Redshift,":[86],"Athena),":[87],"engines":[89],"(Presto,":[90],"Hive),":[91],"and":[92,118,155,165],"traditional":[94],"agnostic":[96,137],"OLAP":[97],"database":[98],"(Vertica).":[99],"While":[100],"these":[101],"comparisons":[102],"cannot":[103],"be":[104],"apples-to-apples":[105],"all":[107],"cases":[108],"due":[109],"configuration":[112],"restrictions,":[113],"we":[114],"nonetheless":[115],"identify":[116],"patterns":[117],"choices":[120],"are":[122],"advantageous.":[123],"These":[124],"include":[125],"prioritizing":[126],"low-cost":[127],"object":[128],"stores":[129],"like":[130,143,162],"S3":[131],"for":[132,152],"data":[133,168],"storage,":[134],"using":[135],"system":[136],"yet":[138],"still":[139],"performant":[140],"columnar":[141],"formats":[142],"ORC":[144],"allow":[146],"easy":[147],"switching":[148],"other":[150],"systems":[151],"different":[153],"workloads,":[154],"making":[156],"features":[157],"benefit":[159],"subsequent":[160],"runs":[161],"precompilation":[164],"caching":[166],"remote":[167],"faster":[170],"optional":[172],"rather":[173],"than":[174],"required":[175],"because":[176],"they":[177],"disadvantage":[178],"ad":[179],"hoc":[180],"queries.":[181]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":6},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":4}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}