Comparative analysis of data structures for storing massive tins in a DBMS

Conference Paper (2016)
Authors

Kavisha Kumar (TU Delft - Urban Data Science)

H. Ledoux (TU Delft - Urban Data Science)

J. Stoter (TU Delft - Urban Data Science)

Research Group
Urban Data Science
Copyright
© 2016 Kavisha Kumar, H. Ledoux, J.E. Stoter
More Info
expand_more
Publication Year
2016
Language
English
Copyright
© 2016 Kavisha Kumar, H. Ledoux, J.E. Stoter
Research Group
Urban Data Science
Volume number
41-B2
Pages (from-to)
123-130
DOI:
https://doi.org/10.5194/isprs-archives-XLI-B2-123-2016
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.

Abstract

Point cloud data are an important source for 3D geoinformation. Modern day 3D data acquisition and processing techniques such as airborne laser scanning and multi-beam echosounding generate billions of 3D points for simply an area of few square kilometers. With the size of the point clouds exceeding the billion mark for even a small area, there is a need for their efficient storage and management. These point clouds are sometimes associated with attributes and constraints as well. Storing billions of 3D points is currently possible which is confirmed by the initial implementations in Oracle Spatial SDO PC and the PostgreSQL Point Cloud extension. But to be able to analyse and extract useful information from point clouds, we need more than just points i.e. we require the surface defined by these points in space. There are different ways to represent surfaces in GIS including grids, TINs, boundary representations, etc. In this study, we investigate the database solutions for the storage and management of massive TINs. The classical (face and edge based) and compact (star based) data structures are discussed at length with reference to their structure, advantages and limitations in handling massive triangulations and are compared with the current solution of PostGIS Simple Feature. The main test dataset is the TIN generated from third national elevation model of the Netherlands (AHN3) with a point density of over 10 points/m2. PostgreSQL/PostGIS DBMS is used for storing the generated TIN. The data structures are tested with the generated TIN models to account for their geometry, topology, storage, indexing, and loading time in a database. Our study is useful in identifying what are the limitations of the existing data structures for storing massive TINs and what is required to optimise these structures for managing massive triangulations in a database.