{"id":"https://openalex.org/W2065502652","doi":"https://doi.org/10.1145/2723372.2764945","title":"DunceCap","display_name":"DunceCap","publication_year":2015,"publication_date":"2015-05-27","ids":{"openalex":"https://openalex.org/W2065502652","doi":"https://doi.org/10.1145/2723372.2764945","mag":"2065502652"},"language":"en","primary_location":{"id":"doi:10.1145/2723372.2764945","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2723372.2764945","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data","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/A5050864187","display_name":"\u0410 \u042f \u041f\u0435\u0440\u0435\u043b\u044c\u043c\u0430\u043d","orcid":null},"institutions":[{"id":"https://openalex.org/I97018004","display_name":"Stanford University","ror":"https://ror.org/00f54p054","country_code":"US","type":"education","lineage":["https://openalex.org/I97018004"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Adam Perelman","raw_affiliation_strings":["Stanford University, Stanford, CA, USA"],"affiliations":[{"raw_affiliation_string":"Stanford University, Stanford, CA, USA","institution_ids":["https://openalex.org/I97018004"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103852640","display_name":"Christopher R\u00e9","orcid":null},"institutions":[{"id":"https://openalex.org/I97018004","display_name":"Stanford University","ror":"https://ror.org/00f54p054","country_code":"US","type":"education","lineage":["https://openalex.org/I97018004"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Christopher R\u00e9","raw_affiliation_strings":["Stanford University, Stanford, CA, USA"],"affiliations":[{"raw_affiliation_string":"Stanford University, Stanford, CA, USA","institution_ids":["https://openalex.org/I97018004"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5050864187"],"corresponding_institution_ids":["https://openalex.org/I97018004"],"apc_list":null,"apc_paid":null,"fwci":1.4015,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.84129538,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"2075","last_page":"2076"},"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.9997000098228455,"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.9997000098228455,"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.9997000098228455,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.8225655555725098},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.680408239364624},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.5878257155418396},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5797366499900818},{"id":"https://openalex.org/keywords/pairwise-comparison","display_name":"Pairwise comparison","score":0.5631011128425598},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.543478786945343},{"id":"https://openalex.org/keywords/compiler","display_name":"Compiler","score":0.5089077949523926},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.4597572982311249},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.456469863653183},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.45331716537475586},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.439306378364563},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.4330779016017914},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.43257057666778564},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4193885326385498},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.34722059965133667},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2698410749435425},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.24248269200325012},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.18909034132957458},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.11790141463279724},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.11787533760070801},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.09039884805679321}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8225655555725098},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.680408239364624},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.5878257155418396},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5797366499900818},{"id":"https://openalex.org/C184898388","wikidata":"https://www.wikidata.org/wiki/Q1435712","display_name":"Pairwise comparison","level":2,"score":0.5631011128425598},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.543478786945343},{"id":"https://openalex.org/C169590947","wikidata":"https://www.wikidata.org/wiki/Q47506","display_name":"Compiler","level":2,"score":0.5089077949523926},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.4597572982311249},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.456469863653183},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.45331716537475586},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.439306378364563},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.4330779016017914},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.43257057666778564},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4193885326385498},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.34722059965133667},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2698410749435425},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.24248269200325012},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.18909034132957458},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.11790141463279724},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.11787533760070801},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.09039884805679321},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","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":1,"locations":[{"id":"doi:10.1145/2723372.2764945","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2723372.2764945","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1336912174","display_name":null,"funder_award_id":"ACI-1343760","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G1633478753","display_name":null,"funder_award_id":"CCF-1356918","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G1869467075","display_name":null,"funder_award_id":"N000141210041","funder_id":"https://openalex.org/F4320337345","funder_display_name":"Office of Naval Research"},{"id":"https://openalex.org/G3858477398","display_name":null,"funder_award_id":"IIS-1353606","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7707571486","display_name":null,"funder_award_id":"FA8750-12-2-0335","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320306202","display_name":"Gordon and Betty Moore Foundation","ror":"https://ror.org/006wxqw41"},{"id":"https://openalex.org/F4320332180","display_name":"Defense Advanced Research Projects Agency","ror":"https://ror.org/02caytj08"},{"id":"https://openalex.org/F4320337345","display_name":"Office of Naval Research","ror":"https://ror.org/00rk2pe57"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W52840101","https://openalex.org/W1601049810","https://openalex.org/W1884846888","https://openalex.org/W2755088640","https://openalex.org/W2790840297"],"related_works":["https://openalex.org/W3125756434","https://openalex.org/W2152149667","https://openalex.org/W2556786504","https://openalex.org/W4244527061","https://openalex.org/W2096359267","https://openalex.org/W2392799717","https://openalex.org/W1977383094","https://openalex.org/W2469357693","https://openalex.org/W1481270797","https://openalex.org/W2388768270"],"abstract_inverted_index":{"Modern":[0],"data":[1],"analytics":[2],"workloads":[3],"frequently":[4],"involve":[5],"complex":[6],"join":[7],"queries":[8],"where":[9],"the":[10,68,72],"pairwise-join-based":[11],"algorithms":[12,26,33,84,103,110],"used":[13],"by":[14,111],"most":[15],"RDBMS":[16,102],"engines":[17],"are":[18,28],"suboptimal.":[19],"In":[20],"this":[21],"study,":[22],"we":[23],"explore":[24],"two":[25,83],"that":[27,96],"asymptotically":[29],"faster":[30],"than":[31],"pairwise":[32],"for":[34,46,58],"a":[35,52,76,117],"large":[36],"class":[37],"of":[38,71,114,119],"queries.":[39,48,120],"The":[40,49],"first":[41],"is":[42,51,63],"Yannakakis'":[43],"classical":[44],"algorithm":[45,55],"acyclic":[47],"second":[50],"more":[53],"recent":[54],"which":[56,62,80],"works":[57],"any":[59],"query":[60,77,92],"and":[61,85,94],"optimal":[64,91,109],"with":[65],"respect":[66],"to":[67,89],"worst-case":[69,108],"size":[70],"output.":[73],"We":[74],"introduce":[75],"compiler,":[78],"DunceCap,":[79],"uses":[81],"these":[82,97],"variations":[86],"on":[87,116],"them":[88],"produce":[90],"plans,":[93],"find":[95],"plans":[98],"can":[99],"outperform":[100],"standard":[101],"as":[104,106],"well":[105],"simple":[107],"an":[112],"order":[113],"magnitude":[115],"variety":[118]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":1}],"updated_date":"2026-04-09T08:11:56.329763","created_date":"2016-06-24T00:00:00"}