{"id":"https://openalex.org/W4402041923","doi":"https://doi.org/10.14778/3681954.3682031","title":"Why TPC is Not Enough: An Analysis of the Amazon Redshift Fleet","display_name":"Why TPC is Not Enough: An Analysis of the Amazon Redshift Fleet","publication_year":2024,"publication_date":"2024-07-01","ids":{"openalex":"https://openalex.org/W4402041923","doi":"https://doi.org/10.14778/3681954.3682031"},"language":"en","primary_location":{"id":"doi:10.14778/3681954.3682031","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3681954.3682031","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/A5075037947","display_name":"Alexander van Renen","orcid":"https://orcid.org/0000-0002-6365-4592"},"institutions":[{"id":"https://openalex.org/I4210089351","display_name":"Universidad Tecnol\u00f3gica Nicarag\u00fcense","ror":"https://ror.org/008rn4f38","country_code":"NI","type":"education","lineage":["https://openalex.org/I4210089351"]}],"countries":["NI"],"is_corresponding":true,"raw_author_name":"Alexander van Renen","raw_affiliation_strings":["UTN"],"affiliations":[{"raw_affiliation_string":"UTN","institution_ids":["https://openalex.org/I4210089351"]}]},{"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"],"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"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"],"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021956406","display_name":"Kapil Vaidya","orcid":"https://orcid.org/0009-0000-1435-5927"},"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":"Kapil Vaidya","raw_affiliation_strings":["Amazon Web Services"],"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108977166","display_name":"Wenjian Dong","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":"Wenjian Dong","raw_affiliation_strings":["Amazon Web Services"],"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5106840768","display_name":"Murali Narayanaswamy","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":"Murali Narayanaswamy","raw_affiliation_strings":["Amazon Web Services"],"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101649257","display_name":"Zhengchun Liu","orcid":"https://orcid.org/0000-0002-6647-4423"},"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"],"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017986252","display_name":"Gaurav Saxena","orcid":"https://orcid.org/0009-0003-6672-3949"},"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":"Gaurav Saxena","raw_affiliation_strings":["Amazon Web Services"],"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046188245","display_name":"Andreas Kipf","orcid":"https://orcid.org/0000-0003-3463-0564"},"institutions":[{"id":"https://openalex.org/I4210089351","display_name":"Universidad Tecnol\u00f3gica Nicarag\u00fcense","ror":"https://ror.org/008rn4f38","country_code":"NI","type":"education","lineage":["https://openalex.org/I4210089351"]}],"countries":["NI"],"is_corresponding":false,"raw_author_name":"Andreas Kipf","raw_affiliation_strings":["UTN"],"affiliations":[{"raw_affiliation_string":"UTN","institution_ids":["https://openalex.org/I4210089351"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034086130","display_name":"Tim Kraska","orcid":"https://orcid.org/0009-0003-2414-2759"},"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":"Tim Kraska","raw_affiliation_strings":["Amazon Web Services"],"affiliations":[{"raw_affiliation_string":"Amazon Web Services","institution_ids":["https://openalex.org/I1311688040"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":10,"corresponding_author_ids":["https://openalex.org/A5075037947"],"corresponding_institution_ids":["https://openalex.org/I4210089351"],"apc_list":null,"apc_paid":null,"fwci":20.2779,"has_fulltext":false,"cited_by_count":25,"citation_normalized_percentile":{"value":0.99348823,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":100},"biblio":{"volume":"17","issue":"11","first_page":"3694","last_page":"3706"},"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.9962000250816345,"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.9962000250816345,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9925000071525574,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9864000082015991,"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.7823981046676636},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.6868637800216675},{"id":"https://openalex.org/keywords/provisioning","display_name":"Provisioning","score":0.5819934606552124},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5286279916763306},{"id":"https://openalex.org/keywords/publication","display_name":"Publication","score":0.5221955180168152},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5184473395347595},{"id":"https://openalex.org/keywords/amazon-rainforest","display_name":"Amazon rainforest","score":0.4322487413883209},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.15737053751945496}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7823981046676636},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.6868637800216675},{"id":"https://openalex.org/C172191483","wikidata":"https://www.wikidata.org/wiki/Q1071806","display_name":"Provisioning","level":2,"score":0.5819934606552124},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5286279916763306},{"id":"https://openalex.org/C41458344","wikidata":"https://www.wikidata.org/wiki/Q732577","display_name":"Publication","level":2,"score":0.5221955180168152},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5184473395347595},{"id":"https://openalex.org/C535291247","wikidata":"https://www.wikidata.org/wiki/Q177567","display_name":"Amazon rainforest","level":2,"score":0.4322487413883209},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.15737053751945496},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C112698675","wikidata":"https://www.wikidata.org/wiki/Q37038","display_name":"Advertising","level":1,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3681954.3682031","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3681954.3682031","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":[{"display_name":"Industry, innovation and infrastructure","score":0.6000000238418579,"id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W2028383826","https://openalex.org/W2038249652","https://openalex.org/W2060470544","https://openalex.org/W2435648513","https://openalex.org/W2970432078","https://openalex.org/W3084651990","https://openalex.org/W4214495955","https://openalex.org/W4281718197","https://openalex.org/W4317639412","https://openalex.org/W4398233610","https://openalex.org/W4398234120"],"related_works":["https://openalex.org/W3022229171","https://openalex.org/W2913190967","https://openalex.org/W587719479","https://openalex.org/W3165307885","https://openalex.org/W3097390808","https://openalex.org/W2611724343","https://openalex.org/W4391681741","https://openalex.org/W2785227142","https://openalex.org/W572531444","https://openalex.org/W2945962340"],"abstract_inverted_index":{"Database":[0],"research":[1],"and":[2,14,48,54,95,100,128,150],"development":[3],"is":[4],"heavily":[5],"influenced":[6],"by":[7],"benchmarks,":[8,118],"such":[9],"as":[10,158],"the":[11,72],"industry-standard":[12],"TPC-H":[13],"TPC-DS":[15],"for":[16,161],"analytical":[17],"systems.":[18],"However,":[19],"these":[20,38],"twenty-year-old":[21],"benchmarks":[22],"neither":[23],"capture":[24],"how":[25,82,101],"databases":[26],"are":[27,86,98],"deployed":[28],"nor":[29],"what":[30],"workloads":[31,56,88,107],"modern":[32],"cloud":[33,74],"data":[34,75,84,116],"warehouse":[35,76,117],"systems":[36],"face":[37],"days.":[39],"In":[40],"this":[41],"paper,":[42],"we":[43,80,137],"summarize":[44],"well-known,":[45],"confirm":[46],"suspected,":[47],"unearth":[49],"novel":[50],"discrepancies":[51],"between":[52],"TPC-H/DS":[53],"actual":[55],"using":[57],"empirical":[58],"data.":[59],"We":[60,113],"base":[61],"our":[62],"analysis":[63],"on":[64,132],"telemetrics":[65],"from":[66],"Amazon":[67],"Redshift":[68,148],"-":[69],"one":[70],"of":[71,104,144],"largest":[73],"deployments.":[77],"Among":[78],"others,":[79],"show":[81],"write-heavy":[83],"pipelines":[85],"prominent,":[87],"vary":[89],"over":[90,154],"time":[91],"(in":[92],"both":[93],"load":[94],"type),":[96],"queries":[97,105],"repetitive,":[99],"most":[102],"properties":[103],"or":[106],"experience":[108],"very":[109],"long":[110],"tailed":[111],"distributions.":[112],"conclude":[114],"that":[115],"just":[119],"like":[120],"database":[121],"systems,":[122],"need":[123],"to":[124],"become":[125],"more":[126,163],"holistic":[127],"stop":[129],"focusing":[130],"solely":[131],"query":[133,142],"engine":[134],"performance.":[135],"Finally,":[136],"publish":[138],"a":[139,155,159],"dataset":[140],"containing":[141],"statistics":[143],"200":[145],"randomly":[146],"selected":[147],"serverless":[149],"provisioned":[151],"instances":[152],"(each)":[153],"three-month":[156],"period,":[157],"basis":[160],"building":[162],"realistic":[164],"benchmarks.":[165]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":21},{"year":2024,"cited_by_count":2}],"updated_date":"2026-03-09T08:58:05.943551","created_date":"2025-10-10T00:00:00"}