{"id":"https://openalex.org/W2296132047","doi":"https://doi.org/10.1145/2820783.2820815","title":"Spatial queries with k-nearest-neighbor and relational predicates","display_name":"Spatial queries with k-nearest-neighbor and relational predicates","publication_year":2015,"publication_date":"2015-11-03","ids":{"openalex":"https://openalex.org/W2296132047","doi":"https://doi.org/10.1145/2820783.2820815","mag":"2296132047"},"language":"en","primary_location":{"id":"doi:10.1145/2820783.2820815","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2820783.2820815","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 23rd SIGSPATIAL International Conference on Advances in Geographic Information Systems","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/A5103509075","display_name":"Ahmed M. Aly","orcid":null},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ahmed M. Aly","raw_affiliation_strings":["Purdue University, West Lafayette, IN"],"affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, IN","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000123743","display_name":"Walid G. Aref","orcid":"https://orcid.org/0000-0001-8169-7775"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Walid G. Aref","raw_affiliation_strings":["Purdue University, West Lafayette, IN"],"affiliations":[{"raw_affiliation_string":"Purdue University, West Lafayette, IN","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5026923999","display_name":"Mourad Ouzzani","orcid":"https://orcid.org/0000-0002-4035-3025"},"institutions":[{"id":"https://openalex.org/I1301390666","display_name":"Qatar Airways (Qatar)","ror":"https://ror.org/01hx00y13","country_code":"QA","type":"company","lineage":["https://openalex.org/I1301390666"]}],"countries":["QA"],"is_corresponding":false,"raw_author_name":"Mourad Ouzzani","raw_affiliation_strings":["Qatar Computing Research Institute, Doha, Qatar"],"affiliations":[{"raw_affiliation_string":"Qatar Computing Research Institute, Doha, Qatar","institution_ids":["https://openalex.org/I1301390666"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5103509075"],"corresponding_institution_ids":["https://openalex.org/I219193219"],"apc_list":null,"apc_paid":null,"fwci":0.2872,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.59567397,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"10"},"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/T10757","display_name":"Geographic Information Systems Studies","score":0.9955000281333923,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9810000061988831,"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/computer-science","display_name":"Computer science","score":0.8064544200897217},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.8014614582061768},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.6162905693054199},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.5888307094573975},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5584612488746643},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5577528476715088},{"id":"https://openalex.org/keywords/predicate","display_name":"Predicate (mathematical logic)","score":0.48324212431907654},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4721619784832001},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4651307463645935},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.4461438059806824},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.44110068678855896},{"id":"https://openalex.org/keywords/k-nearest-neighbors-algorithm","display_name":"k-nearest neighbors algorithm","score":0.4354407787322998},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.4314599633216858},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.36431893706321716},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.19848984479904175},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.17820003628730774},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.17052987217903137},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.14108416438102722}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8064544200897217},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8014614582061768},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.6162905693054199},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.5888307094573975},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5584612488746643},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5577528476715088},{"id":"https://openalex.org/C140146324","wikidata":"https://www.wikidata.org/wiki/Q1144319","display_name":"Predicate (mathematical logic)","level":2,"score":0.48324212431907654},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4721619784832001},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4651307463645935},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.4461438059806824},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.44110068678855896},{"id":"https://openalex.org/C113238511","wikidata":"https://www.wikidata.org/wiki/Q1071612","display_name":"k-nearest neighbors algorithm","level":2,"score":0.4354407787322998},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4314599633216858},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.36431893706321716},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.19848984479904175},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.17820003628730774},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.17052987217903137},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.14108416438102722},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2820783.2820815","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2820783.2820815","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 23rd SIGSPATIAL International Conference on Advances in Geographic Information Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":43,"referenced_works":["https://openalex.org/W13268927","https://openalex.org/W96373761","https://openalex.org/W199102615","https://openalex.org/W1488681765","https://openalex.org/W1497953515","https://openalex.org/W1565494300","https://openalex.org/W1851595508","https://openalex.org/W1902703732","https://openalex.org/W1963619741","https://openalex.org/W1984525813","https://openalex.org/W1990111898","https://openalex.org/W2034409416","https://openalex.org/W2036666100","https://openalex.org/W2046144220","https://openalex.org/W2071898519","https://openalex.org/W2088630449","https://openalex.org/W2091638028","https://openalex.org/W2097280721","https://openalex.org/W2101999582","https://openalex.org/W2106475159","https://openalex.org/W2112129327","https://openalex.org/W2118269922","https://openalex.org/W2119441285","https://openalex.org/W2128793454","https://openalex.org/W2128813778","https://openalex.org/W2140048308","https://openalex.org/W2144771673","https://openalex.org/W2147874260","https://openalex.org/W2148306163","https://openalex.org/W2151135734","https://openalex.org/W2153307033","https://openalex.org/W2155369572","https://openalex.org/W2157234796","https://openalex.org/W2167254829","https://openalex.org/W2167275936","https://openalex.org/W2168532702","https://openalex.org/W2171903035","https://openalex.org/W2398168515","https://openalex.org/W4234792271","https://openalex.org/W4245801924","https://openalex.org/W6600511553","https://openalex.org/W6633810142","https://openalex.org/W6681978452"],"related_works":["https://openalex.org/W2901901036","https://openalex.org/W2397672765","https://openalex.org/W2147700044","https://openalex.org/W2900791740","https://openalex.org/W2143485006","https://openalex.org/W2950556518","https://openalex.org/W324232568","https://openalex.org/W2184143924","https://openalex.org/W2366367810","https://openalex.org/W1776802235"],"abstract_inverted_index":{"The":[0,154],"ubiquity":[1],"of":[2,12,147,162,194],"location-aware":[3],"devices":[4],"and":[5,22,27,76,113,151,180],"smartphones":[6],"has":[7,50],"unleashed":[8],"an":[9],"unprecedented":[10],"proliferation":[11],"location-based":[13],"services":[14],"that":[15,72,82,144,171,187],"require":[16],"processing":[17,33],"queries":[18,60,143,164,175],"with":[19,44,66],"both":[20],"spatial":[21,182],"relational":[23,68,92,125,152],"predicates.":[24,153],"Many":[25],"algorithms":[26],"index":[28],"structures":[29],"already":[30],"exist":[31],"for":[32,36,106,142],"k-Nearest-Neighbor":[34],"(kNN,":[35],"short)":[37,107],"predicates":[38,63,150],"either":[39],"solely":[40],"or":[41,95],"when":[42],"combined":[43,65],"textual":[45],"keyword":[46],"search.":[47],"Unfortunately,":[48],"there":[49],"not":[51],"been":[52],"enough":[53],"study":[54],"on":[55,174],"how":[56],"to":[57,116],"efficiently":[58],"process":[59],"where":[61],"kNN":[62,85,98,148],"are":[64,172],"general":[67],"predicates,":[69],"i.e.,":[70],"ones":[71],"have":[73],"selects,":[74],"joins":[75],"group-by's.":[77],"One":[78],"major":[79],"challenge":[80],"is":[81,86],"because":[83],"the":[84,160,177,188],"a":[87,91,97,101],"ranking":[88],"operation,":[89],"applying":[90],"predicate":[93,99],"before":[94],"after":[96],"in":[100,110,197],"query":[102,118,126,139,198],"evaluation":[103],"pipeline":[104],"(QEP,":[105],"can":[108,157,191],"result":[109],"different":[111,117],"outputs,":[112],"hence":[114],"leads":[115],"semantics.":[119,168],"In":[120],"particular,":[121],"this":[122],"renders":[123],"classical":[124],"optimization":[127,140],"heuristics,":[128],"e.g.,":[129],"pushing":[130],"selects":[131],"below":[132],"joins,":[133],"inapplicable.":[134],"This":[135],"paper":[136],"presents":[137],"various":[138],"heuristics":[141],"involve":[145],"combinations":[146],"select/join":[149],"proposed":[155,189],"optimizations":[156,190],"significantly":[158],"enhance":[159],"performance":[161],"these":[163],"while":[165],"preserving":[166],"their":[167],"Experimental":[169],"results":[170],"based":[173],"from":[176,184],"TPC-H":[178],"benchmark":[179],"real":[181],"data":[183],"OpenStreetMap":[185],"demonstrate":[186],"achieve":[192],"orders":[193],"magnitude":[195],"enhancement":[196],"performance.":[199]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":3},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2016,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}