{"id":"https://openalex.org/W2057871242","doi":"https://doi.org/10.14778/2536222.2536228","title":"Statistics collection in oracle spatial and graph","display_name":"Statistics collection in oracle spatial and graph","publication_year":2013,"publication_date":"2013-08-01","ids":{"openalex":"https://openalex.org/W2057871242","doi":"https://doi.org/10.14778/2536222.2536228","mag":"2057871242"},"language":"en","primary_location":{"id":"doi:10.14778/2536222.2536228","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2536222.2536228","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5002696075","display_name":"Bhuvan Bamba","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Bhuvan Bamba","raw_affiliation_strings":["Oracle Spatial and Graph, Oracle America Inc"],"affiliations":[{"raw_affiliation_string":"Oracle Spatial and Graph, Oracle America Inc","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070313374","display_name":"Siva Ravada","orcid":"https://orcid.org/0000-0002-4066-8828"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Siva Ravada","raw_affiliation_strings":["Oracle Spatial and Graph, Oracle America Inc"],"affiliations":[{"raw_affiliation_string":"Oracle Spatial and Graph, Oracle America Inc","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085404129","display_name":"Ying Hu","orcid":"https://orcid.org/0000-0002-3904-1649"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ying Hu","raw_affiliation_strings":["Oracle Spatial and Graph, Oracle America Inc"],"affiliations":[{"raw_affiliation_string":"Oracle Spatial and Graph, Oracle America Inc","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5046442796","display_name":"Richard P. Anderson","orcid":"https://orcid.org/0000-0003-4087-7387"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Richard Anderson","raw_affiliation_strings":["Oracle Spatial and Graph, Oracle America Inc"],"affiliations":[{"raw_affiliation_string":"Oracle Spatial and Graph, Oracle America Inc","institution_ids":["https://openalex.org/I1342911587"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5002696075"],"corresponding_institution_ids":["https://openalex.org/I1342911587"],"apc_list":null,"apc_paid":null,"fwci":0.3232,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.58505408,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"6","issue":"11","first_page":"1021","last_page":"1032"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9990000128746033,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9986000061035156,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.7783501148223877},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7777243852615356},{"id":"https://openalex.org/keywords/spatial-analysis","display_name":"Spatial analysis","score":0.6574426293373108},{"id":"https://openalex.org/keywords/spatial-database","display_name":"Spatial database","score":0.5410711765289307},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5385692119598389},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.5175322890281677},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.512731671333313},{"id":"https://openalex.org/keywords/data-collection","display_name":"Data collection","score":0.47337502241134644},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.45163071155548096},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.37954795360565186},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.35998618602752686},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3400559425354004},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.2112429440021515},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11871516704559326}],"concepts":[{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.7783501148223877},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7777243852615356},{"id":"https://openalex.org/C159620131","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Spatial analysis","level":2,"score":0.6574426293373108},{"id":"https://openalex.org/C203689450","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial database","level":3,"score":0.5410711765289307},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5385692119598389},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.5175322890281677},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.512731671333313},{"id":"https://openalex.org/C133462117","wikidata":"https://www.wikidata.org/wiki/Q4929239","display_name":"Data collection","level":2,"score":0.47337502241134644},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.45163071155548096},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.37954795360565186},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35998618602752686},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3400559425354004},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.2112429440021515},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11871516704559326},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.0},{"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/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"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/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/2536222.2536228","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2536222.2536228","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W1601435884","https://openalex.org/W1659797312","https://openalex.org/W1793284863","https://openalex.org/W1822348499","https://openalex.org/W1968829657","https://openalex.org/W1987801991","https://openalex.org/W1996747841","https://openalex.org/W2011679994","https://openalex.org/W2029306088","https://openalex.org/W2046437776","https://openalex.org/W2079499902","https://openalex.org/W2091638028","https://openalex.org/W2116409564","https://openalex.org/W2117074936","https://openalex.org/W2118269922","https://openalex.org/W2118984514","https://openalex.org/W2120108467","https://openalex.org/W2130566946","https://openalex.org/W2131620262","https://openalex.org/W2134786002","https://openalex.org/W2137516889","https://openalex.org/W2146695070","https://openalex.org/W2150779766","https://openalex.org/W2151135734","https://openalex.org/W2151310484","https://openalex.org/W2155121477","https://openalex.org/W2160149182","https://openalex.org/W2171903035","https://openalex.org/W4231287357","https://openalex.org/W4234792271","https://openalex.org/W4236656499","https://openalex.org/W4244513784","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2361690318","https://openalex.org/W2355512078","https://openalex.org/W1502155832","https://openalex.org/W2122098189","https://openalex.org/W4251016002","https://openalex.org/W2372708426","https://openalex.org/W2358133679","https://openalex.org/W2019468830","https://openalex.org/W2092656406","https://openalex.org/W2377819299"],"abstract_inverted_index":{"Oracle":[0,104,182,257],"Spatial":[1,105,183],"and":[2,32,106,116,184,200,245],"Graph":[3],"is":[4,148],"a":[5,25,37,75,138,160,210],"geographic":[6],"information":[7],"system":[8],"(GIS)":[9],"which":[10,45,203,214,249],"provides":[11],"users":[12,40],"the":[13,28,70,95,108,123,142,149,205,219,238,251],"ability":[14],"to":[15,73,111,141,152,229],"store":[16],"spatial":[17,31,47,82,96,130,154],"data":[18,21,100,124,131],"alongside":[19],"conventional":[20],"in":[22,135,194],"Oracle.":[23],"As":[24],"result":[26],"of":[27,30,144,173,196,253],"coexistence":[29],"other":[33],"data,":[34],"we":[35,167,187,208,240],"observe":[36],"trend":[38],"towards":[39],"performing":[41],"increasingly":[42],"complex":[43,178,197],"queries":[44,58,80],"involve":[46],"as":[48,50,103],"well":[49],"non-spatial":[51],"predicates.":[52],"Accurate":[53],"selectivity":[54,115,233],"values,":[55],"especially":[56],"for":[57,69,129,137,159,177],"with":[59,171,190],"multiple":[60],"predicates":[61],"requiring":[62],"joins":[63],"among":[64],"numerous":[65],"tables,":[66],"are":[67],"essential":[68],"database":[71],"optimizer":[72,109],"determine":[74],"good":[76],"execution":[77],"plan.":[78],"For":[79,98],"involving":[81],"predicates,":[83],"this":[84,147,165],"requires":[85],"that":[86],"reasonably":[87],"accurate":[88,113,232],"statistics":[89,127,155,174],"collection":[90,128,156,175],"has":[91,132],"been":[92,133],"performed":[93],"on":[94,256],"data.":[97],"extensible":[99],"cartridges":[101],"such":[102],"Graph,":[107],"expects":[110],"receive":[112],"predicate":[114],"cost":[117],"values":[118],"from":[119],"functions":[120],"implemented":[121],"within":[122,181],"cartridge.":[125],"Although":[126],"researched":[134],"academia":[136],"few":[139],"years;":[140],"best":[143],"our":[145,169,254],"knowledge,":[146],"first":[150],"work":[151],"present":[153],"implementation":[157,172,213],"details":[158],"commercial":[161],"GIS":[162],"database.":[163],"In":[164],"paper,":[166],"describe":[168],"experiences":[170],"methods":[176],"geometry":[179,198],"objects":[180,199],"Graph.":[185],"Firstly,":[186],"exemplify":[188],"issues":[189],"previous":[191],"partitioning-based":[192],"algorithms":[193,222],"presence":[195],"suggest":[201],"enhancements":[202],"resolve":[204],"issues.":[206],"Secondly,":[207],"propose":[209],"main":[211],"memory":[212],"not":[215,237],"only":[216],"speeds":[217],"up":[218],"disk-based":[220],"partitioning":[221],"but":[223,236],"also":[224],"utilizes":[225],"existing":[226],"R-tree":[227],"indexes":[228],"provide":[230,241],"surprisingly":[231],"estimates.":[234],"Last":[235],"least,":[239],"extensive":[242],"experimental":[243],"results":[244],"an":[246],"example":[247],"study":[248],"displays":[250],"efficacy":[252],"approach":[255],"query":[258],"performance.":[259]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2026-03-28T08:17:26.163206","created_date":"2025-10-10T00:00:00"}