{"id":"https://openalex.org/W3197576545","doi":"https://doi.org/10.1007/s00778-021-00692-3","title":"Leveraging range joins for the computation of overlap joins","display_name":"Leveraging range joins for the computation of overlap joins","publication_year":2021,"publication_date":"2021-08-28","ids":{"openalex":"https://openalex.org/W3197576545","doi":"https://doi.org/10.1007/s00778-021-00692-3","mag":"3197576545"},"language":"en","primary_location":{"id":"doi:10.1007/s00778-021-00692-3","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-021-00692-3","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-021-00692-3.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s00778-021-00692-3.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5037964119","display_name":"Anton Dign\u00f6s","orcid":"https://orcid.org/0000-0002-7621-967X"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Anton Dign\u00f6s","raw_affiliation_strings":["Faculty of Computer Science, Free University of Bozen-Bolzano, Dominikanerplatz 3, 39100, Bozen, Italy"],"affiliations":[{"raw_affiliation_string":"Faculty of Computer Science, Free University of Bozen-Bolzano, Dominikanerplatz 3, 39100, Bozen, Italy","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017018305","display_name":"Michael H. B\u00f6hlen","orcid":"https://orcid.org/0000-0003-3694-9026"},"institutions":[{"id":"https://openalex.org/I202697423","display_name":"University of Zurich","ror":"https://ror.org/02crff812","country_code":"CH","type":"education","lineage":["https://openalex.org/I202697423"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Michael H. B\u00f6hlen","raw_affiliation_strings":["Department of Computer Science, University of Zurich, Binzm\u00fchlestrasse 14, 8050, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Zurich, Binzm\u00fchlestrasse 14, 8050, Zurich, Switzerland","institution_ids":["https://openalex.org/I202697423"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043864804","display_name":"Johann Gamper","orcid":"https://orcid.org/0000-0002-7128-507X"},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Johann Gamper","raw_affiliation_strings":["Faculty of Computer Science, Free University of Bozen-Bolzano, Dominikanerplatz 3, 39100, Bozen, Italy"],"affiliations":[{"raw_affiliation_string":"Faculty of Computer Science, Free University of Bozen-Bolzano, Dominikanerplatz 3, 39100, Bozen, Italy","institution_ids":["https://openalex.org/I171543936"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5029380368","display_name":"Christian S. Jensen","orcid":"https://orcid.org/0000-0002-9697-7670"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Christian S. Jensen","raw_affiliation_strings":["Department of Computer Science, Aalborg University, Selma Lagerl\u00f6fs Vej 300, 9220, \u00c5lborg, Denmark"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Aalborg University, Selma Lagerl\u00f6fs Vej 300, 9220, \u00c5lborg, Denmark","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070118906","display_name":"Peter Moser","orcid":"https://orcid.org/0000-0002-7971-4246"},"institutions":[{"id":"https://openalex.org/I4210104565","display_name":"Fraunhofer Italia Research","ror":"https://ror.org/015hz7767","country_code":"IT","type":"nonprofit","lineage":["https://openalex.org/I4210104565","https://openalex.org/I4923324"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Peter Moser","raw_affiliation_strings":["A.- Volta Stra\u00dfe 13/A, 39100,  Bozen, Italy","NOI Techpark S\u00fcdtirol / Alto Adige, Bolzano, Italy"],"affiliations":[{"raw_affiliation_string":"A.- Volta Stra\u00dfe 13/A, 39100,  Bozen, Italy","institution_ids":["https://openalex.org/I4210104565"]},{"raw_affiliation_string":"NOI Techpark S\u00fcdtirol / Alto Adige, Bolzano, Italy","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5037964119"],"corresponding_institution_ids":["https://openalex.org/I171543936"],"apc_list":{"value":2290,"currency":"EUR","value_usd":2890},"apc_paid":{"value":2290,"currency":"EUR","value_usd":2890},"fwci":1.3885,"has_fulltext":true,"cited_by_count":12,"citation_normalized_percentile":{"value":0.8168138,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":97},"biblio":{"volume":"31","issue":"1","first_page":"75","last_page":"99"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"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"}},"topics":[{"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/T11269","display_name":"Algorithms and Data Compression","score":0.9991000294685364,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9975000023841858,"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.9886599779129028},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6145352125167847},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.5981684327125549},{"id":"https://openalex.org/keywords/range","display_name":"Range (aeronautics)","score":0.5261760950088501},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.14087927341461182},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.10227429866790771}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9886599779129028},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6145352125167847},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.5981684327125549},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.5261760950088501},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.14087927341461182},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.10227429866790771},{"id":"https://openalex.org/C146978453","wikidata":"https://www.wikidata.org/wiki/Q3798668","display_name":"Aerospace engineering","level":1,"score":0.0}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1007/s00778-021-00692-3","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-021-00692-3","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-021-00692-3.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"},{"id":"pmh:oai:pure.atira.dk:publications/d177b1df-9733-40d3-ba97-1889e5bcf59e","is_oa":true,"landing_page_url":"https://vbn.aau.dk/da/publications/d177b1df-9733-40d3-ba97-1889e5bcf59e","pdf_url":null,"source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Dign\u00f6s, A, B\u00f6hlen, M H, Gamper, J, Jensen, C S & Moser, P 2022, 'Leveraging range joins for the computation of overlap joins', VLDB Journal, vol. 31, no. 1, pp. 75-99. https://doi.org/10.1007/s00778-021-00692-3","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"pmh:oai:www.zora.uzh.ch:229650","is_oa":true,"landing_page_url":null,"pdf_url":null,"source":{"id":"https://openalex.org/S4306401281","display_name":"Zurich Open Repository and Archive (University of Zurich)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I202697423","host_organization_name":"University of Zurich","host_organization_lineage":["https://openalex.org/I202697423"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":"Dign\u00f6s, Anton; B\u00f6hlen, Michael Hanspeter; Gamper, Johann; Jensen, Christian S; Moser, Peter  (2022). Leveraging range joins for the computation of overlap joins.  The VLDB Journal, 31(1):75-99.","raw_type":"info:eu-repo/semantics/acceptedVersion"},{"id":"pmh:oai:alma.39UBZ_INST:11269617770001241","is_oa":true,"landing_page_url":"https://link.springer.com/article/10.1007/s00778-021-00692-3","pdf_url":null,"source":{"id":"https://openalex.org/S4210197018","display_name":"View","issn_l":"2688-268X","issn":["2688-268X","2688-3988"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"doi:10.5167/uzh-229650","is_oa":true,"landing_page_url":"https://doi.org/10.5167/uzh-229650","pdf_url":null,"source":{"id":"https://openalex.org/S7407051291","display_name":"Universit\u00e4t Z\u00fcrich, ZORA","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.1007/s00778-021-00692-3","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-021-00692-3","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-021-00692-3.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The VLDB Journal","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320313796","display_name":"Innovationsfonden","ror":"https://ror.org/00daj4111"},{"id":"https://openalex.org/F4320325400","display_name":"Libera Universit\u00e0 di Bolzano","ror":"https://ror.org/012ajp527"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3197576545.pdf","grobid_xml":"https://content.openalex.org/works/W3197576545.grobid-xml"},"referenced_works_count":34,"referenced_works":["https://openalex.org/W1983721754","https://openalex.org/W1988991358","https://openalex.org/W2008196645","https://openalex.org/W2032311942","https://openalex.org/W2058903936","https://openalex.org/W2079731068","https://openalex.org/W2083150957","https://openalex.org/W2092954093","https://openalex.org/W2096659092","https://openalex.org/W2116470353","https://openalex.org/W2118269922","https://openalex.org/W2122323423","https://openalex.org/W2128471644","https://openalex.org/W2151135734","https://openalex.org/W2188275531","https://openalex.org/W2269011405","https://openalex.org/W2288076324","https://openalex.org/W2293307430","https://openalex.org/W2444247778","https://openalex.org/W2512795599","https://openalex.org/W2546460896","https://openalex.org/W2590972148","https://openalex.org/W2751785830","https://openalex.org/W2767357121","https://openalex.org/W2883434932","https://openalex.org/W2884270003","https://openalex.org/W2892108048","https://openalex.org/W2901608006","https://openalex.org/W2923282531","https://openalex.org/W2997027240","https://openalex.org/W3004538570","https://openalex.org/W3149027868","https://openalex.org/W4242599275","https://openalex.org/W6931608348"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2088925915","https://openalex.org/W2382891957","https://openalex.org/W2393491644","https://openalex.org/W2067184662","https://openalex.org/W3047837489","https://openalex.org/W2622139626","https://openalex.org/W2339887996"],"abstract_inverted_index":{"Abstract":[0],"Joins":[1],"are":[2,58,66,76,83],"essential":[3],"and":[4,82,107,113,120,142,154,170,185],"potentially":[5],"expensive":[6],"operations":[7],"in":[8,31,78,125],"database":[9],"management":[10],"systems.":[11],"When":[12],"data":[13],"is":[14,40,90,123,148],"associated":[15],"with":[16,98,139,181],"time":[17,109],"periods,":[18],"joins":[19,57,70,97],"commonly":[20],"include":[21],"predicates":[22],"that":[23,93,135,147,160],"require":[24],"pairs":[25],"of":[26,62,173,193],"argument":[27],"tuples":[28],"to":[29,33,41,72,150],"overlap":[30,56,73],"order":[32],"qualify":[34],"for":[35,46],"the":[36,140,174,190,194],"result.":[37],"Our":[38],"goal":[39],"enable":[42],"built-in":[43],"systems":[44],"support":[45],"such":[47],"joins.":[48],"In":[49],"particular,":[50],"we":[51],"present":[52],"an":[53],"approach":[54,89],"where":[55],"formulated":[59],"as":[60,102,104],"unions":[61],"range":[63],"joins,":[64,74],"which":[65,122],"more":[67],"general":[68],"purpose":[69],"compared":[71],"i.e.,":[75],"useful":[77],"their":[79],"own":[80],"right,":[81],"supported":[84],"well":[85,103],"by":[86],"B+-trees.":[87],"The":[88,176],"sufficiently":[91],"flexible":[92],"it":[94],"also":[95],"supports":[96],"additional":[99],"equality":[100],"predicates,":[101],"open,":[105],"closed,":[106],"half-open":[108],"periods":[110],"over":[111],"discrete":[112],"continuous":[114],"domains,":[115],"thus":[116],"offering":[117],"both":[118,131,168],"generality":[119],"simplicity,":[121],"important":[124],"a":[126,132,143],"system":[127],"setting.":[128],"We":[129,166],"provide":[130],"stand-alone":[133],"solution":[134,146],"performs":[136],"on":[137,162],"par":[138],"state-of-the-art":[141],"DBMS":[144,158],"embedded":[145],"able":[149],"exploit":[151],"standard":[152],"indexing":[153,164],"clearly":[155],"outperforms":[156],"existing":[157,183],"solutions":[159],"depend":[161],"specialized":[163],"techniques.":[165],"offer":[167],"analytical":[169],"empirical":[171,177],"evaluations":[172],"proposals.":[175,195],"study":[178],"includes":[179],"comparisons":[180],"pertinent":[182],"proposals":[184],"offers":[186],"detailed":[187],"insight":[188],"into":[189],"performance":[191],"characteristics":[192]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}