Open AccessAnalysis of Spatial Indexing Mechanism and Its Application in Data Management: A Case Study on Spatialite Database
Author(s) -
Chengkun Liu,
Rui Ma,
Li Zhang
Publication year - 2020
Publication title -
iop conference series. earth and environmental science
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.179
H-Index - 26
eISSN - 1755-1307
pISSN - 1755-1315
DOI - 10.1088/1755-1315/428/1/012037
Subject(s) - search engine indexing , spatial database , computer science , database , spatial analysis , index (typography) , data management , data mining , database index , spatiotemporal database , database design , pipeline (software) , information retrieval , view , database testing , geography , world wide web , remote sensing , programming language
Lightweight spatial database Spatialite is playing an increasing role in the current geographic information applications and other fields. This paper discusses the data organization and spatial indexing mechanism of Spatialite database in detail, studies the use of Spatialite database for data organization and index establishment, and utilizes the retrieval and spatial analysis methods supported by spatial index. The experiment takes urban pipeline data management as an example, through the visual application of urban pipeline data management in the 3DGIS environment, it provides a good solution for data management application of lightweight spatial database.