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

Deng, Mutian

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

Title

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

Author

Deng, Mutian (TU Delft Architecture and the Built Environment)

Contributor

Meijers, B.M. (mentor)
van Oosterom, P.J.M. (mentor)

Degree granting institution

Delft University of Technology

Programme

Geomatics

Date

2020-11-09

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.

Subject

Foreign Data Wrapper
Point clouds data management
PostgreSQL

To reference this document use:

http://resolver.tudelft.nl/uuid:0182ce77-96e3-493b-a933-e91910b6302b

Part of collection

Student theses

Document type

master thesis

Rights

Files

PDF		Mutian_GraduationThesis_Final.pdf		1.52 MB
PDF		Mutian_P5_Presentation_1103.pdf		1.41 MB

Close viewer