计算机工程与应用 ›› 2007, Vol. 43 ›› Issue (30): 174-178.

• 数据库与信息处理 • 上一篇    下一篇

对象关系型空间数据库的访问方式的改进

薛露露,张 毅,郭建聪   

  1. 北京大学 遥感与地理信息系统研究所,北京,100871
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2007-10-21 发布日期:2007-10-21
  • 通讯作者: 薛露露

Improvement on access methods of object-relational spatial database

XUE Lu-lu,ZHANG Yi,GUO Jian-cong   

  1. Institute of RS & GIS,Peking University,Beijing 100871,China
  • Received:1900-01-01 Revised:1900-01-01 Online:2007-10-21 Published:2007-10-21
  • Contact: XUE Lu-lu

摘要: 对象关系型空间数据库使得地理空间对象可以作为一种新的类型存储到空间数据库中。然而索引访问方式与数据类型是紧密联系的。为了使空间数据库用户为每个新空间数据类型建立自己的索引,同时减轻工作量,对将GiST索引框架引入到空间数据库进行了介绍,并分析了GiST框架下的空间索引的好处与劣势。在此基础上,实现了访问效率较高的GiST R*树索引,并对其时间效率和空间效率进行测试。

Abstract: There is a new trend to apply the notion of ORDBMS to GIS(Geographical Information System),thus enables some new spatial data objects can be store in spatial database,which uses to be a obstacle in RDBMS.However,new object data type needs its particular access methods,with which common spatial index R tree can not be satisfied.To implement a fresh new access method for the new type usually cumbersome.Introduces a frame—generalized search tree frame to assist database users to extent their access methods.Based on this notion,implements a spatial index in PostgreSQL,and test the GiST’s efficiency.