Performance study of various spatial indexes on 3D geo-data in Geo-RDBMS

In the emerging era of information and communication technologies, geotechnology is one of the fastest growing fields. Geo-RDBMS is very important and evolving aspect for GIS, as it can manage large volume of spatial data inside RDBMS. The utilization of RDBMS for geospatial data was one of the important focuses of GIS professionals in last decades to store and manage 2D geo-data. However, the support for 3D geo-data inside RDBMS is still limited and is a challenging task for RDBMS providers. In this study, data organization and performance assessment of 3D geo-data inside RDBMS are carried out. In this process, various file-based 3D data models such as CityGML, COLLADA and KML are migrated to geo-RDBMS to bring entire 3D geo-data in common platform. Various spatial indexing techniques viz. R-Tree, B-Tree, GiST, etc. are applied on these 3D data models and best indexing techniques are studied for 3D GIS operations.