On defining structured geometry types in PostgreSQL to implement a spatial database

Qian Huang; Yong Gao; Xi Wu

doi:10.1117/12.813112

10 November 2008 On defining structured geometry types in PostgreSQL to implement a spatial database

Qian Huang, Yong Gao, Xi Wu

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.

Citation Download Citation

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

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available