{"id":"https://openalex.org/W2003765267","doi":"https://doi.org/10.1145/2534921.2534923","title":"The price of generality in spatial indexing","display_name":"The price of generality in spatial indexing","publication_year":2013,"publication_date":"2013-11-04","ids":{"openalex":"https://openalex.org/W2003765267","doi":"https://doi.org/10.1145/2534921.2534923","mag":"2003765267"},"language":"en","primary_location":{"id":"doi:10.1145/2534921.2534923","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2534921.2534923","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd ACM SIGSPATIAL International Workshop on Analytics for Big Geospatial 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/A5074634692","display_name":"Bogdan Simion","orcid":"https://orcid.org/0000-0002-2554-8705"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Bogdan Simion","raw_affiliation_strings":["University of Toronto"],"affiliations":[{"raw_affiliation_string":"University of Toronto","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5029923792","display_name":"Daniel N. Ilha","orcid":null},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Daniel N. Ilha","raw_affiliation_strings":["University of Toronto"],"affiliations":[{"raw_affiliation_string":"University of Toronto","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102801701","display_name":"Angela Demke Brown","orcid":"https://orcid.org/0000-0002-3615-3442"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Angela Demke Brown","raw_affiliation_strings":["University of Toronto"],"affiliations":[{"raw_affiliation_string":"University of Toronto","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071638205","display_name":"Ryan Johnson","orcid":"https://orcid.org/0000-0002-5800-7796"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Ryan Johnson","raw_affiliation_strings":["University of Toronto"],"affiliations":[{"raw_affiliation_string":"University of Toronto","institution_ids":["https://openalex.org/I185261750"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5074634692"],"corresponding_institution_ids":["https://openalex.org/I185261750"],"apc_list":null,"apc_paid":null,"fwci":0.9576,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.73931123,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"8","last_page":"12"},"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9961000084877014,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9923999905586243,"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/search-engine-indexing","display_name":"Search engine indexing","score":0.8987981081008911},{"id":"https://openalex.org/keywords/generality","display_name":"Generality","score":0.8550694584846497},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8246533274650574},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.6503178477287292},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.5841805934906006},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.5570733547210693},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.49944639205932617},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4979591369628906},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.45220234990119934},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4521227180957794},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.44628119468688965},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4361381530761719},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1425943374633789}],"concepts":[{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.8987981081008911},{"id":"https://openalex.org/C2780767217","wikidata":"https://www.wikidata.org/wiki/Q5532421","display_name":"Generality","level":2,"score":0.8550694584846497},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8246533274650574},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.6503178477287292},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.5841805934906006},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.5570733547210693},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.49944639205932617},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4979591369628906},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.45220234990119934},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4521227180957794},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.44628119468688965},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4361381530761719},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1425943374633789},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"id":"https://openalex.org/C542102704","wikidata":"https://www.wikidata.org/wiki/Q183257","display_name":"Psychotherapist","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2534921.2534923","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2534921.2534923","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd ACM SIGSPATIAL International Workshop on Analytics for Big Geospatial Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.6299999952316284}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W125925666","https://openalex.org/W1542146183","https://openalex.org/W1633157623","https://openalex.org/W2118269922","https://openalex.org/W2128471644","https://openalex.org/W2135961964","https://openalex.org/W2151135734","https://openalex.org/W4242599275","https://openalex.org/W4285719527","https://openalex.org/W6636710603"],"related_works":["https://openalex.org/W1505866794","https://openalex.org/W2527247821","https://openalex.org/W4237510188","https://openalex.org/W1973126996","https://openalex.org/W2048379072","https://openalex.org/W4301000806","https://openalex.org/W2059878404","https://openalex.org/W2185250746","https://openalex.org/W1562055306","https://openalex.org/W2151419829"],"abstract_inverted_index":{"Efficient":[0],"indexing":[1,31,36,41,55,67],"can":[2,87],"significantly":[3],"speed":[4],"up":[5,145],"the":[6,63,71,78,94,104,118,129,134,137,141,150,186],"processing":[7],"of":[8,11,46,169,177],"large":[9],"volumes":[10],"spatial":[12,21,170],"data":[13],"in":[14,74,109,184],"many":[15],"BigData":[16,171],"applications.":[17],"Many":[18],"new":[19,40,178],"emerging":[20],"applications":[22],"(e.g.,":[23],"biomedical":[24],"imaging,":[25],"genome":[26],"analysis,":[27],"etc.)":[28],"have":[29],"varying":[30],"requirements,":[32],"thus,":[33],"a":[34,53,58,122,162,166,191],"unified":[35],"infrastructure":[37],"for":[38,114,165],"implementing":[39,133],"schemes":[42],"without":[43],"requiring":[44],"knowledge":[45],"database":[47],"internals":[48],"is":[49,57,144,174],"beneficial.":[50],"However,":[51],"designing":[52,185],"generic":[54,163],"framework":[56,135,164],"challenging":[59],"task.":[60],"We":[61,126,158],"study":[62],"issues":[64],"with":[65],"general":[66],"schemes,":[68],"such":[69],"as":[70,107],"GiST":[72,105],"(used":[73],"PostGIS)":[75],"and":[76,82],"expose":[77],"tradeoff":[79],"between":[80],"generality":[81,86],"performance,":[83],"showing":[84,139],"that":[85,103,140,154,160],"be":[88,182],"severely":[89],"detrimental":[90],"to":[91,121,146,181,188],"performance":[92,193],"if":[93],"abstractions":[95,187],"are":[96],"not":[97],"carefully":[98],"designed.":[99],"Our":[100],"experiments":[101],"indicate":[102],"framework,":[106],"implemented":[108],"PostgreSQL/PostGIS,":[110],"performs":[111],"4.5-6x":[112],"slower":[113,148],"filtering":[115],"records":[116],"through":[117],"index,":[119],"compared":[120],"custom":[123],"R-tree":[124,143,152],"implementation.":[125],"also":[127],"isolate":[128],"GiST-specific":[130],"overhead":[131],"by":[132],"outside":[136],"DBMS,":[138],"GiST-based":[142],"2x":[147],"than":[149],"raw":[151],"algorithm":[153],"it":[155],"uses":[156],"internally.":[157],"conclude":[159],"although":[161],"wide":[167],"range":[168],"application":[172],"domains":[173],"desirable,":[175],"implementers":[176],"frameworks":[179],"need":[180],"careful":[183],"avoid":[189],"paying":[190],"hefty":[192],"penalty.":[194]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}