{"id":"https://openalex.org/W2752973987","doi":"https://doi.org/10.3390/ijgi6090285","title":"GeoSpark SQL: An Effective Framework Enabling Spatial Queries on Spark","display_name":"GeoSpark SQL: An Effective Framework Enabling Spatial Queries on Spark","publication_year":2017,"publication_date":"2017-09-08","ids":{"openalex":"https://openalex.org/W2752973987","doi":"https://doi.org/10.3390/ijgi6090285","mag":"2752973987"},"language":"en","primary_location":{"id":"doi:10.3390/ijgi6090285","is_oa":true,"landing_page_url":"https://doi.org/10.3390/ijgi6090285","pdf_url":"https://www.mdpi.com/2220-9964/6/9/285/pdf?version=1504872696","source":{"id":"https://openalex.org/S2764431341","display_name":"ISPRS International Journal of Geo-Information","issn_l":"2220-9964","issn":["2220-9964"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ISPRS International Journal of Geo-Information","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2220-9964/6/9/285/pdf?version=1504872696","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5010022619","display_name":"Zhou Huang","orcid":"https://orcid.org/0000-0002-1255-1913"},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]},{"id":"https://openalex.org/I4210165198","display_name":"Beijing Advanced Sciences and Innovation Center","ror":"https://ror.org/05qm21180","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210165198"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhou Huang","raw_affiliation_strings":["Beijing Advanced Innovation Center for Future Internet Technology, Beijing 100124, China","Institute of Remote Sensing & GIS, Peking University, Beijing 100871, China"],"affiliations":[{"raw_affiliation_string":"Beijing Advanced Innovation Center for Future Internet Technology, Beijing 100124, China","institution_ids":["https://openalex.org/I4210165198"]},{"raw_affiliation_string":"Institute of Remote Sensing & GIS, Peking University, Beijing 100871, China","institution_ids":["https://openalex.org/I20231570"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101795688","display_name":"Yiran Chen","orcid":"https://orcid.org/0000-0001-6626-5413"},"institutions":[{"id":"https://openalex.org/I20231570","display_name":"Peking University","ror":"https://ror.org/02v51f717","country_code":"CN","type":"education","lineage":["https://openalex.org/I20231570"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yiran Chen","raw_affiliation_strings":["Institute of Remote Sensing & GIS, Peking University, Beijing 100871, China"],"affiliations":[{"raw_affiliation_string":"Institute of Remote Sensing & GIS, Peking University, Beijing 100871, China","institution_ids":["https://openalex.org/I20231570"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079821971","display_name":"Lin Wan","orcid":null},"institutions":[{"id":"https://openalex.org/I3124059619","display_name":"China University of Geosciences","ror":"https://ror.org/04gcegc37","country_code":"CN","type":"education","lineage":["https://openalex.org/I3124059619"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lin Wan","raw_affiliation_strings":["Faculty of Information Engineering, China University of Geosciences, Wuhan 430074, China"],"affiliations":[{"raw_affiliation_string":"Faculty of Information Engineering, China University of Geosciences, Wuhan 430074, China","institution_ids":["https://openalex.org/I3124059619"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102984843","display_name":"Xia Peng","orcid":"https://orcid.org/0000-0001-7179-4635"},"institutions":[{"id":"https://openalex.org/I114234892","display_name":"Beijing Union University","ror":"https://ror.org/01hg31662","country_code":"CN","type":"education","lineage":["https://openalex.org/I114234892"]},{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"government","lineage":["https://openalex.org/I19820366"]},{"id":"https://openalex.org/I4210160793","display_name":"Institute of Geographic Sciences and Natural Resources Research","ror":"https://ror.org/04t1cdb72","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210160793"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Xia Peng","raw_affiliation_strings":["Collaborative Innovation Center of eTourism, Institute of Tourism, Beijing Union University, Beijing 100101, China","State Key Laboratory of Resources and Environmental Information System, Institute of Geographical Sciences and Natural Resources Research, Chinese Academy of Sciences, Beijing 100101, China"],"affiliations":[{"raw_affiliation_string":"Collaborative Innovation Center of eTourism, Institute of Tourism, Beijing Union University, Beijing 100101, China","institution_ids":["https://openalex.org/I114234892"]},{"raw_affiliation_string":"State Key Laboratory of Resources and Environmental Information System, Institute of Geographical Sciences and Natural Resources Research, Chinese Academy of Sciences, Beijing 100101, China","institution_ids":["https://openalex.org/I4210160793","https://openalex.org/I19820366"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5102984843"],"corresponding_institution_ids":["https://openalex.org/I114234892","https://openalex.org/I19820366","https://openalex.org/I4210160793"],"apc_list":{"value":1400,"currency":"CHF","value_usd":1515},"apc_paid":{"value":1400,"currency":"CHF","value_usd":1515},"fwci":8.0939,"has_fulltext":true,"cited_by_count":30,"citation_normalized_percentile":{"value":0.97524039,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"6","issue":"9","first_page":"285","last_page":"285"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9991999864578247,"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"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9991999864578247,"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/T11106","display_name":"Data Management and Algorithms","score":0.9987000226974487,"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.9945999979972839,"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.8609580397605896},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.821329653263092},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.769312858581543},{"id":"https://openalex.org/keywords/spark","display_name":"SPARK (programming language)","score":0.6739561557769775},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.6049927473068237},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5867772102355957},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5003499984741211},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.458100825548172},{"id":"https://openalex.org/keywords/spatial-database","display_name":"Spatial database","score":0.45790573954582214},{"id":"https://openalex.org/keywords/in-memory-processing","display_name":"In-Memory Processing","score":0.44858622550964355},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.4467252492904663},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4456692636013031},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.442740261554718},{"id":"https://openalex.org/keywords/pl/sql","display_name":"PL/SQL","score":0.4396522045135498},{"id":"https://openalex.org/keywords/spatial-analysis","display_name":"Spatial analysis","score":0.39796721935272217},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3400580883026123},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3036600351333618},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.29940518736839294},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.10463139414787292}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8609580397605896},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.821329653263092},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.769312858581543},{"id":"https://openalex.org/C2781215313","wikidata":"https://www.wikidata.org/wiki/Q3493345","display_name":"SPARK (programming language)","level":2,"score":0.6739561557769775},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.6049927473068237},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5867772102355957},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5003499984741211},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.458100825548172},{"id":"https://openalex.org/C203689450","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial database","level":3,"score":0.45790573954582214},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.44858622550964355},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.4467252492904663},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4456692636013031},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.442740261554718},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.4396522045135498},{"id":"https://openalex.org/C159620131","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Spatial analysis","level":2,"score":0.39796721935272217},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3400580883026123},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3036600351333618},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.29940518736839294},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.10463139414787292},{"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/C62649853","wikidata":"https://www.wikidata.org/wiki/Q199687","display_name":"Remote sensing","level":1,"score":0.0},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.3390/ijgi6090285","is_oa":true,"landing_page_url":"https://doi.org/10.3390/ijgi6090285","pdf_url":"https://www.mdpi.com/2220-9964/6/9/285/pdf?version=1504872696","source":{"id":"https://openalex.org/S2764431341","display_name":"ISPRS International Journal of Geo-Information","issn_l":"2220-9964","issn":["2220-9964"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ISPRS International Journal of Geo-Information","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:6308486f9e7b45b980f034faf84fbd12","is_oa":true,"landing_page_url":"https://doaj.org/article/6308486f9e7b45b980f034faf84fbd12","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ISPRS International Journal of Geo-Information, Vol 6, Iss 9, p 285 (2017)","raw_type":"article"},{"id":"pmh:oai:mdpi.com:/2220-9964/6/9/285/","is_oa":true,"landing_page_url":"https://dx.doi.org/10.3390/ijgi6090285","pdf_url":null,"source":{"id":"https://openalex.org/S4306400947","display_name":"MDPI (MDPI AG)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210097602","host_organization_name":"Multidisciplinary Digital Publishing Institute (Switzerland)","host_organization_lineage":["https://openalex.org/I4210097602"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ISPRS International Journal of Geo-Information; Volume 6; Issue 9; Pages: 285","raw_type":"Text"}],"best_oa_location":{"id":"doi:10.3390/ijgi6090285","is_oa":true,"landing_page_url":"https://doi.org/10.3390/ijgi6090285","pdf_url":"https://www.mdpi.com/2220-9964/6/9/285/pdf?version=1504872696","source":{"id":"https://openalex.org/S2764431341","display_name":"ISPRS International Journal of Geo-Information","issn_l":"2220-9964","issn":["2220-9964"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ISPRS International Journal of Geo-Information","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1121271761","display_name":null,"funder_award_id":"Program","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G2087396116","display_name":null,"funder_award_id":"China","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G2742591355","display_name":null,"funder_award_id":"201611","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3317480652","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3744313044","display_name":null,"funder_award_id":"Social","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3938669656","display_name":null,"funder_award_id":"41771425","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G466649759","display_name":null,"funder_award_id":"2017Y","funder_id":"https://openalex.org/F4320335777","funder_display_name":"National Key Research and Development Program of China"},{"id":"https://openalex.org/G5383135321","display_name":null,"funder_award_id":"41501162","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5994120800","display_name":null,"funder_award_id":"Natural","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G6882222862","display_name":null,"funder_award_id":"2016114","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G7608752429","display_name":null,"funder_award_id":"Talent","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G7707193948","display_name":null,"funder_award_id":"2017YFB0503602","funder_id":"https://openalex.org/F4320335777","funder_display_name":"National Key Research and Development Program of China"},{"id":"https://openalex.org/G8168612120","display_name":null,"funder_award_id":"41401449","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G8340078520","display_name":null,"funder_award_id":"2017YF","funder_id":"https://openalex.org/F4320335777","funder_display_name":"National Key Research and Development Program of China"},{"id":"https://openalex.org/G8823009050","display_name":null,"funder_award_id":"2017YFB","funder_id":"https://openalex.org/F4320335777","funder_display_name":"National Key Research and Development Program of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320322664","display_name":"Beijing Union University","ror":"https://ror.org/01hg31662"},{"id":"https://openalex.org/F4320326832","display_name":"State Key Laboratory of Resources and Environmental Information System","ror":null},{"id":"https://openalex.org/F4320335777","display_name":"National Key Research and Development Program of China","ror":null}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2752973987.pdf","grobid_xml":"https://content.openalex.org/works/W2752973987.grobid-xml"},"referenced_works_count":20,"referenced_works":["https://openalex.org/W126394981","https://openalex.org/W1505133516","https://openalex.org/W1907222889","https://openalex.org/W2042350736","https://openalex.org/W2059983124","https://openalex.org/W2102151885","https://openalex.org/W2169672215","https://openalex.org/W2295338537","https://openalex.org/W2324275352","https://openalex.org/W2333364538","https://openalex.org/W2364683740","https://openalex.org/W2481416449","https://openalex.org/W2519672472","https://openalex.org/W2548613432","https://openalex.org/W2556397884","https://openalex.org/W2598454225","https://openalex.org/W2963350265","https://openalex.org/W4238490858","https://openalex.org/W6687322159","https://openalex.org/W6702774062"],"related_works":["https://openalex.org/W580797181","https://openalex.org/W2184771611","https://openalex.org/W2356451189","https://openalex.org/W4242646855","https://openalex.org/W564005793","https://openalex.org/W4205307698","https://openalex.org/W71757354","https://openalex.org/W935248499","https://openalex.org/W2249485044","https://openalex.org/W2358551855"],"abstract_inverted_index":{"In":[0,129,231],"the":[1,26,33,49,65,73,80,99,110,132,145,150,156,173,200,216,224,228,245,249],"era":[2,81],"of":[3,23,51,82],"big":[4,83],"data,":[5,84],"Internet-based":[6],"geospatial":[7],"information":[8],"services":[9],"such":[10,222,243],"as":[11,223,244],"various":[12],"LBS":[13],"apps":[14],"are":[15,136],"deployed":[16],"everywhere,":[17],"followed":[18],"by":[19],"an":[20,58,87],"increasing":[21],"number":[22],"queries":[24,95,218,242],"against":[25],"massive":[27],"spatial":[28,36,53,76,94,151,161,202,217,241,250],"data.":[29],"As":[30],"a":[31,105,194],"result,":[32],"traditional":[34,201],"relational":[35],"database":[37,203],"(e.g.,":[38],"PostgreSQL":[39],"with":[40,219,239],"PostGIS":[41],"and":[42,85,120,127,138,159,172,227,248],"Oracle":[43],"Spatial)":[44],"cannot":[45],"adapt":[46],"well":[47],"to":[48,71,181],"needs":[50],"large-scale":[52,75],"query":[54,162,184,212,226,247],"processing.":[55,185],"Spark":[56,157,191],"is":[57,169,179,192,197],"emerging":[59],"outstanding":[60],"distributed":[61],"computing":[62,123],"framework":[63,89],"in":[64,79,155,210],"Hadoop":[66],"ecosystem.":[67],"This":[68],"paper":[69],"aims":[70],"address":[72],"increasingly":[74],"query-processing":[77],"requirement":[78],"proposes":[86],"effective":[88],"GeoSpark":[90,102,113,146,177,208,233],"SQL,":[91],"which":[92],"enables":[93],"on":[96,109],"Spark.":[97,128,166],"On":[98],"one":[100],"hand,":[101,112],"SQL":[103,107,114,147,178,209,234],"provides":[104],"convenient":[106],"interface;":[108],"other":[111],"achieves":[115],"both":[116],"efficient":[117],"storage":[118,141],"management":[119,142],"high-performance":[121],"parallel":[122],"through":[124],"integrating":[125],"Hive":[126],"this":[130],"study,":[131],"following":[133],"key":[134],"issues":[135],"discussed":[137],"addressed:":[139],"(1)":[140],"methods":[143,164],"under":[144,165],"framework,":[148],"(2)":[149],"operator":[152],"implementation":[153],"approach":[154],"environment,":[158],"(3)":[160],"optimization":[163],"Experimental":[167],"evaluation":[168],"also":[170],"performed":[171],"results":[174],"show":[175],"that":[176,190,199],"able":[180],"achieve":[182],"real-time":[183],"It":[186,196],"should":[187],"be":[188],"noted":[189],"not":[193],"panacea.":[195],"observed":[198],"PostGIS/PostgreSQL":[204],"performs":[205,235],"better":[206,236],"than":[207],"some":[211],"scenarios,":[213],"especially":[214],"for":[215],"high":[220],"selectivity,":[221],"point":[225],"window":[229],"query.":[230,252],"general,":[232],"when":[237],"dealing":[238],"compute-intensive":[240],"kNN":[246],"join":[251]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":6},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":6}],"updated_date":"2026-04-18T07:56:08.524223","created_date":"2017-09-15T00:00:00"}