{"id":"https://openalex.org/W3000232136","doi":"https://doi.org/10.1088/1755-1315/428/1/012037","title":"Analysis of Spatial Indexing Mechanism and Its Application in Data Management: A Case Study on Spatialite Database","display_name":"Analysis of Spatial Indexing Mechanism and Its Application in Data Management: A Case Study on Spatialite Database","publication_year":2020,"publication_date":"2020-01-01","ids":{"openalex":"https://openalex.org/W3000232136","doi":"https://doi.org/10.1088/1755-1315/428/1/012037","mag":"3000232136"},"language":"en","primary_location":{"id":"doi:10.1088/1755-1315/428/1/012037","doi":"https://doi.org/10.1088/1755-1315/428/1/012037","is_oa":true,"landing_page_url":"https://doi.org/10.1088/1755-1315/428/1/012037","pdf_url":"https://iopscience.iop.org/article/10.1088/1755-1315/428/1/012037/pdf","source":{"id":"https://openalex.org/S4210195883","display_name":"IOP Conference Series Earth and Environmental Science","issn_l":"1755-1315","issn":["1755-1315","1755-1307"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":"https://openalex.org/P4310320083","host_organization_name":"IOP Publishing","host_organization_lineage":["https://openalex.org/P4310320083","https://openalex.org/P4310311669"],"host_organization_lineage_names":["IOP Publishing","Institute of Physics"],"type":"conference"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IOP Conference Series: Earth and Environmental Science","raw_type":"journal-article"},"volume":null,"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://iopscience.iop.org/article/10.1088/1755-1315/428/1/012037/pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5112857418","display_name":"Chengkun Liu","orcid":"https://orcid.org/0000-0001-8999-482X","observed_orcids":["https://orcid.org/0000-0001-8999-482X","https://orcid.org/0000-0002-6899-211X"]},"institutions":[{"id":"https://openalex.org/I4210090238","display_name":"Changjiang Institute of Survey, Planning, Design and Research","ror":"https://ror.org/00bh8v131","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210090238"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Chengkun Liu","raw_affiliation_strings":["Changjiang Spatial Information Technology Engineering Co., Ltd, Wuhan, China","Changjiang Survey, Planning, Design and Research Co., Ltd, Wuhan, China","Water Resources Information Perception and Big Data Engineering Research Center of Hubei Province, Wuhan, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Changjiang Spatial Information Technology Engineering Co., Ltd, Wuhan, China","institution_ids":[]},{"raw_affiliation_string":"Changjiang Survey, Planning, Design and Research Co., Ltd, Wuhan, China","institution_ids":["https://openalex.org/I4210090238"]},{"raw_affiliation_string":"Water Resources Information Perception and Big Data Engineering Research Center of Hubei Province, Wuhan, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084165072","display_name":"Rui Ma","orcid":"https://orcid.org/0000-0001-9611-5870","observed_orcids":["https://orcid.org/0000-0001-9611-5870"]},"institutions":[{"id":"https://openalex.org/I4210090238","display_name":"Changjiang Institute of Survey, Planning, Design and Research","ror":"https://ror.org/00bh8v131","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210090238"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Rui Ma","raw_affiliation_strings":["Changjiang Spatial Information Technology Engineering Co., Ltd, Wuhan, China","Changjiang Survey, Planning, Design and Research Co., Ltd, Wuhan, China","Water Resources Information Perception and Big Data Engineering Research Center of Hubei Province, Wuhan, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Changjiang Spatial Information Technology Engineering Co., Ltd, Wuhan, China","institution_ids":[]},{"raw_affiliation_string":"Changjiang Survey, Planning, Design and Research Co., Ltd, Wuhan, China","institution_ids":["https://openalex.org/I4210090238"]},{"raw_affiliation_string":"Water Resources Information Perception and Big Data Engineering Research Center of Hubei Province, Wuhan, China","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100425578","display_name":"Li Zhang","orcid":"https://orcid.org/0000-0002-4535-3200","observed_orcids":["https://orcid.org/0000-0002-4535-3200"]},"institutions":[{"id":"https://openalex.org/I4210090238","display_name":"Changjiang Institute of Survey, Planning, Design and Research","ror":"https://ror.org/00bh8v131","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210090238"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Li Zhang","raw_affiliation_strings":["Changjiang Spatial Information Technology Engineering Co., Ltd, Wuhan, China","Changjiang Survey, Planning, Design and Research Co., Ltd, Wuhan, China","Water Resources Information Perception and Big Data Engineering Research Center of Hubei Province, Wuhan, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Changjiang Spatial Information Technology Engineering Co., Ltd, Wuhan, China","institution_ids":[]},{"raw_affiliation_string":"Changjiang Survey, Planning, Design and Research Co., Ltd, Wuhan, China","institution_ids":["https://openalex.org/I4210090238"]},{"raw_affiliation_string":"Water Resources Information Perception and Big Data Engineering Research Center of Hubei Province, Wuhan, China","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5084165072","https://openalex.org/A5100425578","https://openalex.org/A5112857418"],"corresponding_institution_ids":["https://openalex.org/I4210090238"],"apc_list":null,"apc_paid":null,"fwci":0.4873,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.55271058,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":95},"biblio":{"volume":"428","issue":"1","first_page":"012037","last_page":"012037"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.92330002784729,"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.92330002784729,"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/T12698","display_name":"3D Modeling in Geospatial Applications","score":0.052799999713897705,"subfield":{"id":"https://openalex.org/subfields/2215","display_name":"Building and Construction"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10757","display_name":"Geographic Information Systems Studies","score":0.01489999983459711,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/spatialite","display_name":"SpatiaLite","score":0.9449999928474426},{"id":"https://openalex.org/keywords/spatial-indexing","display_name":"spatial indexing","score":0.953000009059906},{"id":"https://openalex.org/keywords/spatial-data-management","display_name":"spatial data management","score":0.6430000066757202},{"id":"https://openalex.org/keywords/3d-gis","display_name":"3D GIS","score":0.8130000233650208},{"id":"https://openalex.org/keywords/spatial-analysis","display_name":"spatial analysis","score":0.7210000157356262}],"concepts":[{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.7976887226104736},{"id":"https://openalex.org/C203689450","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial database","level":3,"score":0.7846389412879944},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7126631736755371},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.654067873954773},{"id":"https://openalex.org/C159620131","wikidata":"https://www.wikidata.org/wiki/Q1938983","display_name":"Spatial analysis","level":2,"score":0.6517811417579651},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.5547010898590088},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.5230051875114441},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5179704427719116},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.5155472755432129},{"id":"https://openalex.org/C98080885","wikidata":"https://www.wikidata.org/wiki/Q7574095","display_name":"Spatiotemporal database","level":5,"score":0.5091399550437927},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.49837327003479004},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.49162060022354126},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.42480576038360596},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.2816847562789917},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.18405333161354065},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.13306760787963867},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.10571596026420593},{"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}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1088/1755-1315/428/1/012037","doi":"https://doi.org/10.1088/1755-1315/428/1/012037","is_oa":true,"landing_page_url":"https://doi.org/10.1088/1755-1315/428/1/012037","pdf_url":"https://iopscience.iop.org/article/10.1088/1755-1315/428/1/012037/pdf","source":{"id":"https://openalex.org/S4210195883","display_name":"IOP Conference Series Earth and Environmental Science","issn_l":"1755-1315","issn":["1755-1315","1755-1307"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":"https://openalex.org/P4310320083","host_organization_name":"IOP Publishing","host_organization_lineage":["https://openalex.org/P4310320083","https://openalex.org/P4310311669"],"host_organization_lineage_names":["IOP Publishing","Institute of Physics"],"type":"conference"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IOP Conference Series: Earth and Environmental Science","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1088/1755-1315/428/1/012037","doi":"https://doi.org/10.1088/1755-1315/428/1/012037","is_oa":true,"landing_page_url":"https://doi.org/10.1088/1755-1315/428/1/012037","pdf_url":"https://iopscience.iop.org/article/10.1088/1755-1315/428/1/012037/pdf","source":{"id":"https://openalex.org/S4210195883","display_name":"IOP Conference Series Earth and Environmental Science","issn_l":"1755-1315","issn":["1755-1315","1755-1307"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":["norway-1"],"host_organization":"https://openalex.org/P4310320083","host_organization_name":"IOP Publishing","host_organization_lineage":["https://openalex.org/P4310320083","https://openalex.org/P4310311669"],"host_organization_lineage_names":["IOP Publishing","Institute of Physics"],"type":"conference"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IOP Conference Series: Earth and Environmental Science","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/11","score":0.7250000238418579,"display_name":"Sustainable cities and communities"},{"id":"https://metadata.un.org/sdg/9","score":0.4943999946117401,"display_name":"Industry, innovation and infrastructure"}],"sustainable_development_goals_aurora":[{"id":"https://metadata.un.org/sdg/11","score":0.800000011920929,"display_name":"Sustainable cities and communities"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3000232136.pdf","grobid_xml":"https://content.openalex.org/works/W3000232136.grobid-xml"},"referenced_works_count":7,"referenced_works":["https://openalex.org/W1992393067","https://openalex.org/W2031473446","https://openalex.org/W2052021678","https://openalex.org/W2078622762","https://openalex.org/W2373500519","https://openalex.org/W2384450957","https://openalex.org/W2588253134"],"related_works":["https://openalex.org/W2347439478","https://openalex.org/W2085645038","https://openalex.org/W2379294600","https://openalex.org/W2384569056","https://openalex.org/W2391078121","https://openalex.org/W2388779816","https://openalex.org/W135134974","https://openalex.org/W2355143960","https://openalex.org/W2364562516","https://openalex.org/W2349228715"],"abstract_inverted_index":{"Abstract":[0],"Lightweight":[1],"spatial":[2,26,51,56,92],"database":[3,31,39],"Spatialite":[4,30,38],"is":[5],"playing":[6],"an":[7,66],"increasing":[8],"role":[9],"in":[10,32,77],"the":[11,22,35,48,69,78],"current":[12],"geographic":[13],"information":[14],"applications":[15],"and":[16,25,43,46,50],"other":[17],"fields.":[18],"This":[19],"paper":[20],"discusses":[21],"data":[23,41,63,75,87],"organization":[24,42],"indexing":[27],"mechanism":[28],"of":[29,37,72,90],"detail,":[33],"studies":[34],"use":[36],"for":[40,86],"index":[44],"establishment,":[45],"utilizes":[47],"retrieval":[49],"analysis":[52],"methods":[53],"supported":[54],"by":[55],"index.":[57],"The":[58],"experiment":[59],"takes":[60],"urban":[61,73],"pipeline":[62,74],"management":[64,76,88],"as":[65],"example,":[67],"through":[68],"visual":[70],"application":[71,89],"3DGIS":[79],"environment,":[80],"it":[81],"provides":[82],"a":[83],"good":[84],"solution":[85],"lightweight":[91],"database.":[93]},"counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":1}],"updated_date":"2026-09-24T07:57:37.273135","created_date":"2025-10-10T00:00:00"}