{"id":"https://openalex.org/W2167254829","doi":"https://doi.org/10.1145/1341012.1341073","title":"Pipelined spatial join processing for quadtree-based indexes","display_name":"Pipelined spatial join processing for quadtree-based indexes","publication_year":2007,"publication_date":"2007-11-07","ids":{"openalex":"https://openalex.org/W2167254829","doi":"https://doi.org/10.1145/1341012.1341073","mag":"2167254829"},"language":"en","primary_location":{"id":"doi:10.1145/1341012.1341073","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1341012.1341073","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th annual ACM international symposium 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/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":true,"raw_author_name":"Walid G. Aref","raw_affiliation_strings":["Purdue University"],"affiliations":[{"raw_affiliation_string":"Purdue University","institution_ids":["https://openalex.org/I219193219"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5000123743"],"corresponding_institution_ids":["https://openalex.org/I219193219"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.19258877,"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":"1","last_page":"4"},"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/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/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9914000034332275,"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.8089643120765686},{"id":"https://openalex.org/keywords/quadtree","display_name":"Quadtree","score":0.7468552589416504},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.7457700967788696},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.7173904180526733},{"id":"https://openalex.org/keywords/spatial-database","display_name":"Spatial database","score":0.7077904343605042},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.7048797607421875},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5399430394172668},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.5261133313179016},{"id":"https://openalex.org/keywords/r-tree","display_name":"R-tree","score":0.5254951119422913},{"id":"https://openalex.org/keywords/sort-merge-join","display_name":"Sort-merge join","score":0.49646884202957153},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4824579358100891},{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.4609110951423645},{"id":"https://openalex.org/keywords/spatial-analysis","display_name":"Spatial analysis","score":0.39096397161483765},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.3817152976989746},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.32200294733047485},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2582162022590637},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.25712862610816956},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.16454005241394043},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11034342646598816},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.10458177328109741},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.09870094060897827}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8089643120765686},{"id":"https://openalex.org/C151416825","wikidata":"https://www.wikidata.org/wiki/Q934791","display_name":"Quadtree","level":2,"score":0.7468552589416504},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7457700967788696},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.7173904180526733},{"id":"https://openalex.org/C203689450","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial database","level":3,"score":0.7077904343605042},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.7048797607421875},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5399430394172668},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5261133313179016},{"id":"https://openalex.org/C106278948","wikidata":"https://www.wikidata.org/wiki/Q1198051","display_name":"R-tree","level":4,"score":0.5254951119422913},{"id":"https://openalex.org/C203570394","wikidata":"https://www.wikidata.org/wiki/Q4060688","display_name":"Sort-merge join","level":3,"score":0.49646884202957153},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4824579358100891},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.4609110951423645},{"id":"https://openalex.org/C159620131","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Spatial analysis","level":2,"score":0.39096397161483765},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.3817152976989746},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.32200294733047485},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2582162022590637},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.25712862610816956},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.16454005241394043},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11034342646598816},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10458177328109741},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.09870094060897827},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1341012.1341073","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1341012.1341073","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th annual ACM international symposium on Advances in geographic information systems","raw_type":"proceedings-article"},{"id":"pmh:oai:docs.lib.purdue.edu:ccpubs-1252","is_oa":false,"landing_page_url":"https://docs.lib.purdue.edu/ccpubs/249","pdf_url":null,"source":{"id":"https://openalex.org/S4377196310","display_name":"Purdue e-Pubs (Purdue University System)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2801333002","host_organization_name":"Purdue University System","host_organization_lineage":["https://openalex.org/I2801333002"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Cyber Center Publications","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.158.9103","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.158.9103","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cerias.purdue.edu/ssl/techreports-ssl/a49-aref.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G2721342868","display_name":null,"funder_award_id":"IIS-0093116","funder_id":"https://openalex.org/F4320337389","funder_display_name":"Division of Information and Intelligent Systems"}],"funders":[{"id":"https://openalex.org/F4320337389","display_name":"Division of Information and Intelligent Systems","ror":"https://ror.org/053a2cp42"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1779898155","https://openalex.org/W1993997820","https://openalex.org/W2074429597","https://openalex.org/W2076399175","https://openalex.org/W2096137215","https://openalex.org/W2146476558","https://openalex.org/W2166087176","https://openalex.org/W2922084435","https://openalex.org/W4236783998","https://openalex.org/W4255901371"],"related_works":["https://openalex.org/W2104906863","https://openalex.org/W799526280","https://openalex.org/W2923247510","https://openalex.org/W3088660274","https://openalex.org/W2350865074","https://openalex.org/W2726114508","https://openalex.org/W2362227810","https://openalex.org/W2029306088","https://openalex.org/W2349549519","https://openalex.org/W2167254829"],"abstract_inverted_index":{"Spatial":[0,58],"join":[1,70,106,124,154],"is":[2,37,174,180],"an":[3],"important":[4],"yet":[5],"costly":[6],"operation":[7],"in":[8,50,56,60,75,108,141],"spatial":[9,20,31,43,69,88,105,123,139,153],"databases.":[10],"In":[11,80],"order":[12,81],"to":[13,82,132,151],"speed":[14],"up":[15],"the":[16,22,84,104,109,112,119,160,172,177],"execution":[17],"of":[18,86,111,121,171],"a":[19,38,76,142],"join,":[21],"input":[23,164],"tables":[24,165,173,185],"are":[25,91,166,186,189],"often":[26],"indexed":[27,175],"based":[28],"on":[29],"their":[30,157],"attributes.":[32],"The":[33,146],"quadtree":[34],"index":[35,40],"structure":[36],"well-known":[39],"for":[41,103,159],"organizing":[42],"database":[44,52],"objects.":[45],"It":[46],"has":[47],"been":[48],"implemented":[49],"several":[51,149],"management":[53],"systems,":[54],"e.g.,":[55],"Oracle":[57],"and":[59,126,156,182],"PostgreSQL":[61],"(via":[62],"SP-GiST).":[63],"Queries":[64],"typically":[65],"involve":[66,136],"multiple":[67,137],"pipelined":[68,138,152],"operators":[71,107],"that":[72,94,135],"fit":[73],"together":[74],"query":[77,113,143],"evaluation":[78,114,144],"plan.":[79,145],"extend":[83],"applicability":[85],"these":[87],"joins,":[89],"they":[90,99,128],"optimized":[92],"so":[93],"upon":[95],"receiving":[96],"sorted":[97,101,187],"input,":[98],"produce":[100],"output":[102],"upperlevels":[110],"pipeline.":[115],"This":[116],"paper":[117,147],"investigates":[118,148],"use":[120],"quadtree-based":[122],"algorithms":[125,155],"how":[127],"can":[129],"be":[130],"adapted":[131],"answer":[133],"queries":[134],"joins":[140],"adaptations":[150],"performance":[158],"cases":[161],"when":[162,168,183],"both":[163,184],"indexed,":[167],"only":[169],"one":[170],"while":[176],"second":[178],"table":[179],"sorted,":[181],"but":[188],"not":[190],"indexed.":[191]},"counts_by_year":[{"year":2015,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}