Solid CAD Geometries in a Spatial DBMS

An Application in the Petrochemical Industry

Master thesis (2015)

Contributors

C.W. Quak (mentor)
S. Zlatanova (mentor)
Department
Geomatics (Architecture and the Built Environment) (TU Delft)
Copyright: © 2015 Ramkisoen, M.G.W.
More Info
expand_more

Published Date

02-11-2015

Reuse Rights

Other than for strictly personal use, it is not permitted to download, forward or distribute the text or part of it, without the consent of the author(s) and/or copyright holder(s), unless the work is under an open content license such as Creative Commons.

Faculty

Architecture and The Built Environment

Department

Geomatics

Abstract

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.