{"id":"https://openalex.org/W4380433215","doi":"https://doi.org/10.1145/3588963","title":"Kepler: Robust Learning for Parametric Query Optimization","display_name":"Kepler: Robust Learning for Parametric Query Optimization","publication_year":2023,"publication_date":"2023-05-26","ids":{"openalex":"https://openalex.org/W4380433215","doi":"https://doi.org/10.1145/3588963"},"language":"en","primary_location":{"id":"doi:10.1145/3588963","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3588963","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},"type":"article","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1145/3588963","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5038072081","display_name":"Lyric Doshi","orcid":"https://orcid.org/0009-0002-1234-0283"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Lyric Doshi","raw_affiliation_strings":["Google, Mountain View, CA, USA"],"raw_orcid":"https://orcid.org/0009-0002-1234-0283","affiliations":[{"raw_affiliation_string":"Google, Mountain View, CA, USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068788467","display_name":"Vincent Zhuang","orcid":"https://orcid.org/0009-0007-2931-3069"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vincent Zhuang","raw_affiliation_strings":["Google, Mountain View, CA, USA"],"raw_orcid":"https://orcid.org/0009-0007-2931-3069","affiliations":[{"raw_affiliation_string":"Google, Mountain View, CA, USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5092150594","display_name":"Gaurav Jain","orcid":"https://orcid.org/0009-0006-9980-7737"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Gaurav Jain","raw_affiliation_strings":["Google, Mountain View, CA, USA"],"raw_orcid":"https://orcid.org/0009-0006-9980-7737","affiliations":[{"raw_affiliation_string":"Google, Mountain View, CA, USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025731013","display_name":"Ryan Marcus","orcid":"https://orcid.org/0000-0002-1279-1124"},"institutions":[{"id":"https://openalex.org/I79576946","display_name":"University of Pennsylvania","ror":"https://ror.org/00b30xv10","country_code":"US","type":"education","lineage":["https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ryan Marcus","raw_affiliation_strings":["University of Pennsylvania, Philadelphia, PA, USA"],"raw_orcid":"https://orcid.org/0000-0002-1279-1124","affiliations":[{"raw_affiliation_string":"University of Pennsylvania, Philadelphia, PA, USA","institution_ids":["https://openalex.org/I79576946"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101965145","display_name":"Haoyu Huang","orcid":"https://orcid.org/0000-0002-0940-228X"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Haoyu Huang","raw_affiliation_strings":["Google, Mountain View, CA, USA"],"raw_orcid":"https://orcid.org/0000-0002-0940-228X","affiliations":[{"raw_affiliation_string":"Google, Mountain View, CA, USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5090799315","display_name":"Deniz Alt\u0131nb\u00fcken","orcid":"https://orcid.org/0000-0002-4558-2847"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Deniz Altinb\u00fcken","raw_affiliation_strings":["Google, Mountain View, CA, USA"],"raw_orcid":"https://orcid.org/0000-0002-4558-2847","affiliations":[{"raw_affiliation_string":"Google, Mountain View, CA, USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047736127","display_name":"Eugene Brevdo","orcid":"https://orcid.org/0009-0005-7965-3534"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Eugene Brevdo","raw_affiliation_strings":["Google, Mountain View, CA, USA"],"raw_orcid":"https://orcid.org/0009-0005-7965-3534","affiliations":[{"raw_affiliation_string":"Google, Mountain View, CA, USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023294162","display_name":"Campbell Fraser","orcid":"https://orcid.org/0009-0005-2035-4409"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Campbell Fraser","raw_affiliation_strings":["Google, Mountain View, CA, USA"],"raw_orcid":"https://orcid.org/0009-0005-2035-4409","affiliations":[{"raw_affiliation_string":"Google, Mountain View, CA, USA","institution_ids":["https://openalex.org/I1291425158"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5038072081"],"corresponding_institution_ids":["https://openalex.org/I1291425158"],"apc_list":null,"apc_paid":null,"fwci":5.2907,"has_fulltext":true,"cited_by_count":27,"citation_normalized_percentile":{"value":0.95989875,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"1","issue":"1","first_page":"1","last_page":"25"},"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.9986000061035156,"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.9986000061035156,"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/T12072","display_name":"Machine Learning and Algorithms","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T11269","display_name":"Algorithms and Data Compression","score":0.9970999956130981,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/kepler","display_name":"Kepler","score":0.7768293619155884},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6729786396026611},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5256277918815613},{"id":"https://openalex.org/keywords/parametric-statistics","display_name":"Parametric statistics","score":0.4465197026729584},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3473626375198364},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2650540769100189},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.157011479139328},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.09807413816452026},{"id":"https://openalex.org/keywords/stars","display_name":"Stars","score":0.07475945353507996}],"concepts":[{"id":"https://openalex.org/C207963374","wikidata":"https://www.wikidata.org/wiki/Q47592","display_name":"Kepler","level":3,"score":0.7768293619155884},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6729786396026611},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5256277918815613},{"id":"https://openalex.org/C117251300","wikidata":"https://www.wikidata.org/wiki/Q1849855","display_name":"Parametric statistics","level":2,"score":0.4465197026729584},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3473626375198364},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2650540769100189},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.157011479139328},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.09807413816452026},{"id":"https://openalex.org/C150846664","wikidata":"https://www.wikidata.org/wiki/Q7602306","display_name":"Stars","level":2,"score":0.07475945353507996},{"id":"https://openalex.org/C31972630","wikidata":"https://www.wikidata.org/wiki/Q844240","display_name":"Computer vision","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3588963","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3588963","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},{"id":"pmh:oai:arXiv.org:2306.06798","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2306.06798","pdf_url":"https://arxiv.org/pdf/2306.06798","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"pmh:oai:dspace.mit.edu:1721.1/150848","is_oa":true,"landing_page_url":"https://hdl.handle.net/1721.1/150848","pdf_url":"https://dspace.mit.edu/bitstream/1721.1/150848/1/3588963.pdf","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","license_id":"https://openalex.org/licenses/cc-by-nc","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Association for Computing Machinery","raw_type":"http://purl.org/eprint/type/JournalArticle"}],"best_oa_location":{"id":"doi:10.1145/3588963","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3588963","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W1587011656","https://openalex.org/W1987645871","https://openalex.org/W1994341124","https://openalex.org/W2025550567","https://openalex.org/W2081728040","https://openalex.org/W2133064331","https://openalex.org/W2146241755","https://openalex.org/W2170741459","https://openalex.org/W2240667924","https://openalex.org/W2396309311","https://openalex.org/W2424452828","https://openalex.org/W2607970166","https://openalex.org/W2790625403","https://openalex.org/W2944240329","https://openalex.org/W2949044932","https://openalex.org/W3035898727","https://openalex.org/W3099158806","https://openalex.org/W3176153696","https://openalex.org/W3201461576","https://openalex.org/W4206830372","https://openalex.org/W4210689632","https://openalex.org/W4285338532","https://openalex.org/W4287755806"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2577502644","https://openalex.org/W2734892257","https://openalex.org/W4248372522","https://openalex.org/W2576891438","https://openalex.org/W2024447132","https://openalex.org/W2940411870","https://openalex.org/W1982924459","https://openalex.org/W2971308454"],"abstract_inverted_index":{"Most":[0],"existing":[1],"parametric":[2],"query":[3,10,22,38,43,119,130],"optimization":[4],"(PQO)":[5],"techniques":[6],"rely":[7],"on":[8,60,132,135],"traditional":[9,42],"optimizer":[11],"cost":[12,72],"models,":[13,73],"which":[14],"are":[15],"often":[16],"inaccurate":[17],"and":[18,86],"result":[19],"in":[20,37,62,104,108,118,129],"suboptimal":[21],"performance.":[23,120],"We":[24],"propose":[25],"Kepler,":[26],"an":[27],"end-to-end":[28],"learning-based":[29],"approach":[30],"to":[31,46,90,110],"PQO":[32],"that":[33,124],"demonstrates":[34],"significant":[35,127],"speedups":[36],"latency":[39],"over":[40],"a":[41,54],"optimizer.":[44],"Central":[45],"our":[47],"method":[48],"is":[49],"Row":[50],"Count":[51],"Evolution":[52],"(RCE),":[53],"novel":[55],"plan":[56,94],"generation":[57],"algorithm":[58],"based":[59],"perturbations":[61],"the":[63,92],"sub-plan":[64],"cardinality":[65],"space.":[66],"While":[67],"previous":[68],"approaches":[69],"require":[70],"accurate":[71],"we":[74,122],"bypass":[75],"this":[76],"requirement":[77],"by":[78],"evaluating":[79],"candidate":[80],"plans":[81,114],"via":[82],"actual":[83],"execution":[84],"data":[85],"training":[87],"anML":[88],"model":[89],"predict":[91,112],"fastest":[93],"given":[95],"parameter":[96],"binding":[97],"values.":[98],"Our":[99],"models":[100],"leverage":[101],"recent":[102],"advances":[103],"neural":[105],"network":[106],"uncertainty":[107],"order":[109],"robustly":[111],"faster":[113],"while":[115],"avoiding":[116],"regressions":[117],"Experimentally,":[121],"show":[123],"Kepler":[125],"achieves":[126],"improvements":[128],"runtime":[131],"multiple":[133],"datasets":[134],"PostgreSQL.":[136]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":12},{"year":2024,"cited_by_count":12},{"year":2023,"cited_by_count":1}],"updated_date":"2026-05-04T08:30:34.212998","created_date":"2023-06-14T00:00:00"}