{"id":"https://openalex.org/W2922302645","doi":"https://doi.org/10.1109/icde.2019.00191","title":"How I Learned to Stop Worrying and Love Re-optimization","display_name":"How I Learned to Stop Worrying and Love Re-optimization","publication_year":2019,"publication_date":"2019-04-01","ids":{"openalex":"https://openalex.org/W2922302645","doi":"https://doi.org/10.1109/icde.2019.00191","mag":"2922302645"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2019.00191","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2019.00191","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2019 IEEE 35th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-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/A5002099464","display_name":"Matthew Perron","orcid":"https://orcid.org/0000-0002-2879-977X"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Matthew Perron","raw_affiliation_strings":["MIT CSAIL"],"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007330751","display_name":"Zeyuan Shang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zeyuan Shang","raw_affiliation_strings":["MIT CSAIL"],"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]},{"author_position":"middle","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"],"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5074724644","display_name":"Michael Stonebraker","orcid":"https://orcid.org/0000-0001-9184-9058"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Michael Stonebraker","raw_affiliation_strings":["MIT CSAIL"],"affiliations":[{"raw_affiliation_string":"MIT CSAIL","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5002099464"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.2991,"has_fulltext":false,"cited_by_count":23,"citation_normalized_percentile":{"value":0.89126513,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1758","last_page":"1761"},"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.9998999834060669,"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.9998999834060669,"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.9998999834060669,"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/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9939000010490417,"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.8121609687805176},{"id":"https://openalex.org/keywords/latency","display_name":"Latency (audio)","score":0.7371683120727539},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.6912574172019958},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.6006736159324646},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5933810472488403},{"id":"https://openalex.org/keywords/optimization-problem","display_name":"Optimization problem","score":0.4734877049922943},{"id":"https://openalex.org/keywords/scheme","display_name":"Scheme (mathematics)","score":0.439770370721817},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.3847958743572235},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2756831645965576},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.21660715341567993},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.08961069583892822}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8121609687805176},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.7371683120727539},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.6912574172019958},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.6006736159324646},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5933810472488403},{"id":"https://openalex.org/C137836250","wikidata":"https://www.wikidata.org/wiki/Q984063","display_name":"Optimization problem","level":2,"score":0.4734877049922943},{"id":"https://openalex.org/C77618280","wikidata":"https://www.wikidata.org/wiki/Q1155772","display_name":"Scheme (mathematics)","level":2,"score":0.439770370721817},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.3847958743572235},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2756831645965576},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.21660715341567993},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08961069583892822},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2019.00191","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2019.00191","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2019 IEEE 35th International Conference on Data Engineering (ICDE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W2102166438","https://openalex.org/W2132823934","https://openalex.org/W2143452574","https://openalex.org/W2153329411","https://openalex.org/W2396309311"],"related_works":["https://openalex.org/W2378211422","https://openalex.org/W2745001401","https://openalex.org/W4321353415","https://openalex.org/W2002177687","https://openalex.org/W2130974462","https://openalex.org/W972276598","https://openalex.org/W4246352526","https://openalex.org/W2028665553","https://openalex.org/W4230315250","https://openalex.org/W2086519370"],"abstract_inverted_index":{"Cost-based":[0],"query":[1,86],"optimizers":[2,19],"remain":[3],"one":[4],"of":[5,10,33,38,58,100,113,129,132],"the":[6,27,54,79,98,110,114,121,130],"most":[7,80,128],"important":[8],"components":[9],"database":[11],"management":[12],"systems":[13],"for":[14],"analytic":[15],"workloads.":[16],"Though":[17],"modern":[18],"select":[20],"plans":[21],"close":[22],"to":[23,60,83],"optimal":[24],"performance":[25],"in":[26,120],"common":[28],"case,":[29,55],"a":[30,74,92],"small":[31],"number":[32],"queries":[34,119],"are":[35],"an":[36],"order":[37],"magnitude":[39],"slower":[40],"than":[41],"they":[42],"could":[43],"be.":[44],"In":[45],"this":[46,51],"paper":[47],"we":[48,71],"investigate":[49],"why":[50,70],"is":[52,77],"still":[53],"despite":[56],"decades":[57],"improvements":[59],"cost":[61],"models,":[62],"plan":[63],"enumeration,":[64],"and":[65],"cardinality":[66,134],"estimation.":[67,135],"We":[68,88,105],"demonstrate":[69,106],"believe":[72],"that":[73,90,107],"re-optimization":[75,94,108],"mechanism":[76],"likely":[78],"cost-effective":[81],"way":[82],"improve":[84,97],"end-to-end":[85,111],"performance.":[87],"find":[89],"even":[91],"simple":[93],"scheme":[95],"can":[96],"latency":[99,112],"many":[101],"poorly":[102],"performing":[103],"queries.":[104],"improves":[109],"top":[115],"20":[116],"longest":[117],"running":[118],"Join":[122],"Order":[123],"Benchmark":[124],"by":[125],"27%,":[126],"realizing":[127],"benefit":[131],"perfect":[133]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}