{"id":"https://openalex.org/W2169998163","doi":"https://doi.org/10.1137/110859440","title":"Size Bounds and Query Plans for Relational Joins","display_name":"Size Bounds and Query Plans for Relational Joins","publication_year":2013,"publication_date":"2013-01-01","ids":{"openalex":"https://openalex.org/W2169998163","doi":"https://doi.org/10.1137/110859440","mag":"2169998163"},"language":"en","primary_location":{"id":"doi:10.1137/110859440","is_oa":false,"landing_page_url":"https://doi.org/10.1137/110859440","pdf_url":null,"source":{"id":"https://openalex.org/S153560523","display_name":"SIAM Journal on Computing","issn_l":"0097-5397","issn":["0097-5397","1095-7111"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320508","host_organization_name":"Society for Industrial and Applied Mathematics","host_organization_lineage":["https://openalex.org/P4310320508"],"host_organization_lineage_names":["Society for Industrial and Applied Mathematics"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SIAM Journal on Computing","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/A5003671114","display_name":"Albert Atserias","orcid":"https://orcid.org/0000-0002-3732-1989"},"institutions":[{"id":"https://openalex.org/I39343248","display_name":"Humboldt-Universit\u00e4t zu Berlin","ror":"https://ror.org/01hcx6992","country_code":"DE","type":"education","lineage":["https://openalex.org/I39343248"]},{"id":"https://openalex.org/I4210117195","display_name":"HUN-REN Institute for Computer Science and Control","ror":"https://ror.org/0249v7n71","country_code":"HU","type":"facility","lineage":["https://openalex.org/I4210117195","https://openalex.org/I4387152226"]},{"id":"https://openalex.org/I7597260","display_name":"Hungarian Academy of Sciences","ror":"https://ror.org/02ks8qq67","country_code":"HU","type":"government","lineage":["https://openalex.org/I7597260"]},{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["DE","ES","HU"],"is_corresponding":false,"raw_author_name":"Albert Atserias","raw_affiliation_strings":["Universitat Polit\u00e8cnica de Catalunya Barcelona, Spain","Humboldt Universit\u00e4t zu Berlin Berlin, Germany","Computer and Automation Research Institute, Hungarian Academy of Sciences (MTA SZTAKI), Budapest, Hungary"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitat Polit\u00e8cnica de Catalunya Barcelona, Spain","institution_ids":["https://openalex.org/I9617848"]},{"raw_affiliation_string":"Humboldt Universit\u00e4t zu Berlin Berlin, Germany","institution_ids":["https://openalex.org/I39343248"]},{"raw_affiliation_string":"Computer and Automation Research Institute, Hungarian Academy of Sciences (MTA SZTAKI), Budapest, Hungary","institution_ids":["https://openalex.org/I4210117195","https://openalex.org/I7597260"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073893026","display_name":"Martin Grohe","orcid":"https://orcid.org/0000-0002-0292-9142"},"institutions":[{"id":"https://openalex.org/I39343248","display_name":"Humboldt-Universit\u00e4t zu Berlin","ror":"https://ror.org/01hcx6992","country_code":"DE","type":"education","lineage":["https://openalex.org/I39343248"]},{"id":"https://openalex.org/I4210117195","display_name":"HUN-REN Institute for Computer Science and Control","ror":"https://ror.org/0249v7n71","country_code":"HU","type":"facility","lineage":["https://openalex.org/I4210117195","https://openalex.org/I4387152226"]},{"id":"https://openalex.org/I7597260","display_name":"Hungarian Academy of Sciences","ror":"https://ror.org/02ks8qq67","country_code":"HU","type":"government","lineage":["https://openalex.org/I7597260"]},{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["DE","ES","HU"],"is_corresponding":false,"raw_author_name":"Martin Grohe","raw_affiliation_strings":["Computer and Automation Research Institute, Hungarian Academy of Sciences (MTA SZTAKI), Budapest, Hungary","Humboldt Universit\u00e4t zu Berlin Berlin, Germany","Universitat Polit\u00e8cnica de Catalunya Barcelona, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Computer and Automation Research Institute, Hungarian Academy of Sciences (MTA SZTAKI), Budapest, Hungary","institution_ids":["https://openalex.org/I4210117195","https://openalex.org/I7597260"]},{"raw_affiliation_string":"Humboldt Universit\u00e4t zu Berlin Berlin, Germany","institution_ids":["https://openalex.org/I39343248"]},{"raw_affiliation_string":"Universitat Polit\u00e8cnica de Catalunya Barcelona, Spain","institution_ids":["https://openalex.org/I9617848"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5012849997","display_name":"D\u00e1niel Marx","orcid":"https://orcid.org/0000-0002-5686-8314"},"institutions":[{"id":"https://openalex.org/I39343248","display_name":"Humboldt-Universit\u00e4t zu Berlin","ror":"https://ror.org/01hcx6992","country_code":"DE","type":"education","lineage":["https://openalex.org/I39343248"]},{"id":"https://openalex.org/I4210117195","display_name":"HUN-REN Institute for Computer Science and Control","ror":"https://ror.org/0249v7n71","country_code":"HU","type":"facility","lineage":["https://openalex.org/I4210117195","https://openalex.org/I4387152226"]},{"id":"https://openalex.org/I7597260","display_name":"Hungarian Academy of Sciences","ror":"https://ror.org/02ks8qq67","country_code":"HU","type":"government","lineage":["https://openalex.org/I7597260"]},{"id":"https://openalex.org/I9617848","display_name":"Universitat Polit\u00e8cnica de Catalunya","ror":"https://ror.org/03mb6wj31","country_code":"ES","type":"education","lineage":["https://openalex.org/I9617848"]}],"countries":["DE","ES","HU"],"is_corresponding":false,"raw_author_name":"D\u00e1niel Marx","raw_affiliation_strings":["Universitat Polit\u00e8cnica de Catalunya Barcelona, Spain","Humboldt Universit\u00e4t zu Berlin Berlin, Germany","Computer and Automation Research Institute, Hungarian Academy of Sciences (MTA SZTAKI), Budapest, Hungary"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universitat Polit\u00e8cnica de Catalunya Barcelona, Spain","institution_ids":["https://openalex.org/I9617848"]},{"raw_affiliation_string":"Humboldt Universit\u00e4t zu Berlin Berlin, Germany","institution_ids":["https://openalex.org/I39343248"]},{"raw_affiliation_string":"Computer and Automation Research Institute, Hungarian Academy of Sciences (MTA SZTAKI), Budapest, Hungary","institution_ids":["https://openalex.org/I4210117195","https://openalex.org/I7597260"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":6.5882,"has_fulltext":false,"cited_by_count":159,"citation_normalized_percentile":{"value":0.97091217,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":100},"biblio":{"volume":"42","issue":"4","first_page":"1737","last_page":"1767"},"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.9998000264167786,"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.996399998664856,"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/joins","display_name":"Joins","score":0.8753383159637451},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6418267488479614},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6003919839859009},{"id":"https://openalex.org/keywords/hypergraph","display_name":"Hypergraph","score":0.5891209244728088},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5460843443870544},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.531911313533783},{"id":"https://openalex.org/keywords/matching","display_name":"Matching (statistics)","score":0.5143646001815796},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.49569475650787354},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.4892270565032959},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.4793182611465454},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4745413064956665},{"id":"https://openalex.org/keywords/upper-and-lower-bounds","display_name":"Upper and lower bounds","score":0.4431198239326477},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.43496280908584595},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.4110734760761261},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4001932144165039},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2846373915672302},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1718926727771759},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.15617424249649048},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.14677906036376953},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.14134258031845093},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.10858467221260071},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.09074687957763672}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8753383159637451},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6418267488479614},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6003919839859009},{"id":"https://openalex.org/C2781221856","wikidata":"https://www.wikidata.org/wiki/Q840247","display_name":"Hypergraph","level":2,"score":0.5891209244728088},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5460843443870544},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.531911313533783},{"id":"https://openalex.org/C165064840","wikidata":"https://www.wikidata.org/wiki/Q1321061","display_name":"Matching (statistics)","level":2,"score":0.5143646001815796},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.49569475650787354},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.4892270565032959},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.4793182611465454},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4745413064956665},{"id":"https://openalex.org/C77553402","wikidata":"https://www.wikidata.org/wiki/Q13222579","display_name":"Upper and lower bounds","level":2,"score":0.4431198239326477},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.43496280908584595},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4110734760761261},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4001932144165039},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2846373915672302},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1718926727771759},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.15617424249649048},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.14677906036376953},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.14134258031845093},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.10858467221260071},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09074687957763672},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","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/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1137/110859440","is_oa":false,"landing_page_url":"https://doi.org/10.1137/110859440","pdf_url":null,"source":{"id":"https://openalex.org/S153560523","display_name":"SIAM Journal on Computing","issn_l":"0097-5397","issn":["0097-5397","1095-7111"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320508","host_organization_name":"Society for Industrial and Applied Mathematics","host_organization_lineage":["https://openalex.org/P4310320508"],"host_organization_lineage_names":["Society for Industrial and Applied Mathematics"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SIAM Journal on Computing","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W2030893020","https://openalex.org/W2041961594","https://openalex.org/W2046652577","https://openalex.org/W2077204415","https://openalex.org/W2081254453","https://openalex.org/W2157827214","https://openalex.org/W2158237121"],"related_works":["https://openalex.org/W2064616681","https://openalex.org/W2800160956","https://openalex.org/W2941854747","https://openalex.org/W1977331029","https://openalex.org/W2136572886","https://openalex.org/W4297453533","https://openalex.org/W3173375004","https://openalex.org/W4361194359","https://openalex.org/W906795786","https://openalex.org/W1461606193"],"abstract_inverted_index":{"Relational":[0],"joins":[1,51],"are":[2],"at":[3],"the":[4,13,16,32,48,72,81,92,101,110,131,148,153,173,180,200,205,215,218,222,230,234,249],"core":[5,14],"of":[6,15,50,60,104,115,214,217,233,244],"relational":[7],"algebra,":[8],"which":[9,147],"in":[10,71,76,179,195,226],"turn":[11],"is":[12,25,36,83,99,107,229],"standard":[17],"database":[18,41,82],"query":[19,42,106],"language":[20],"SQL.":[21],"As":[22],"their":[23],"evaluation":[24],"expensive":[26],"and":[27,52,75,139],"very":[28],"often":[29],"dominated":[30],"by":[31,109,133,140,152,209],"output":[33],"size,":[34],"it":[35],"an":[37,77,126],"important":[38],"task":[39],"for":[40,58,146],"optimizers":[43],"to":[44,53,86,124,203,240,247],"compute":[45],"estimates":[46],"on":[47],"size":[49,103,216],"find":[54],"good":[55],"execution":[56],"plans":[57],"sequences":[59],"joins.":[61],"We":[62,129,237],"study":[63],"these":[64],"problems":[65],"from":[66],"a":[67,87,105,119,135,190,197,210],"theoretical":[68],"perspective,":[69],"both":[70],"worst-case":[73,102],"model":[74,79],"average-case":[78,181],"where":[80],"chosen":[84],"according":[85],"known":[88,123],"probability":[89],"distribution.":[90],"In":[91],"former":[93],"case,":[94],"our":[95],"first":[96],"key":[97,223],"observation":[98],"that":[100,142,166,178,199],"characterized":[108],"fractional":[111,154],"edge":[112,155],"cover":[113,156],"number":[114],"its":[116],"underlying":[117,235],"hypergraph,":[118],"combinatorial":[120,224],"parameter":[121,225,246],"previously":[122],"provide":[125],"upper":[127],"bound.":[128],"complete":[130],"picture":[132],"proving":[134],"matching":[136],"lower":[137],"bound":[138],"showing":[141],"there":[143],"exist":[144],"queries":[145],"join-project":[149,184],"plan":[150,165,185,191,206],"suggested":[151],"approach":[157],"may":[158],"be":[159,187],"substantially":[160],"better":[161],"than":[162],"any":[163],"join":[164],"does":[167],"not":[168],"use":[169,243],"intermediate":[170],"projections.":[171,250],"On":[172],"other":[174],"hand,":[175],"we":[176],"show":[177,238],"model,":[182],"every":[183],"can":[186],"turned":[188],"into":[189],"containing":[192],"no":[193],"projections":[194],"such":[196],"way":[198],"expected":[201],"time":[202],"evaluate":[204],"increases":[207],"only":[208],"constant":[211],"factor":[212],"independent":[213],"database.":[219],"Not":[220],"surprisingly,":[221],"this":[227,245],"context":[228],"maximum":[231],"density":[232],"hypergraph.":[236],"how":[239],"make":[241],"effective":[242],"eliminate":[248]},"counts_by_year":[{"year":2026,"cited_by_count":9},{"year":2025,"cited_by_count":24},{"year":2024,"cited_by_count":12},{"year":2023,"cited_by_count":10},{"year":2022,"cited_by_count":12},{"year":2021,"cited_by_count":18},{"year":2020,"cited_by_count":15},{"year":2019,"cited_by_count":17},{"year":2018,"cited_by_count":13},{"year":2017,"cited_by_count":11},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":7},{"year":2014,"cited_by_count":5}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}