Share Email Print
cover

Proceedings Paper

On defining structured geometry types in PostgreSQL to implement a spatial database
Author(s): Qian Huang; Yong Gao; Xi Wu
Format Member Price Non-Member Price
PDF $14.40 $18.00

Paper 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.

Paper Details

Date Published: 10 November 2008
PDF: 8 pages
Proc. SPIE 7146, Geoinformatics 2008 and Joint Conference on GIS and Built Environment: Advanced Spatial Data Models and Analyses, 71460L (10 November 2008); doi: 10.1117/12.813112
Show Author Affiliations
Qian Huang, Peking Univ. (China)
Yong Gao, Peking Univ. (China)
Xi Wu, Peking Univ. (China)


Published in SPIE Proceedings Vol. 7146:
Geoinformatics 2008 and Joint Conference on GIS and Built Environment: Advanced Spatial Data Models and Analyses
Lin Liu; Xia Li; Kai Liu; Xinchang Zhang, Editor(s)

© SPIE. Terms of Use
Back to Top