{"id":"https://openalex.org/W4404181348","doi":"https://doi.org/10.14778/3685800.3685828","title":"Presto's History-Based Query Optimizer","display_name":"Presto's History-Based Query Optimizer","publication_year":2024,"publication_date":"2024-08-01","ids":{"openalex":"https://openalex.org/W4404181348","doi":"https://doi.org/10.14778/3685800.3685828"},"language":"en","primary_location":{"id":"doi:10.14778/3685800.3685828","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3685800.3685828","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/A5035603683","display_name":"Pranjal Shankhdhar","orcid":"https://orcid.org/0009-0003-7301-3961"},"institutions":[{"id":"https://openalex.org/I4210114444","display_name":"Meta (United States)","ror":"https://ror.org/01zbnvs85","country_code":"US","type":"company","lineage":["https://openalex.org/I4210114444"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Pranjal Shankhdhar","raw_affiliation_strings":["Meta Platforms, Menlo Park, CA, USA"],"affiliations":[{"raw_affiliation_string":"Meta Platforms, Menlo Park, CA, USA","institution_ids":["https://openalex.org/I4210114444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070153632","display_name":"Feilong Liu","orcid":"https://orcid.org/0000-0002-8638-2294"},"institutions":[{"id":"https://openalex.org/I4210114444","display_name":"Meta (United States)","ror":"https://ror.org/01zbnvs85","country_code":"US","type":"company","lineage":["https://openalex.org/I4210114444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Feilong Liu","raw_affiliation_strings":["Meta Platforms, Menlo Park, CA, USA"],"affiliations":[{"raw_affiliation_string":"Meta Platforms, Menlo Park, CA, USA","institution_ids":["https://openalex.org/I4210114444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114567591","display_name":"Jay Narale","orcid":null},"institutions":[{"id":"https://openalex.org/I2946016260","display_name":"Uber AI (United States)","ror":"https://ror.org/05vm0ed18","country_code":"US","type":"company","lineage":["https://openalex.org/I2946016260"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jay Narale","raw_affiliation_strings":["Uber Technologies, San Francisco, CA, USA"],"affiliations":[{"raw_affiliation_string":"Uber Technologies, San Francisco, CA, USA","institution_ids":["https://openalex.org/I2946016260"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055208397","display_name":"James Sun","orcid":null},"institutions":[{"id":"https://openalex.org/I4210114444","display_name":"Meta (United States)","ror":"https://ror.org/01zbnvs85","country_code":"US","type":"company","lineage":["https://openalex.org/I4210114444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"James Sun","raw_affiliation_strings":["Meta Platforms, Menlo Park, CA, USA"],"affiliations":[{"raw_affiliation_string":"Meta Platforms, Menlo Park, CA, USA","institution_ids":["https://openalex.org/I4210114444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5092212573","display_name":"Rebecca Schlussel","orcid":"https://orcid.org/0009-0005-3322-2472"},"institutions":[{"id":"https://openalex.org/I4210114444","display_name":"Meta (United States)","ror":"https://ror.org/01zbnvs85","country_code":"US","type":"company","lineage":["https://openalex.org/I4210114444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rebecca Schlussel","raw_affiliation_strings":["Meta Platforms, Menlo Park, CA, USA"],"affiliations":[{"raw_affiliation_string":"Meta Platforms, Menlo Park, CA, USA","institution_ids":["https://openalex.org/I4210114444"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5011460500","display_name":"Lyublena Antova","orcid":null},"institutions":[{"id":"https://openalex.org/I4210114444","display_name":"Meta (United States)","ror":"https://ror.org/01zbnvs85","country_code":"US","type":"company","lineage":["https://openalex.org/I4210114444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lyublena Antova","raw_affiliation_strings":["Meta Platforms, Menlo Park, CA, USA"],"affiliations":[{"raw_affiliation_string":"Meta Platforms, Menlo Park, CA, USA","institution_ids":["https://openalex.org/I4210114444"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5035603683"],"corresponding_institution_ids":["https://openalex.org/I4210114444"],"apc_list":null,"apc_paid":null,"fwci":0.3653,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.63651071,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":"17","issue":"12","first_page":"4077","last_page":"4089"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9990000128746033,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9990000128746033,"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/T11106","display_name":"Data Management and Algorithms","score":0.9952999949455261,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9884999990463257,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6009137630462646},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5629690289497375},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.32092294096946716}],"concepts":[{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6009137630462646},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5629690289497375},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32092294096946716}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3685800.3685828","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3685800.3685828","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":[{"id":"https://metadata.un.org/sdg/9","score":0.6299999952316284,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W135863099","https://openalex.org/W1569148339","https://openalex.org/W1968745093","https://openalex.org/W2003789154","https://openalex.org/W2051756193","https://openalex.org/W2075712468","https://openalex.org/W2110086534","https://openalex.org/W2116436709","https://openalex.org/W2120108467","https://openalex.org/W2131413649","https://openalex.org/W2151310484","https://openalex.org/W2160963784","https://openalex.org/W2163438246","https://openalex.org/W2396309311","https://openalex.org/W2949762319","https://openalex.org/W3111141572","https://openalex.org/W4206830372","https://openalex.org/W4236656499","https://openalex.org/W4281754544","https://openalex.org/W4282568501","https://openalex.org/W4282570649","https://openalex.org/W4313138291","https://openalex.org/W4380433194","https://openalex.org/W4381329367","https://openalex.org/W4386768940","https://openalex.org/W6651775274"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"An":[0],"important":[1],"feature":[2],"of":[3,33,129,154,164],"modern":[4],"query":[5,13,35,45,75,107],"optimizers":[6],"is":[7,16,39,71],"the":[8,19,25,44,48,68,98,125,130,149,162],"ability":[9,26],"to":[10,27,93,117],"produce":[11],"a":[12,110,155],"plan":[14,36],"that":[15],"optimal":[17],"for":[18,73,105],"underlying":[20,49,120],"data":[21,50,121,172],"set.":[22],"This":[23,77],"requires":[24],"estimate":[28],"cardinalities":[29],"and":[30,47,60,63,90,114,127,133,176],"computational":[31,64],"costs":[32],"intermediate":[34],"nodes,":[37],"which":[38,70,86],"highly":[40],"dependent":[41],"on":[42,57,136,147,152],"both":[43],"shape":[46],"distribution.":[51],"Traditional":[52],"methods":[53],"include":[54],"collecting":[55],"statistics":[56,150],"base":[58],"tables":[59],"implementing":[61,148],"cardinality":[62],"cost":[65],"derivation":[66],"inside":[67],"optimizer,":[69],"error-prone":[72],"complex":[74,106],"shapes.":[76],"paper":[78],"presents":[79],"Presto's":[80],"novel":[81],"history-based":[82],"optimization":[83,141],"framework":[84,101,132],"(HBO),":[85],"collects":[87],"execution":[88],"histories":[89],"uses":[91],"them":[92],"optimize":[94],"similar":[95],"queries":[96],"in":[97,109,119,139,167,169],"future.":[99],"The":[100],"produces":[102],"accurate":[103],"estimates":[104],"shapes":[108],"lightweight,":[111],"automated":[112],"manner,":[113],"adapts":[115],"automatically":[116],"changes":[118],"distributions.":[122],"We":[123,159],"present":[124,161],"design":[126],"implementation":[128],"HBO":[131,166],"provide":[134],"details":[135,146],"its":[137],"use":[138],"various":[140],"rules,":[142],"as":[143,145],"well":[144],"store":[151],"top":[153],"Redis":[156],"key-value":[157],"store.":[158],"also":[160],"results":[163],"running":[165],"production":[168],"two":[170],"large":[171],"infrastructure":[173],"organizations":[174],"(Meta":[175],"Uber).":[177]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2025-12-21T01:58:51.020947","created_date":"2025-10-10T00:00:00"}