{"id":"https://openalex.org/W3121750545","doi":"https://doi.org/10.14778/3476249.3476306","title":"Beyond equi-joins","display_name":"Beyond equi-joins","publication_year":2021,"publication_date":"2021-07-01","ids":{"openalex":"https://openalex.org/W3121750545","doi":"https://doi.org/10.14778/3476249.3476306","mag":"3121750545","pmid":"https://pubmed.ncbi.nlm.nih.gov/35573749"},"language":"en","primary_location":{"id":"doi:10.14778/3476249.3476306","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3476249.3476306","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["arxiv","crossref","pubmed"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2101.12158","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5083668297","display_name":"Nikolaos Tziavelis","orcid":"https://orcid.org/0000-0001-8342-2177"},"institutions":[{"id":"https://openalex.org/I87182695","display_name":"Universidad del Noreste","ror":"https://ror.org/02ahky613","country_code":"MX","type":"education","lineage":["https://openalex.org/I87182695"]}],"countries":["MX"],"is_corresponding":true,"raw_author_name":"Nikolaos Tziavelis","raw_affiliation_strings":["Northeastern University"],"affiliations":[{"raw_affiliation_string":"Northeastern University","institution_ids":["https://openalex.org/I87182695"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086781628","display_name":"Wolfgang Gatterbauer","orcid":"https://orcid.org/0000-0002-9614-0504"},"institutions":[{"id":"https://openalex.org/I87182695","display_name":"Universidad del Noreste","ror":"https://ror.org/02ahky613","country_code":"MX","type":"education","lineage":["https://openalex.org/I87182695"]}],"countries":["MX"],"is_corresponding":false,"raw_author_name":"Wolfgang Gatterbauer","raw_affiliation_strings":["Northeastern University"],"affiliations":[{"raw_affiliation_string":"Northeastern University","institution_ids":["https://openalex.org/I87182695"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049802784","display_name":"Mirek Riedewald","orcid":"https://orcid.org/0000-0002-6102-7472"},"institutions":[{"id":"https://openalex.org/I87182695","display_name":"Universidad del Noreste","ror":"https://ror.org/02ahky613","country_code":"MX","type":"education","lineage":["https://openalex.org/I87182695"]}],"countries":["MX"],"is_corresponding":false,"raw_author_name":"Mirek Riedewald","raw_affiliation_strings":["Northeastern University"],"affiliations":[{"raw_affiliation_string":"Northeastern University","institution_ids":["https://openalex.org/I87182695"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5083668297"],"corresponding_institution_ids":["https://openalex.org/I87182695"],"apc_list":null,"apc_paid":null,"fwci":1.3849,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.80491407,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":93,"max":98},"biblio":{"volume":"14","issue":"11","first_page":"2599","last_page":"2612"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"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"}},"topics":[{"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9987999796867371,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9976999759674072,"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/joins","display_name":"Joins","score":0.9102323055267334},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.7091139554977417},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6301936507225037},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.6135950088500977},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5189251899719238},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4927261173725128},{"id":"https://openalex.org/keywords/enumeration","display_name":"Enumeration","score":0.4698333442211151},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.44878530502319336},{"id":"https://openalex.org/keywords/function","display_name":"Function (biology)","score":0.41259580850601196},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.3856952488422394},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.3765208125114441},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3688058853149414},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.311171293258667},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.20336031913757324},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12516942620277405}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9102323055267334},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7091139554977417},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6301936507225037},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.6135950088500977},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5189251899719238},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4927261173725128},{"id":"https://openalex.org/C156340839","wikidata":"https://www.wikidata.org/wiki/Q2704791","display_name":"Enumeration","level":2,"score":0.4698333442211151},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.44878530502319336},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.41259580850601196},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.3856952488422394},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.3765208125114441},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3688058853149414},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.311171293258667},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.20336031913757324},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12516942620277405},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C78458016","wikidata":"https://www.wikidata.org/wiki/Q840400","display_name":"Evolutionary biology","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.14778/3476249.3476306","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3476249.3476306","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmid:35573749","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/35573749","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment. International Conference on Very Large Data Bases","raw_type":null},{"id":"pmh:oai:arXiv.org:2101.12158","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2101.12158","pdf_url":"https://arxiv.org/pdf/2101.12158","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":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"pmh:oai:pubmedcentral.nih.gov:9106312","is_oa":true,"landing_page_url":"https://www.ncbi.nlm.nih.gov/pmc/articles/9106312","pdf_url":null,"source":{"id":"https://openalex.org/S2764455111","display_name":"PubMed Central","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings VLDB Endowment","raw_type":"Text"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2101.12158","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2101.12158","pdf_url":"https://arxiv.org/pdf/2101.12158","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":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[{"score":0.4399999976158142,"display_name":"Reduced inequalities","id":"https://metadata.un.org/sdg/10"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":100,"referenced_works":["https://openalex.org/W52840101","https://openalex.org/W203529317","https://openalex.org/W966413371","https://openalex.org/W1515568087","https://openalex.org/W1579803282","https://openalex.org/W1588115473","https://openalex.org/W1593142020","https://openalex.org/W1598698067","https://openalex.org/W1600580971","https://openalex.org/W1988991358","https://openalex.org/W1989783863","https://openalex.org/W1989800045","https://openalex.org/W1991477862","https://openalex.org/W1996327385","https://openalex.org/W2009688537","https://openalex.org/W2028659807","https://openalex.org/W2032775418","https://openalex.org/W2046167302","https://openalex.org/W2048685245","https://openalex.org/W2050100848","https://openalex.org/W2056102316","https://openalex.org/W2085933841","https://openalex.org/W2099755197","https://openalex.org/W2100859936","https://openalex.org/W2104947808","https://openalex.org/W2113123266","https://openalex.org/W2114334214","https://openalex.org/W2119806435","https://openalex.org/W2135463074","https://openalex.org/W2139273822","https://openalex.org/W2140620700","https://openalex.org/W2143238590","https://openalex.org/W2143682328","https://openalex.org/W2151645025","https://openalex.org/W2157734198","https://openalex.org/W2160987984","https://openalex.org/W2161956202","https://openalex.org/W2169998163","https://openalex.org/W2171361281","https://openalex.org/W2174643652","https://openalex.org/W2199514203","https://openalex.org/W2221389368","https://openalex.org/W2234276446","https://openalex.org/W2244843312","https://openalex.org/W2256684314","https://openalex.org/W2284514301","https://openalex.org/W2296148711","https://openalex.org/W2401576518","https://openalex.org/W2423871547","https://openalex.org/W2512795599","https://openalex.org/W2536131596","https://openalex.org/W2548695101","https://openalex.org/W2552956925","https://openalex.org/W2585424461","https://openalex.org/W2592257482","https://openalex.org/W2604519798","https://openalex.org/W2624791742","https://openalex.org/W2666600683","https://openalex.org/W2787819685","https://openalex.org/W2788708648","https://openalex.org/W2794645646","https://openalex.org/W2906408488","https://openalex.org/W2907255177","https://openalex.org/W2908063670","https://openalex.org/W2942813159","https://openalex.org/W2951155698","https://openalex.org/W2962896117","https://openalex.org/W2963066364","https://openalex.org/W2965868507","https://openalex.org/W2967222032","https://openalex.org/W2970342795","https://openalex.org/W2987825175","https://openalex.org/W2990166677","https://openalex.org/W2995253092","https://openalex.org/W3006809958","https://openalex.org/W3010534546","https://openalex.org/W3013054135","https://openalex.org/W3015629709","https://openalex.org/W3023361615","https://openalex.org/W3031875365","https://openalex.org/W3032788150","https://openalex.org/W3037451332","https://openalex.org/W3099336511","https://openalex.org/W3100346973","https://openalex.org/W3101014329","https://openalex.org/W3103899640","https://openalex.org/W3103927822","https://openalex.org/W3116393070","https://openalex.org/W3120740531","https://openalex.org/W3121750545","https://openalex.org/W3139244887","https://openalex.org/W3145128584","https://openalex.org/W3157068322","https://openalex.org/W3166830313","https://openalex.org/W3170665465","https://openalex.org/W3198801786","https://openalex.org/W4206237997","https://openalex.org/W4235295823","https://openalex.org/W4251391716","https://openalex.org/W4396167685"],"related_works":["https://openalex.org/W2393491644","https://openalex.org/W650102067","https://openalex.org/W4206577045","https://openalex.org/W3086237447","https://openalex.org/W2016456293","https://openalex.org/W1550806730","https://openalex.org/W2589740103","https://openalex.org/W3033055359","https://openalex.org/W2172084996","https://openalex.org/W1966967794"],"abstract_inverted_index":{"We":[0],"study":[1,243],"theta-joins":[2],"in":[3,14,26,51,76,147,240,253],"general":[4],"and":[5,10,40,121,143,158,168,225,251],"join":[6,59,154,182,189],"predicates":[7],"with":[8,44,61,156],"conjunctions":[9],"disjunctions":[11],"of":[12,49,68,100,123,161,181,190,213,259,265],"inequalities":[13],"particular,":[15],"focusing":[16],"on":[17],"<i>ranked":[18],"enumeration</i>":[19],"where":[20],"the":[21,47,52,70,115,134,141,179,214,231,256],"answers":[22,73,146],"are":[23,74],"returned":[24,75],"incrementally":[25],"an":[27,241],"order":[28],"dictated":[29],"by":[30,263],"a":[31,97,188,197,222],"given":[32,223],"ranking":[33],"function.":[34],"Our":[35,150],"approach":[36,247],"achieves":[37],"strong":[38],"time":[39,135,258],"space":[41],"complexity":[42,118],"properties:":[43],"<i>n</i>":[45,185],"denoting":[46],"number":[48,180],"tuples":[50],"database,":[53],"we":[54,238],"guarantee":[55],"for":[56,65,119,187,221],"acyclic":[57],"full":[58],"queries":[60,155,167],"inequality":[62],"conditions":[63],"that":[64,170,244],"<i>every</i>":[66],"value":[67],"<i>k</i>,":[69],"<i>k</i>":[71,145],"top-ranked":[72],"<mml:math":[77,101,124,199],"xmlns:mml=\"http://www.w3.org/1998/Math/MathML\"><mml:mrow><mml:mi>O</mml:mi>":[78,102,125,200],"<mml:mo>(</mml:mo>":[79,103,126,201],"<mml:mi>n</mml:mi>":[80,84,104,127,202,207],"<mml:mspace></mml:mspace>":[81,83,87,89,107,109,203,206],"<mml:mtext>polylog</mml:mtext>":[82],"<mml:mo>+</mml:mo>":[85,105,128],"<mml:mi>k</mml:mi>":[86,90,106,110,129],"<mml:mi>log</mml:mi>":[88,108,205],"<mml:mo>)</mml:mo></mml:mrow>":[91,111,130,208],"</mml:math>":[92,112,131,209],"time.":[93],"This":[94],"is":[95,184,196,218,248],"within":[96],"polylogarithmic":[98],"factor":[99],",":[113,132],"i.e.,":[114,133],"best":[116],"known":[117],"equi-joins,":[120,237],"even":[122,177],"it":[136],"takes":[137],"to":[138,153,229],"look":[139],"at":[140],"input":[142],"return":[144],"any":[148],"order.":[149],"guarantees":[151,235],"extend":[152],"selections":[157],"many":[159],"types":[160],"projections":[162],"(namely":[163],"those":[164,169],"called":[165],"\"free-connex\"":[166],"use":[171],"bag":[172],"semantics).":[173],"Remarkably,":[174],"they":[175],"hold":[176],"when":[178],"results":[183],"<sup><i>\u2113</i></sup>":[186],"<i>\u2113</i>":[191],"relations.":[192],"The":[193],"key":[194],"ingredient":[195],"novel":[198],"<mml:mtext>poly</mml:mtext>":[204],"-size":[210],"<i>factorized":[211],"representation":[212],"query":[215,224],"output</i>,":[216],"which":[217],"constructed":[219],"on-the-fly":[220],"database.":[226],"In":[227],"addition":[228],"providing":[230],"first":[232],"non-trivial":[233],"theoretical":[234],"beyond":[236],"show":[239],"experimental":[242],"our":[245],"ranked-enumeration":[246],"also":[249],"memory-efficient":[250],"fast":[252],"practice,":[254],"beating":[255],"running":[257],"state-of-the-art":[260],"database":[261],"systems":[262],"orders":[264],"magnitude.":[266]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2}],"updated_date":"2026-03-10T16:38:18.471706","created_date":"2021-02-01T00:00:00"}