{"id":"https://openalex.org/W2135669960","doi":"https://doi.org/10.1145/1353343.1353416","title":"Ring-constrained join","display_name":"Ring-constrained join","publication_year":2008,"publication_date":"2008-03-25","ids":{"openalex":"https://openalex.org/W2135669960","doi":"https://doi.org/10.1145/1353343.1353416","mag":"2135669960"},"language":"en","primary_location":{"id":"doi:10.1145/1353343.1353416","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353416","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353416","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353416","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5017431281","display_name":"Man Lung Yiu","orcid":"https://orcid.org/0000-0002-9619-4924"},"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":true,"raw_author_name":"Man Lung Yiu","raw_affiliation_strings":["Aalborg University, Aalborg, Denmark"],"affiliations":[{"raw_affiliation_string":"Aalborg University, Aalborg, Denmark","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103092057","display_name":"Panagiotis Karras","orcid":"https://orcid.org/0000-0003-0509-9129"},"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":"Panagiotis Karras","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/A5045731304","display_name":"Nikos Mamoulis","orcid":null},"institutions":[{"id":"https://openalex.org/I889458895","display_name":"University of Hong Kong","ror":"https://ror.org/02zhqgq86","country_code":"HK","type":"education","lineage":["https://openalex.org/I889458895"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Nikos Mamoulis","raw_affiliation_strings":["University of Hong Kong, Hong Kong"],"affiliations":[{"raw_affiliation_string":"University of Hong Kong, Hong Kong","institution_ids":["https://openalex.org/I889458895"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5017431281"],"corresponding_institution_ids":["https://openalex.org/I891191580"],"apc_list":null,"apc_paid":null,"fwci":0.3821,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.64487079,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"606","last_page":"617"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":1.0,"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":1.0,"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/T13282","display_name":"Automated Road and Building Extraction","score":0.9912999868392944,"subfield":{"id":"https://openalex.org/subfields/2212","display_name":"Ocean Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10757","display_name":"Geographic Information Systems Studies","score":0.9894000291824341,"subfield":{"id":"https://openalex.org/subfields/3305","display_name":"Geography, Planning and Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.7978639602661133},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.7067445516586304},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.618828535079956},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5973594784736633},{"id":"https://openalex.org/keywords/scale","display_name":"Scale (ratio)","score":0.47457054257392883},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.4571738839149475},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4562046527862549},{"id":"https://openalex.org/keywords/quadratic-equation","display_name":"Quadratic equation","score":0.4557393193244934},{"id":"https://openalex.org/keywords/computational-geometry","display_name":"Computational geometry","score":0.42305922508239746},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.365617036819458},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.30344247817993164},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.24099361896514893},{"id":"https://openalex.org/keywords/geometry","display_name":"Geometry","score":0.09200075268745422}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7978639602661133},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7067445516586304},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.618828535079956},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5973594784736633},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.47457054257392883},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.4571738839149475},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4562046527862549},{"id":"https://openalex.org/C129844170","wikidata":"https://www.wikidata.org/wiki/Q41299","display_name":"Quadratic equation","level":2,"score":0.4557393193244934},{"id":"https://openalex.org/C29123130","wikidata":"https://www.wikidata.org/wiki/Q874709","display_name":"Computational geometry","level":2,"score":0.42305922508239746},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.365617036819458},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.30344247817993164},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.24099361896514893},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.09200075268745422},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"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/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1145/1353343.1353416","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353416","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353416","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},{"id":"pmh:oai:www.zora.uzh.ch:8933","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":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":"Yiu, M L; Karras, P; Mamoulis, N  (2008). Ring-constrained Join: Deriving Fair Middleman Locations from Pointsets via a Geometric Constraint.  In: 11th Intl Conf. on Extending Database Technology (EDBT), Nantes, France, 26 February 2008 - 28 February 2008.","raw_type":"Conference or Workshop Item"},{"id":"pmh:oai:hub.hku.hk:10722/151909","is_oa":false,"landing_page_url":"http://hdl.handle.net/10722/151909","pdf_url":null,"source":{"id":"https://openalex.org/S4377196271","display_name":"The HKU Scholars Hub (University of Hong Kong)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I889458895","host_organization_name":"University of Hong Kong","host_organization_lineage":["https://openalex.org/I889458895"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Conference_Paper"},{"id":"pmh:oai:pure.atira.dk:publications/9d64c890-a319-11dc-8188-000ea68e967b","is_oa":false,"landing_page_url":"https://vbn.aau.dk/da/publications/9d64c890-a319-11dc-8188-000ea68e967b","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":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Yiu, M L, Karras, P & Mamoulis, N 2008, Ring-constrained Join : Deriving Fair Middleman Locations from Pointsets via a Geometric Constraint. in Proceedings of the 11th international conference on Extending database technology: Advances in database technology. Association for Computing Machinery (ACM), pp. 606-617, The 11th International Conference on Extending Database Technology (EDBT), Nantes, France, 25/03/2008. https://doi.org/10.1145/1353343.1353416","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"doi:10.5167/uzh-8933","is_oa":true,"landing_page_url":"https://doi.org/10.5167/uzh-8933","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":""}],"best_oa_location":{"id":"doi:10.1145/1353343.1353416","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1353343.1353416","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1353343.1353416","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 11th international conference on Extending database technology: Advances in database technology","raw_type":"proceedings-article"},"sustainable_development_goals":[{"score":0.4000000059604645,"id":"https://metadata.un.org/sdg/11","display_name":"Sustainable cities and communities"}],"awards":[{"id":"https://openalex.org/G4977938942","display_name":null,"funder_award_id":"HKU 7155/06E","funder_id":"https://openalex.org/F4320321592","funder_display_name":"Research Grants Council, University Grants Committee"}],"funders":[{"id":"https://openalex.org/F4320321592","display_name":"Research Grants Council, University Grants Committee","ror":"https://ror.org/00djwmt25"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2135669960.pdf","grobid_xml":"https://content.openalex.org/works/W2135669960.grobid-xml"},"referenced_works_count":30,"referenced_works":["https://openalex.org/W1512840853","https://openalex.org/W1549255393","https://openalex.org/W1564381193","https://openalex.org/W1982768666","https://openalex.org/W1990111898","https://openalex.org/W2008908114","https://openalex.org/W2046144220","https://openalex.org/W2058903936","https://openalex.org/W2059378307","https://openalex.org/W2072145795","https://openalex.org/W2100344784","https://openalex.org/W2116396741","https://openalex.org/W2118269922","https://openalex.org/W2123060058","https://openalex.org/W2123627620","https://openalex.org/W2129658824","https://openalex.org/W2136046112","https://openalex.org/W2151135734","https://openalex.org/W2153516438","https://openalex.org/W2162202557","https://openalex.org/W2610788652","https://openalex.org/W2997027240","https://openalex.org/W3003570628","https://openalex.org/W3004538570","https://openalex.org/W4206499008","https://openalex.org/W4239184613","https://openalex.org/W4242599275","https://openalex.org/W6632759956","https://openalex.org/W6683998681","https://openalex.org/W7027717352"],"related_works":["https://openalex.org/W2393491644","https://openalex.org/W4206577045","https://openalex.org/W3086237447","https://openalex.org/W650102067","https://openalex.org/W1550806730","https://openalex.org/W2589740103","https://openalex.org/W2172084996","https://openalex.org/W1966967794","https://openalex.org/W1501284171","https://openalex.org/W2397450670"],"abstract_inverted_index":{"We":[0,106,159],"introduce":[1],"a":[2,82],"novel":[3],"spatial":[4,18,171],"join":[5,9],"operator,":[6],"the":[7,20,41,98,117,153,156,162,183],"ring-constrained":[8],"(RCJ).":[10],"Given":[11],"two":[12],"sets":[13],"P":[14],"and":[15,46,73,102,129,169,186],"Q":[16],"of":[17,22,25,110,140,155,164],"points,":[19],"result":[21],"RCJ":[23,77,115],"consists":[24],"pairs":[26,104],"(p,":[27],"q)":[28],"(where":[29],"p":[30,45],"\u03b5":[31,34],"P,":[32,53],"q":[33,47],"Q)":[35],"satisfying":[36],"an":[37],"intuitive":[38],"geometric":[39,83,157],"constraint:":[40],"smallest":[42],"circle":[43],"enclosing":[44],"contains":[48],"no":[49],"other":[50],"points":[51],"in":[52,61,116],"Q.":[54],"This":[55],"new":[56],"operation":[57,93],"has":[58],"important":[59],"applications":[60],"decision":[62],"support,":[63],"e.g.,":[64],"placing":[65],"recycling":[66],"stations":[67],"at":[68],"fair":[69],"locations":[70],"between":[71,89],"restaurants":[72],"residential":[74],"complexes.":[75],"Clearly,":[76],"is":[78,94],"defined":[79],"based":[80,146],"on":[81,87,167],"constraint":[84],"but":[85],"not":[86,108,132],"distances":[88],"points.":[90],"Thus,":[91],"our":[92,165,177],"fundamentally":[95],"different":[96,191],"from":[97],"conventional":[99],"distance":[100],"joins":[101],"closest":[103],"problems.":[105],"are":[107],"aware":[109],"efficient":[111,144],"processing":[112],"algorithms":[113,147,179],"for":[114,135,148],"literature.":[118],"A":[119],"brute-force":[120],"solution":[121],"requires":[122],"computational":[123],"cost":[124],"quadratic":[125],"to":[126],"input":[127],"size":[128,185],"it":[130],"does":[131],"scale":[133,180],"well":[134,181],"large":[136],"datasets.":[137,172],"In":[138],"view":[139],"this,":[141],"we":[142],"develop":[143],"R-tree":[145],"computing":[149],"RCJ,":[150],"by":[151],"exploiting":[152],"characteristics":[154],"constraint.":[158],"evaluate":[160],"experimentally":[161],"efficiency":[163],"methods":[166],"synthetic":[168],"real":[170],"The":[173],"results":[174],"show":[175],"that":[176],"proposed":[178],"with":[182],"data":[184,192],"have":[187],"robust":[188],"performance":[189],"across":[190],"distributions.":[193]},"counts_by_year":[{"year":2012,"cited_by_count":1}],"updated_date":"2026-04-03T22:45:19.894376","created_date":"2025-10-10T00:00:00"}