AN APPROACH TO DEVELOP 3D GEO-DBMS TOPOLOGICAL OPERATORS BY RE-USING EXISTING 2D OPERATORS
Keywords: 3D, Geo-DBMS, 9IM, Oracle Spatial, topological function, city model
Abstract. Database systems are continuously extending their capabilities to store, process and analyse 3D data. Topological relationships which describe the interaction of objects in space is one of the important spatial issues. However, spatial operators for 3D objects are still insufficient. In this paper we present the development of a new 3D topological function to distinguish intersections of 3D planar polygons. The development uses existing 2D functions in the DBMS and two geometric transformations (rotation and projection). This function is tested for a real dataset to detect overlapping 3D city objects. The paper presents the algorithms and analyses the challenges. Suggestions for improvements of the current algorithm as well as possible extensions to handle more 3D topological cases are discussed at the end.