Using Foreign Data Wrapper in PostgreSQL to Expose Point Clouds on File System

Master thesis (2020)

Authors

M. Deng Architecture and the Built Environment

Contributors

B.M. Meijers GIS Technologie - Architecture and the Built Environment (mentor)
P.J.M. van Oosterom GIS Technologie - Architecture and the Built Environment (mentor)
Faculty
Architecture and the Built Environment, Architecture and the Built Environment
Copyright: © 2020 Mutian Deng
More Info
expand_more

Published Date

09-11-2020

Language

English

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

Abstract

This research is aimed to answer the main research question: to what extent we can use LiDAR point clouds directly in the PostgreSQL by means of FDW, and thus a FDW supporting the Point Cloud Data Management System is implemented. Then, the range and performance of its functionality are evaluated. The results shows this FDW solution is feasible while the querying time is relevant to the number of returned points. The benefit and problem of this FDW are analyzed.