Solid CAD Geometries in a Spatial DBMS: An Application in the Petrochemical Industry

Solid CAD Geometries in a Spatial DBMS: An Application in the Petrochemical Industry

Ramkisoen, M.G.W.

Van Oosterom, P.J.M. (mentor)
Quak, C.W. (mentor)
Zlatanova, S. (mentor)

Architecture and The Built Environment

Geomatics

2015-11-02

Fugro GeoServices is currently storing their CAD models of the Petrochemical Industry as attributes of 2D lines in a spatial DBMS. This solution works well for web visualization, but not for performing analyses in 3D. The main objective of this graduation project is to create a 3D spatial DBMS with solid CAD geometries as input. The difficulty of this graduation project is the conversion of CAD geometries to 3D GIS geometries. By linking parametric combination models (CAD) with solid polyhedral modelling (GIS) it is possible to reconstruct CAD geometries with help of its parameters as a polyhedron. This graduation thesis has compared the functionality performance of a 3D parametric DBMS with a 3D non-parametric database. For making an optimal comparison the 3D parametric DBMS had to be optimized as much as possible in terms of query execution time. However a 3D non-parametric DBMS has a better performance, it requires a lot of storage space. The 3D parametric DBMS requires less storage space, but needs some effort for optimizing the performance, such as defining functions for each geometry type, enabling index creation on PostgreSQL’s Box3D and making a function that converts this Box3D to a 3D geometry instead of a 2D polygon for querying.

CAD
GIS
CAD versus GIS
DBMS
Spatial DBMS
3D Parametric
3D Non-Parametric
geometry reconstruction
polyhedron
polyhedra
CSG
Parametric Combination Model

http://resolver.tudelft.nl/uuid:2b5044e5-388d-47ee-bb13-65bec9443070

Student theses

master thesis

(c) 2015 Ramkisoen, M.G.W.