Translator Disclaimer
10 November 2008 On defining structured geometry types in PostgreSQL to implement a spatial database
Author Affiliations +
Proceedings Volume 7146, Geoinformatics 2008 and Joint Conference on GIS and Built Environment: Advanced Spatial Data Models and Analyses; 71460L (2008) https://doi.org/10.1117/12.813112
Event: Geoinformatics 2008 and Joint Conference on GIS and Built Environment: Geo-Simulation and Virtual GIS Environments, 2008, Guangzhou, China
Abstract
PostgreSQL is a widely used open source object-relational database system, on which the PostGIS spatial database is built. By defining geometry types in PostgreSQL according to the OGC WKB standard, geographic features are usually defined as a base type which is stored as general binary data blocks without internal structures. But the unstructured representation of the structured geometry data model brings the problem of inefficient data access. In this paper, we propose a new approach that uses an array of structured composite types to replace the unstructured base types to store geometry types. Then PostgreSQL 8.3 is extended to support spatial data management in this proposed approach following the standard of OGC's Simple Feature Specification. A contrastive experiment proves the advantages and efficiency of this method.
© (2008) COPYRIGHT Society of Photo-Optical Instrumentation Engineers (SPIE). Downloading of the abstract is permitted for personal use only.
Qian Huang, Yong Gao, and Xi Wu "On defining structured geometry types in PostgreSQL to implement a spatial database", Proc. SPIE 7146, Geoinformatics 2008 and Joint Conference on GIS and Built Environment: Advanced Spatial Data Models and Analyses, 71460L (10 November 2008); https://doi.org/10.1117/12.813112
PROCEEDINGS
8 PAGES


SHARE
Advertisement
Advertisement
RELATED CONTENT


Back to Top