{"id":"https://openalex.org/W2032311942","doi":"https://doi.org/10.1145/2588555.2612175","title":"Overlap interval partition join","display_name":"Overlap interval partition join","publication_year":2014,"publication_date":"2014-06-18","ids":{"openalex":"https://openalex.org/W2032311942","doi":"https://doi.org/10.1145/2588555.2612175","mag":"2032311942"},"language":"en","primary_location":{"id":"doi:10.1145/2588555.2612175","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2612175","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 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/A5037964119","display_name":"Anton Dign\u00f6s","orcid":"https://orcid.org/0000-0002-7621-967X"},"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":true,"raw_author_name":"Anton Dign\u00f6s","raw_affiliation_strings":["University of Zurich, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"University of Zurich, Zurich, Switzerland","institution_ids":["https://openalex.org/I202697423"]}]},{"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":["University of Zurich, Zurich, Switzerland"],"affiliations":[{"raw_affiliation_string":"University of Zurich, Zurich, Switzerland","institution_ids":["https://openalex.org/I202697423"]}]},{"author_position":"last","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":["Free University of Bozen-Bolzano, Bozen, Italy","[Free University of Bozen-Bolzano, Bozen, Italy]"],"affiliations":[{"raw_affiliation_string":"Free University of Bozen-Bolzano, Bozen, Italy","institution_ids":["https://openalex.org/I171543936"]},{"raw_affiliation_string":"[Free University of Bozen-Bolzano, Bozen, Italy]","institution_ids":["https://openalex.org/I171543936"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5037964119"],"corresponding_institution_ids":["https://openalex.org/I202697423"],"apc_list":null,"apc_paid":null,"fwci":3.825,"has_fulltext":false,"cited_by_count":52,"citation_normalized_percentile":{"value":0.94127373,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1459","last_page":"1470"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9070188999176025},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.8927273750305176},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.7698251008987427},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.7182896137237549},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.620756983757019},{"id":"https://openalex.org/keywords/interval","display_name":"Interval (graph theory)","score":0.6105800271034241},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.5889101028442383},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.4585426151752472},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.37132829427719116},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.3524172306060791},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.31590455770492554},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.2662171721458435},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.19194212555885315},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.10473796725273132},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.05114266276359558}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.9070188999176025},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.8927273750305176},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.7698251008987427},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7182896137237549},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.620756983757019},{"id":"https://openalex.org/C2778067643","wikidata":"https://www.wikidata.org/wiki/Q166507","display_name":"Interval (graph theory)","level":2,"score":0.6105800271034241},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.5889101028442383},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.4585426151752472},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.37132829427719116},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.3524172306060791},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.31590455770492554},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.2662171721458435},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.19194212555885315},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.10473796725273132},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.05114266276359558}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/2588555.2612175","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2588555.2612175","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:doi:10.5167/uzh-97033","is_oa":false,"landing_page_url":null,"pdf_url":null,"source":{"id":"https://openalex.org/S4406922384","display_name":"Open MIND","issn_l":null,"issn":null,"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":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Text"},{"id":"pmh:oai:alma.39UBZ_INST:11235004640001241","is_oa":false,"landing_page_url":"https://dl.acm.org/doi/10.1145/2588555.2612175","pdf_url":null,"source":{"id":"https://openalex.org/S4210197018","display_name":"View","issn_l":"2688-268X","issn":["2688-268X","2688-3988"],"is_oa":false,"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":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","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":25,"referenced_works":["https://openalex.org/W1497953515","https://openalex.org/W1538270387","https://openalex.org/W1543685746","https://openalex.org/W1983721754","https://openalex.org/W1986050705","https://openalex.org/W1988991358","https://openalex.org/W2004788871","https://openalex.org/W2008196645","https://openalex.org/W2014879296","https://openalex.org/W2035579749","https://openalex.org/W2067082782","https://openalex.org/W2096659092","https://openalex.org/W2102023823","https://openalex.org/W2111406286","https://openalex.org/W2138033161","https://openalex.org/W2150610799","https://openalex.org/W2151135734","https://openalex.org/W2293307430","https://openalex.org/W2751601659","https://openalex.org/W3151741126","https://openalex.org/W3152703111","https://openalex.org/W4240483889","https://openalex.org/W4298236575","https://openalex.org/W6632537009","https://openalex.org/W6744131798"],"related_works":["https://openalex.org/W2393491644","https://openalex.org/W4206577045","https://openalex.org/W650102067","https://openalex.org/W3086237447","https://openalex.org/W2740404111","https://openalex.org/W1550806730","https://openalex.org/W1496672428","https://openalex.org/W2589740103","https://openalex.org/W2016456293","https://openalex.org/W1966967794"],"abstract_inverted_index":{"Each":[0],"tuple":[1],"in":[2],"a":[3],"valid-time":[4,22],"relation":[5],"includes":[6,47],"an":[7],"interval":[8],"attribute":[9],"T":[10],"that":[11],"represents":[12],"the":[13,45],"tuple's":[14],"valid":[15],"time.":[16],"The":[17],"overlap":[18,33],"join":[19],"between":[20],"two":[21],"relations":[23],"determines":[24],"all":[25],"pairs":[26],"of":[27],"tuples":[28,49],"with":[29],"overlapping":[30],"intervals.":[31],"Although":[32],"joins":[34],"are":[35,42],"common,":[36],"existing":[37],"partitioning":[38],"and":[39],"indexing":[40],"schemes":[41],"inefficient":[43],"if":[44,51],"data":[46],"long-lived":[48],"or":[50],"intervals":[52],"intersect":[53],"partition":[54],"boundaries.":[55]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":9},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":6}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}