Object-Relation Model of ORACLE Spatial Database: with Discussion of RDB and OODB Application in GIS
-
摘要: 传统的关系数据库在GIS的应用中主要存在以下问题: 除数据类型简单, 不能很好地表达非结构化数据外, 也难以表示GIS中具有复杂结构的数据; 关系模型简单, 不能表达数据之间的层次, 继承、聚合、泛化或特化等在GIS广泛使用的关系; 与数据操纵语言如SQL和通用程序设计语言, 特别是目前流行的面向对象设计语言之间失配.采用面向对象技术可以较好地解决上述问题.ORACLE的空间数据库在传统的关系数据库上进行了面向对象的扩展, 即所谓对象-关系模式, 其核心在于增加了名为SDO-GEOMETRY的对象数据类型, 用于存储几何实体.ORACLE的空间数据库的应用示例表明: 以面向对象的形式表示空间数据比之于关系数据库中存放大量无意义的坐标有着很大的优势, 同时, 它在复合对象的表达方面, 在对于空间关系的处理方面都非常有效Abstract: There are some problems of RDB in GIS application. Sometimes the data type is too simple to describe non-structured or complex-structured data in GIS and the simple model can't express the relation of hierarchy, inheritance, aggregation, generalization or specialization, or there is impedance mismatch between SQL and programming language, especially the current popular object-oriented language. While object-oriented (OO) technology may be useful to solve these problems. ORACLE spatial database extends the traditional relation database with the technology, the so-called object-relation model, which features adding to RDB an object data type named SDO-GEOMETRY to store geometry. An application example of ORACLE spatial database demonstrated the advantages of OODB in describing spatial data and the efficiency in expressing compound object and processing spatial data compared to RDB which only stores meaningless data. Certainly, there are still some issues that need further research in OODB: which direction OODB will develop: pure OODB or object-relation DB, the data model match between RDB and OODB, the mathematic basis and formalization for OODB and how to take advantages of existing mature technologies of RDB such as transaction control, integrity check, data reproduction in the development of OODB.
-
[1] 李超岭, 张克信. 基于GIS技术的区域性多源地学空间信息集成若干问题探讨[J]. 地球科学——中国地质大学学报, 2001, 25(6): 545-550. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200105021.htmLI C L, ZHANG K X. Study on regional multi-source geological spatial information system based on techniques of GIS [J]. Earth Science—Journal of China University of Geosciences, 2001, 25(6): 545-550. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200105021.htm [2] 周成虎, 李军. 地球空间元数据研究[J]. 地球科学——中国地质大学学报, 2000, 25(6): 579-585. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200006006.htmZHOU C H, LI J. Research into geo-spatial metadata[J]. Earth Science—Journal of China University of Geosciences, 2000, 25(6): 579-585. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200006006.htm [3] 袁艳斌, 吴冲龙, 李伟忠. 面向野外地质填图的空间实体对象表达[J]. 地球科学——中国地质大学学报, 2001, 26(2): 192-196. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200102019.htmYUAN Y B, WU C L, LI W Z. Object styles of spatial entity for field geological mapping based on object-oriented method[J]. Earth Science—Journal of China University of Geosciences, 2001, 26(2): 192-196. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200102019.htm [4] 张夏林, 汪新庆, 吴冲龙. 计算机辅助地质填图属性数据采集子系统的动态数据模型[J]. 地球科学——中国地质大学学报, 2001, 26(2): 201-204. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200102021.htmZHANG X L, WANG X Q, WU C L. Dynamic data model applied in regional geological mapping computer-aided mapping system[J]. Earth Science—Journal of China University of Geosciences, 2001, 26(2): 201-204. https://www.cnki.com.cn/Article/CJFDTOTAL-DQKX200102021.htm [5] 李昭原. 数据库技术最新进展[M]. 北京: 清华大学出版社, 1997.LI Z Y. Proceeding of database technology[M]. Beijing: Tsinghua University Press, 1997. -
下载:
点击查看大图
图(1)
计量
- 文章访问数: 4018
- HTML全文浏览量: 503
- PDF下载量: 5
- 被引次数: 0
