{"id":"https://openalex.org/W2110488358","doi":"https://doi.org/10.1109/icde.2010.5447916","title":"Polynomial heuristics for query optimization","display_name":"Polynomial heuristics for query optimization","publication_year":2010,"publication_date":"2010-03-01","ids":{"openalex":"https://openalex.org/W2110488358","doi":"https://doi.org/10.1109/icde.2010.5447916","mag":"2110488358"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2010.5447916","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2010.5447916","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)","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/A5103027305","display_name":"Nicolas Bruno","orcid":"https://orcid.org/0009-0007-3951-0998"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Nicolas Bruno","raw_affiliation_strings":["Microsoft Corporation, USA","Microsoft Corp,USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft Corp,USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016107143","display_name":"C\u00e9sar Galindo-Legaria","orcid":"https://orcid.org/0009-0006-5344-9495"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Cesar Galindo-Legaria","raw_affiliation_strings":["Microsoft Corporation, USA","Microsoft Corp,USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft Corp,USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5022433632","display_name":"Milind Joshi","orcid":"https://orcid.org/0009-0001-0769-1700"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Milind Joshi","raw_affiliation_strings":["Microsoft Corporation, USA","Microsoft Corp,USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft Corp,USA","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5103027305"],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":1.8596,"has_fulltext":false,"cited_by_count":34,"citation_normalized_percentile":{"value":0.86818594,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"589","last_page":"600"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9962000250816345,"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/heuristics","display_name":"Heuristics","score":0.8652517795562744},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7707549333572388},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7333117723464966},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.594318151473999},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.5339077115058899},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.533438503742218},{"id":"https://openalex.org/keywords/generator","display_name":"Generator (circuit theory)","score":0.5286073088645935},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4576526880264282},{"id":"https://openalex.org/keywords/polynomial","display_name":"Polynomial","score":0.4506632089614868},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2506069540977478},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.15992683172225952},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.143447607755661}],"concepts":[{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.8652517795562744},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7707549333572388},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7333117723464966},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.594318151473999},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.5339077115058899},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.533438503742218},{"id":"https://openalex.org/C2780992000","wikidata":"https://www.wikidata.org/wiki/Q17016113","display_name":"Generator (circuit theory)","level":3,"score":0.5286073088645935},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4576526880264282},{"id":"https://openalex.org/C90119067","wikidata":"https://www.wikidata.org/wiki/Q43260","display_name":"Polynomial","level":2,"score":0.4506632089614868},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2506069540977478},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.15992683172225952},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.143447607755661},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"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/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/icde.2010.5447916","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2010.5447916","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.628.6249","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.628.6249","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://research.microsoft.com/pubs/132009/ICDE10_conf_full_106.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.909.8539","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.909.8539","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://www.researchgate.net/profile/Nicolas_Bruno/publication/220964713_Polynomial_heuristics_for_query_optimization/links/00b495277cba22b603000000.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"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/W166430344","https://openalex.org/W1538786304","https://openalex.org/W1556146035","https://openalex.org/W1761301028","https://openalex.org/W1777047301","https://openalex.org/W1804205637","https://openalex.org/W1968541019","https://openalex.org/W1981925480","https://openalex.org/W2026984353","https://openalex.org/W2035675039","https://openalex.org/W2066623874","https://openalex.org/W2079329679","https://openalex.org/W2079806729","https://openalex.org/W2136195851","https://openalex.org/W2145037882","https://openalex.org/W2153180521","https://openalex.org/W2153329411","https://openalex.org/W2154888102","https://openalex.org/W2164219265","https://openalex.org/W3003067944","https://openalex.org/W6605485969","https://openalex.org/W6606780865","https://openalex.org/W6632489444","https://openalex.org/W6637898976","https://openalex.org/W6638344750"],"related_works":["https://openalex.org/W2000785801","https://openalex.org/W986318368","https://openalex.org/W3177062893","https://openalex.org/W3125143773","https://openalex.org/W2007032764","https://openalex.org/W803550684","https://openalex.org/W2483226803","https://openalex.org/W4352977312","https://openalex.org/W2067280619","https://openalex.org/W2041180560"],"abstract_inverted_index":{"Research":[0],"on":[1,7,32],"query":[2,20],"optimization":[3,21],"has":[4],"traditionally":[5],"focused":[6],"exhaustive":[8],"enumeration":[9],"of":[10,14,39,71],"an":[11],"exponential":[12],"number":[13],"candidate":[15],"plans.":[16],"Alternatively,":[17],"heuristics":[18],"for":[19,62],"are":[22],"restricted":[23],"in":[24,42],"several":[25],"ways,":[26],"such":[27],"as":[28],"by":[29],"either":[30],"focusing":[31],"join":[33,77],"predicates":[34],"only,":[35],"ignoring":[36],"the":[37,69],"availability":[38],"indexes,":[40],"or":[41],"general":[43],"having":[44],"high-degree":[45],"polynomial":[46],"complexity.":[47],"In":[48],"this":[49],"paper":[50],"we":[51],"propose":[52],"a":[53,82],"heuristic":[54],"approach":[55,89],"to":[56],"very":[57],"efficiently":[58],"obtain":[59],"execution":[60],"plans":[61],"complex":[63],"queries,":[64],"which":[65],"takes":[66],"into":[67],"account":[68],"presence":[70],"indexes":[72],"and":[73,86,93],"goes":[74],"beyond":[75],"simple":[76],"reordering.":[78],"We":[79],"also":[80],"introduce":[81],"realistic":[83],"workload":[84],"generator":[85],"validate":[87],"our":[88],"using":[90],"both":[91],"synthetic":[92],"real":[94],"data.":[95]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":7},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":4},{"year":2012,"cited_by_count":2}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}