{"id":"https://openalex.org/W2574252967","doi":"https://doi.org/10.3390/ijgi6010021","title":"A NoSQL\u2013SQL Hybrid Organization and Management Approach for Real-Time Geospatial Data: A Case Study of Public Security Video Surveillance","display_name":"A NoSQL\u2013SQL Hybrid Organization and Management Approach for Real-Time Geospatial Data: A Case Study of Public Security Video Surveillance","publication_year":2017,"publication_date":"2017-01-19","ids":{"openalex":"https://openalex.org/W2574252967","doi":"https://doi.org/10.3390/ijgi6010021","mag":"2574252967"},"language":"en","primary_location":{"id":"doi:10.3390/ijgi6010021","is_oa":true,"landing_page_url":"https://doi.org/10.3390/ijgi6010021","pdf_url":"https://www.mdpi.com/2220-9964/6/1/21/pdf?version=1484816605","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/1/21/pdf?version=1484816605","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5103595288","display_name":"Chen Wu","orcid":null},"institutions":[{"id":"https://openalex.org/I37461747","display_name":"Wuhan University","ror":"https://ror.org/033vjfk17","country_code":"CN","type":"education","lineage":["https://openalex.org/I37461747"]},{"id":"https://openalex.org/I4210118728","display_name":"State Key Laboratory of Information Engineering in Surveying Mapping and Remote Sensing","ror":"https://ror.org/02bpap860","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210118728"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chen Wu","raw_affiliation_strings":["Collaborative Innovation Center for Geospatial Technology, 129 Luoyu Road, Wuhan 430079, China","State Key Laboratory of Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, Wuhan 430079, China"],"affiliations":[{"raw_affiliation_string":"Collaborative Innovation Center for Geospatial Technology, 129 Luoyu Road, Wuhan 430079, China","institution_ids":[]},{"raw_affiliation_string":"State Key Laboratory of Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, Wuhan 430079, China","institution_ids":["https://openalex.org/I4210118728","https://openalex.org/I37461747"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046744673","display_name":"Qing Zhu","orcid":"https://orcid.org/0000-0002-0485-4965"},"institutions":[{"id":"https://openalex.org/I4210118728","display_name":"State Key Laboratory of Information Engineering in Surveying Mapping and Remote Sensing","ror":"https://ror.org/02bpap860","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210118728"]},{"id":"https://openalex.org/I37461747","display_name":"Wuhan University","ror":"https://ror.org/033vjfk17","country_code":"CN","type":"education","lineage":["https://openalex.org/I37461747"]},{"id":"https://openalex.org/I4800084","display_name":"Southwest Jiaotong University","ror":"https://ror.org/00hn7w693","country_code":"CN","type":"education","lineage":["https://openalex.org/I4800084"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Qing Zhu","raw_affiliation_strings":["Collaborative Innovation Center for Geospatial Technology, 129 Luoyu Road, Wuhan 430079, China","Faculty of Geosciences and Environmental Engineering of Southwest Jiaotong University, Chengdu 611756, China","State Key Laboratory of Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, Wuhan 430079, China"],"affiliations":[{"raw_affiliation_string":"Collaborative Innovation Center for Geospatial Technology, 129 Luoyu Road, Wuhan 430079, China","institution_ids":[]},{"raw_affiliation_string":"Faculty of Geosciences and Environmental Engineering of Southwest Jiaotong University, Chengdu 611756, China","institution_ids":["https://openalex.org/I4800084"]},{"raw_affiliation_string":"State Key Laboratory of Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, Wuhan 430079, China","institution_ids":["https://openalex.org/I4210118728","https://openalex.org/I37461747"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086109470","display_name":"Yeting Zhang","orcid":"https://orcid.org/0000-0002-9611-9051"},"institutions":[{"id":"https://openalex.org/I4210118728","display_name":"State Key Laboratory of Information Engineering in Surveying Mapping and Remote Sensing","ror":"https://ror.org/02bpap860","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210118728"]},{"id":"https://openalex.org/I37461747","display_name":"Wuhan University","ror":"https://ror.org/033vjfk17","country_code":"CN","type":"education","lineage":["https://openalex.org/I37461747"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Yeting Zhang","raw_affiliation_strings":["Collaborative Innovation Center for Geospatial Technology, 129 Luoyu Road, Wuhan 430079, China","State Key Laboratory of Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, Wuhan 430079, China"],"affiliations":[{"raw_affiliation_string":"Collaborative Innovation Center for Geospatial Technology, 129 Luoyu Road, Wuhan 430079, China","institution_ids":[]},{"raw_affiliation_string":"State Key Laboratory of Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, Wuhan 430079, China","institution_ids":["https://openalex.org/I4210118728","https://openalex.org/I37461747"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5077414358","display_name":"Zhiqiang Du","orcid":"https://orcid.org/0000-0002-8314-4354"},"institutions":[{"id":"https://openalex.org/I4210118728","display_name":"State Key Laboratory of Information Engineering in Surveying Mapping and Remote Sensing","ror":"https://ror.org/02bpap860","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210118728"]},{"id":"https://openalex.org/I37461747","display_name":"Wuhan University","ror":"https://ror.org/033vjfk17","country_code":"CN","type":"education","lineage":["https://openalex.org/I37461747"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhiqiang Du","raw_affiliation_strings":["Collaborative Innovation Center for Geospatial Technology, 129 Luoyu Road, Wuhan 430079, China","State Key Laboratory of Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, Wuhan 430079, China"],"affiliations":[{"raw_affiliation_string":"Collaborative Innovation Center for Geospatial Technology, 129 Luoyu Road, Wuhan 430079, China","institution_ids":[]},{"raw_affiliation_string":"State Key Laboratory of Information Engineering in Surveying, Mapping and Remote Sensing, Wuhan University, Wuhan 430079, China","institution_ids":["https://openalex.org/I4210118728","https://openalex.org/I37461747"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088393129","display_name":"Xinyue Ye","orcid":"https://orcid.org/0000-0001-8838-9476"},"institutions":[{"id":"https://openalex.org/I149910238","display_name":"Kent State University","ror":"https://ror.org/049pfb863","country_code":"US","type":"education","lineage":["https://openalex.org/I149910238"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Xinyue Ye","raw_affiliation_strings":["Department of Geography, Kent State University, Kent, OH 44240, USA"],"affiliations":[{"raw_affiliation_string":"Department of Geography, Kent State University, Kent, OH 44240, USA","institution_ids":["https://openalex.org/I149910238"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101414674","display_name":"Han Qin","orcid":"https://orcid.org/0000-0003-3786-3910"},"institutions":[{"id":"https://openalex.org/I162714631","display_name":"George Mason University","ror":"https://ror.org/02jqj7156","country_code":"US","type":"education","lineage":["https://openalex.org/I162714631"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Han Qin","raw_affiliation_strings":["Department of Geography and Geoinformation Science, George Mason University, Fairfax, VA 22030, USA"],"affiliations":[{"raw_affiliation_string":"Department of Geography and Geoinformation Science, George Mason University, Fairfax, VA 22030, USA","institution_ids":["https://openalex.org/I162714631"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5089874856","display_name":"Yan Zhou","orcid":"https://orcid.org/0000-0003-3381-357X"},"institutions":[{"id":"https://openalex.org/I31595395","display_name":"Chengdu University of Technology","ror":"https://ror.org/05pejbw21","country_code":"CN","type":"education","lineage":["https://openalex.org/I31595395"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yan Zhou","raw_affiliation_strings":["School of Resource and Environment, University of Electric Science and Technology, Chengdu 611731, China"],"affiliations":[{"raw_affiliation_string":"School of Resource and Environment, University of Electric Science and Technology, Chengdu 611731, China","institution_ids":["https://openalex.org/I31595395"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5046744673","https://openalex.org/A5086109470","https://openalex.org/A5088393129"],"corresponding_institution_ids":["https://openalex.org/I149910238","https://openalex.org/I37461747","https://openalex.org/I4210118728","https://openalex.org/I4800084"],"apc_list":{"value":1400,"currency":"CHF","value_usd":1515},"apc_paid":{"value":1400,"currency":"CHF","value_usd":1515},"fwci":2.7739,"has_fulltext":false,"cited_by_count":33,"citation_normalized_percentile":{"value":0.91326847,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"6","issue":"1","first_page":"21","last_page":"21"},"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/T10757","display_name":"Geographic Information Systems Studies","score":0.9973999857902527,"subfield":{"id":"https://openalex.org/subfields/3305","display_name":"Geography, Planning and Development"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social 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/nosql","display_name":"NoSQL","score":0.8975132703781128},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.815535843372345},{"id":"https://openalex.org/keywords/geospatial-analysis","display_name":"Geospatial analysis","score":0.7132947444915771},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6675494909286499},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6605353355407715},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.18700474500656128}],"concepts":[{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.8975132703781128},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.815535843372345},{"id":"https://openalex.org/C9770341","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Geospatial analysis","level":2,"score":0.7132947444915771},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6675494909286499},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6605353355407715},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.18700474500656128},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.3390/ijgi6010021","is_oa":true,"landing_page_url":"https://doi.org/10.3390/ijgi6010021","pdf_url":"https://www.mdpi.com/2220-9964/6/1/21/pdf?version=1484816605","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:0743bf0a98a84ed283bbd1ce51bed393","is_oa":true,"landing_page_url":"https://doaj.org/article/0743bf0a98a84ed283bbd1ce51bed393","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 1, p 21 (2017)","raw_type":"article"},{"id":"pmh:oai:mdpi.com:/2220-9964/6/1/21/","is_oa":true,"landing_page_url":"https://dx.doi.org/10.3390/ijgi6010021","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 1; Pages: 21","raw_type":"Text"}],"best_oa_location":{"id":"doi:10.3390/ijgi6010021","is_oa":true,"landing_page_url":"https://doi.org/10.3390/ijgi6010021","pdf_url":"https://www.mdpi.com/2220-9964/6/1/21/pdf?version=1484816605","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":[{"score":0.4000000059604645,"display_name":"Sustainable cities and communities","id":"https://metadata.un.org/sdg/11"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2574252967.pdf","grobid_xml":"https://content.openalex.org/works/W2574252967.grobid-xml"},"referenced_works_count":33,"referenced_works":["https://openalex.org/W79504326","https://openalex.org/W1506074306","https://openalex.org/W1568752909","https://openalex.org/W1927636871","https://openalex.org/W1972248659","https://openalex.org/W1997182427","https://openalex.org/W2001915690","https://openalex.org/W2006078337","https://openalex.org/W2038796765","https://openalex.org/W2091915921","https://openalex.org/W2099226020","https://openalex.org/W2099395665","https://openalex.org/W2115503987","https://openalex.org/W2119738171","https://openalex.org/W2153753043","https://openalex.org/W2159844592","https://openalex.org/W2176109926","https://openalex.org/W2302122772","https://openalex.org/W2313692530","https://openalex.org/W2330029115","https://openalex.org/W2343784482","https://openalex.org/W2379501755","https://openalex.org/W2503210624","https://openalex.org/W2517410460","https://openalex.org/W2525864832","https://openalex.org/W2547859479","https://openalex.org/W2613621456","https://openalex.org/W6603182501","https://openalex.org/W6673425627","https://openalex.org/W6677231548","https://openalex.org/W6682762287","https://openalex.org/W6685392830","https://openalex.org/W7015346116"],"related_works":["https://openalex.org/W2288951362","https://openalex.org/W3027702097","https://openalex.org/W2126420512","https://openalex.org/W2108941518","https://openalex.org/W3157676313","https://openalex.org/W1841120357","https://openalex.org/W2884115854","https://openalex.org/W2884906776","https://openalex.org/W4313444821","https://openalex.org/W2473889978"],"abstract_inverted_index":{"With":[0],"the":[1,20,56,116,133,141,155,170,176,183,212,217,229,254],"widespread":[2],"deployment":[3],"of":[4,12,23,55,70,84,132,135,144,157,169,224,232,242,247,256],"ground,":[5],"air":[6],"and":[7,34,65,68,101,109,121,137,147,179,181,199,216,221,235,260],"space":[8],"sensor":[9,18,177],"sources":[10],"(internet":[11],"things":[13],"or":[14],"IoT,":[15,180],"social":[16],"networks,":[17],"networks),":[19],"integrated":[21],"applications":[22],"real-time":[24,85,142,167,184,204],"geospatial":[25,51,73,86,188,214],"data":[26,52,74,87,146,161,173],"from":[27,203],"ubiquitous":[28],"sensors,":[29],"especially":[30],"in":[31,91],"public":[32,248],"security":[33,249],"smart":[35],"city":[36],"domains,":[37],"are":[38],"becoming":[39],"challenging":[40],"issues.":[41],"The":[42,164,190,207],"traditional":[43],"geographic":[44,243],"information":[45,194],"system":[46,63],"(GIS)":[47],"mostly":[48],"manages":[49,211],"time-discretized":[50],"by":[53],"means":[54],"Structured":[57],"Query":[58],"Language":[59],"(SQL)":[60],"database":[61,99,227],"management":[62,102,261],"(DBMS)":[64],"emphasizes":[66],"query":[67,185],"retrieval":[69],"massive":[71,213],"historical":[72],"on":[75,209],"disk.":[76],"This":[77,94,126],"limits":[78],"its":[79],"capability":[80],"for":[81,88,140,186],"on-the-fly":[82,149],"access":[83,143,168],"online":[89,187],"analysis":[90,150],"real":[92],"time.":[93],"paper":[95],"proposes":[96],"a":[97,225],"hybrid":[98,127,258],"organization":[100,259],"approach":[103,128],"with":[104],"SQL":[105,112,138],"relational":[106],"databases":[107,114],"(RDB)":[108],"not":[110],"only":[111],"(NoSQL)":[113],"(including":[115],"main":[117],"memory":[118],"database,":[119],"MMDB,":[120],"distributed":[122,222],"files":[123],"system,":[124],"DFS).":[125],"makes":[129],"full":[130],"use":[131],"advantages":[134],"NoSQL":[136,226],"DBMS":[139],"input":[145,172,205],"structured":[148],"results":[151],"which":[152],"can":[153],"meet":[154],"requirements":[156,231],"increased":[158],"spatio-temporal":[159],"big":[160],"linking":[162],"analysis.":[163,189],"MMDB":[165],"facilitates":[166],"latest":[171],"such":[174,195],"as":[175,196],"web":[178],"supports":[182],"RDB":[191],"stores":[192],"change":[193],"multi-modal":[197],"features":[198],"abnormal":[200],"events":[201],"extracted":[202],"data.":[206],"DFS":[208],"disk":[210],"data,":[215],"extensible":[218],"storage":[219,234],"architecture":[220],"scheduling":[223],"satisfy":[228],"performance":[230],"incremental":[233],"multi-user":[236],"concurrent":[237],"access.":[238],"A":[239],"case":[240],"study":[241],"video":[244],"(GeoVideo)":[245],"surveillance":[246],"is":[250],"presented":[251],"to":[252],"prove":[253],"feasibility":[255],"this":[257],"approach.":[262]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":6},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2017-01-26T00:00:00"}