{"id":"https://openalex.org/W1979950979","doi":"https://doi.org/10.1145/1463434.1463481","title":"Should SDBMS support a join index?","display_name":"Should SDBMS support a join index?","publication_year":2008,"publication_date":"2008-11-05","ids":{"openalex":"https://openalex.org/W1979950979","doi":"https://doi.org/10.1145/1463434.1463481","mag":"1979950979"},"language":"en","primary_location":{"id":"doi:10.1145/1463434.1463481","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1463434.1463481","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th ACM 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/A5008381500","display_name":"Pradeep Mohan","orcid":"https://orcid.org/0000-0001-5859-2625"},"institutions":[{"id":"https://openalex.org/I2800403580","display_name":"University of Minnesota System","ror":"https://ror.org/03grvy078","country_code":"US","type":"education","lineage":["https://openalex.org/I2800403580"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Pradeep Mohan","raw_affiliation_strings":["University of Minnesota"],"affiliations":[{"raw_affiliation_string":"University of Minnesota","institution_ids":["https://openalex.org/I2800403580"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112768733","display_name":"Ronald E. Wilson","orcid":null},"institutions":[{"id":"https://openalex.org/I4210096903","display_name":"National Institute of Justice","ror":"https://ror.org/00v8p7w89","country_code":"US","type":"government","lineage":["https://openalex.org/I1314586196","https://openalex.org/I4210096903"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ronald E. Wilson","raw_affiliation_strings":["National Institute of Justice, Washington D.C"],"affiliations":[{"raw_affiliation_string":"National Institute of Justice, Washington D.C","institution_ids":["https://openalex.org/I4210096903"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037233397","display_name":"Shashi Shekhar","orcid":"https://orcid.org/0000-0001-8837-192X"},"institutions":[{"id":"https://openalex.org/I2800403580","display_name":"University of Minnesota System","ror":"https://ror.org/03grvy078","country_code":"US","type":"education","lineage":["https://openalex.org/I2800403580"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shashi Shekhar","raw_affiliation_strings":["University of Minnesota"],"affiliations":[{"raw_affiliation_string":"University of Minnesota","institution_ids":["https://openalex.org/I2800403580"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031414656","display_name":"Betsy George","orcid":null},"institutions":[{"id":"https://openalex.org/I2800403580","display_name":"University of Minnesota System","ror":"https://ror.org/03grvy078","country_code":"US","type":"education","lineage":["https://openalex.org/I2800403580"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Betsy George","raw_affiliation_strings":["University of Minnesota"],"affiliations":[{"raw_affiliation_string":"University of Minnesota","institution_ids":["https://openalex.org/I2800403580"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010509805","display_name":"Ned Levine","orcid":"https://orcid.org/0000-0002-1053-2663"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ned Levine","raw_affiliation_strings":["Ned Levine and Associates, Houston, TX"],"affiliations":[{"raw_affiliation_string":"Ned Levine and Associates, Houston, TX","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5021467057","display_name":"Mete \u00c7elik","orcid":"https://orcid.org/0000-0002-1488-1502"},"institutions":[{"id":"https://openalex.org/I2800403580","display_name":"University of Minnesota System","ror":"https://ror.org/03grvy078","country_code":"US","type":"education","lineage":["https://openalex.org/I2800403580"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mete Celik","raw_affiliation_strings":["University of Minnesota"],"affiliations":[{"raw_affiliation_string":"University of Minnesota","institution_ids":["https://openalex.org/I2800403580"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5008381500"],"corresponding_institution_ids":["https://openalex.org/I2800403580"],"apc_list":null,"apc_paid":null,"fwci":0.7465,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.69672785,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"20","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":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.9959999918937683,"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.9782000184059143,"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.7241254448890686},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.6269578337669373},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.590175449848175},{"id":"https://openalex.org/keywords/terminology","display_name":"Terminology","score":0.5894376039505005},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5750001072883606},{"id":"https://openalex.org/keywords/spatial-database","display_name":"Spatial database","score":0.49550092220306396},{"id":"https://openalex.org/keywords/r-tree","display_name":"R-tree","score":0.4496333599090576},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.4195650517940521},{"id":"https://openalex.org/keywords/spatial-analysis","display_name":"Spatial analysis","score":0.4124758541584015},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.41148635745048523},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.20046257972717285},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.15315109491348267},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.14310547709465027}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7241254448890686},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.6269578337669373},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.590175449848175},{"id":"https://openalex.org/C547195049","wikidata":"https://www.wikidata.org/wiki/Q1725664","display_name":"Terminology","level":2,"score":0.5894376039505005},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5750001072883606},{"id":"https://openalex.org/C203689450","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial database","level":3,"score":0.49550092220306396},{"id":"https://openalex.org/C106278948","wikidata":"https://www.wikidata.org/wiki/Q1198051","display_name":"R-tree","level":4,"score":0.4496333599090576},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.4195650517940521},{"id":"https://openalex.org/C159620131","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Spatial analysis","level":2,"score":0.4124758541584015},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.41148635745048523},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.20046257972717285},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.15315109491348267},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.14310547709465027},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"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/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1463434.1463481","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1463434.1463481","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th ACM SIGSPATIAL international conference on Advances in geographic information systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5199999809265137,"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320309636","display_name":"University of Minnesota","ror":"https://ror.org/03grvy078"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W182681019","https://openalex.org/W1528270775","https://openalex.org/W1549255393","https://openalex.org/W1993997820","https://openalex.org/W2018978908","https://openalex.org/W2032101051","https://openalex.org/W2050576295","https://openalex.org/W2057552436","https://openalex.org/W2096725637","https://openalex.org/W2106642566","https://openalex.org/W2118269922","https://openalex.org/W2131620262","https://openalex.org/W2143022286","https://openalex.org/W2151135734","https://openalex.org/W2165420164","https://openalex.org/W2167698239","https://openalex.org/W2997027240"],"related_works":["https://openalex.org/W2366528791","https://openalex.org/W4251016002","https://openalex.org/W2122098189","https://openalex.org/W2111025582","https://openalex.org/W2357245552","https://openalex.org/W766042650","https://openalex.org/W1990417721","https://openalex.org/W2547353776","https://openalex.org/W2804139585","https://openalex.org/W2380104097"],"abstract_inverted_index":{"Given":[0],"a":[1,11,33,120,136,186],"spatial":[2,66,110,121,128,137,140,157,170,208,225],"crime":[3],"data":[4],"warehouse,":[5],"that":[6,38,178,218],"is":[7,30,54,84],"updated":[8],"infrequently":[9],"and":[10,22,60,73,81,150,193,233],"set":[12,34,46,95],"of":[13,20,35,44,47,89,96,106,119,134,165,197,230,235],"operations":[14,97],"O":[15],"as":[16,18,71,125,135,148,228],"well":[17],"constraints":[19],"storage":[21],"update":[23],"overheads,":[24],"the":[25,41,45,86,94,166,191,198,206],"index":[26,36,50,107,145,188],"type":[27,51],"selection":[28,52],"problem":[29,53],"to":[31,56,189],"find":[32],"types":[37,146],"can":[39,98,131,221],"reduce":[40],"I/O":[42],"cost":[43],"operations.":[48],"The":[49],"important":[55],"improve":[57],"user":[58],"experience":[59],"system":[61],"resource":[62],"utilization":[63],"in":[64,113,127,139],"crucial":[65],"statistics":[67],"application":[68,115],"domains":[69,116],"such":[70,147,227],"mapping":[72],"analysis":[74,159,226],"for":[75,212],"public":[76,78,213],"safety,":[77,214],"health,":[79],"ecology,":[80],"transportation.":[82],"This":[83],"because":[85,160],"response":[87],"time":[88],"frequent":[90],"queries":[91,112],"based":[92],"on":[93],"be":[99,132],"improved":[100],"significantly":[101,222],"by":[102],"an":[103],"effective":[104],"choice":[105],"types.":[108],"Many":[109],"statistical":[111,158,171,209],"these":[114],"make":[117],"use":[118],"neighborhood":[122],"matrix,":[123],"known":[124],"W":[126],"statistics,":[129],"which":[130],"thought":[133],"self-join":[138],"database":[141],"terminology.":[142],"Currently":[143],"supported":[144],"B-Tree":[149],"R-Tree":[151],"families":[152],"do":[153],"not":[154],"adequately":[155],"support":[156,185],"they":[161],"require":[162],"on-the-fly":[163,195],"computation":[164,196],"WMatrix,":[167],"slowing":[168],"down":[169],"analysis.":[172],"In":[173],"contrast,":[174],"this":[175],"paper":[176],"argues":[177],"Spatial":[179],"Database":[180],"Management":[181],"Systems":[182],"(SDBMS)":[183],"should":[184],"join":[187,219],"materialize":[190],"WMatrix":[192],"eliminate":[194],"common":[199],"selfjoin.":[200],"A":[201],"detailed":[202],"case":[203],"study":[204],"using":[205],"popular":[207],"software":[210],"package":[211],"namely":[215],"CrimeStat,":[216],"shows":[217],"indices":[220],"speed":[223],"up":[224],"calculation":[229],"Ripley's":[231],"K":[232],"identification":[234],"hotspots.":[236]},"counts_by_year":[{"year":2017,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}