On Defining Structured Geometry Types in PostgreSQL to Implement a Spatial Database

摘要：

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 OGCs Simple Feature Specification.A contrastive experiment proves the advantages and efficiency of this method.

关键词： ORDB PostgreSQL Composition Type Spatial Database Spatial Data

作者: Qian Huang Yong Gao Xi Wu

作者单位: Institute of Remote Sensing and Geographic Information System,Peking University,Beijing,P.R.China 100871

会议类型: 国际会议

会议名称: 第16届国际地理信息科学与技术大会(16th International Conference on GeoInformatics and the Joint Conference)

会议地点: 广州

会议语种:英文

在线出版日期: 2008-06-28（万方平台首次上网日期，不代表论文的发表时间）