APPLICATION OF SPATIAL INDEXING TECHNIQUES FOR MINERAL RESOURCE DATABASE
Main Article Content
Abstract
Mineral resource management is an important issue in each country's sustainable development strategies, of which the mineral spatial database is a major component of the management system. Nowadays, with the development of information collection and processing technologies, spatial data on mineral resources are bigger and bigger. This has led to a complicated demand of how to quickly query spatial data with millions of records. To solve the problem of big spatial data, spatial indexing technique is often used. In this paper, the authors will apply spatial indexing techniques in building mineral databases on PostGIS and evaluate the ability to query of using and not using spatial indexes. The results show that query time when using spatial index is much faster.
Keywords
mineral resource database, PostGIS, spatial indexing
Article Details
References
Chengkun, L., Rui, M. & Zhang, L. (2020). Analysis of Spatial Indexing Mechanism and Its Application in Data Management: A Case Study on Spatialite Database. Retrieved from https://www.researchgate.net/publication/338657937_Analysis_of_Spatial_Indexing_Mechanism_and_Its_Application_in_Data_Management_A_Case_Study_on_Spatialite_Database
Du, V. T. (2009). Nghien cuu chinh sach quan lí tai nguyen khoang san bien tai Viet Nam [Research policy on management of marine mineral resources in Vietnam]. Retrieved from https://www.researchgate.net/publication/280942930 Dinh huong chinh sach QLTN va EITI khoang san bien VN
Ernest, O., Ogbonna, A., Alli-Shehu, B. & Maduakolam, C. (2015). Mineral resources management information system. European Journal of Computer Science and Information System, 3(2), 13-23.
Hellerstein, J. M., Jeffrey, F. N. & Avi, P. (1995). Generalized Search Trees for Database Systems. Proceedings of the 21th International Conference on Very Large Data Bases, 562-573.
Nguyen, H. P., Le, A. T., Pham, Q. H., Nguyen, K. V. (2009). Ung dung cong nghe WebGIS xay dung co so du lieu dia chat khoang san, dia chat moi truong va tai bien dia chat cac vung bien Viet Nam [Application of WebGIS technology to build a database of geological minerals, environmental geology and geological assets in Vietnam's territorial waters]. Retrieved from http://www.idm.gov.vn/Data/TapChi/2009/A315/A71.htm
Nguyen, T. T. (2009). Indexing PostGIS databases and spatial Query performance evaluations. International Journal of Geoinformatics, 5(3), 1-9.
Neelabh, P., Mohammadhani, F., Ramez, E. & Kulsawasd, J. (2015). Performance comparison of spatial indexing structures for different query types. Proceedings of 57th IRF International Conference, 43-50.
Vikram, N., Jialin, D., Mohammad, A. & Tim, K. (2019). Learning Multi-dimensional Indexes. SIGMOD '20: Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data, 985-1000.
Vo, Q. M. (2012). Danh gia thuc trang va tien nang khai thac mot so san pham tu nguon tai nguyen set o DBSCL [Assessing the current status and potential of exploiting some products from clay resources in the Mekong Delta]. Retrieved from https://www.researchgate.net/publication/266494553_Danh_gia_thuc_trang_va_tiem_nang_khai_thac_mot_so_san_pham_tu_nguon_tai_nguyen_set_o_DBSCL