• 中国出版政府奖提名奖

    中国百强科技报刊

    湖北出版政府奖

    中国高校百佳科技期刊

    中国最美期刊

    LI Zhen-hua, 2002. Object-Relation Model of ORACLE Spatial Database: with Discussion of RDB and OODB Application in GIS. Earth Science, 27(3): 333-337.
    Citation: LI Zhen-hua, 2002. Object-Relation Model of ORACLE Spatial Database: with Discussion of RDB and OODB Application in GIS. Earth Science, 27(3): 333-337.

    Object-Relation Model of ORACLE Spatial Database: with Discussion of RDB and OODB Application in GIS

    • Received Date: 2001-11-16
    • Publish Date: 2002-05-25
    • 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.htm

      LI 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.htm

      ZHOU 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.htm

      YUAN 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.htm

      ZHANG 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.
    • Relative Articles

    • Created with Highcharts 5.0.7Amount of accessChart context menuAbstract Views, HTML Views, PDF Downloads StatisticsAbstract ViewsHTML ViewsPDF Downloads2024-082024-092024-102024-112024-122025-012025-022025-032025-042025-052025-062025-07010203040
      Created with Highcharts 5.0.7Chart context menuAccess Class DistributionFULLTEXT: 36.4 %FULLTEXT: 36.4 %META: 63.2 %META: 63.2 %PDF: 0.4 %PDF: 0.4 %FULLTEXTMETAPDF
      Created with Highcharts 5.0.7Chart context menuAccess Area Distribution其他: 4.4 %其他: 4.4 %其他: 0.1 %其他: 0.1 %China: 0.4 %China: 0.4 %Herndon: 0.1 %Herndon: 0.1 %Seattle: 0.1 %Seattle: 0.1 %上海: 1.3 %上海: 1.3 %东莞: 0.1 %东莞: 0.1 %北京: 27.3 %北京: 27.3 %南京: 0.2 %南京: 0.2 %南阳: 0.1 %南阳: 0.1 %台州: 0.2 %台州: 0.2 %呼和浩特: 0.3 %呼和浩特: 0.3 %商丘: 0.1 %商丘: 0.1 %天津: 0.1 %天津: 0.1 %广州: 0.3 %广州: 0.3 %张家口: 1.5 %张家口: 1.5 %成都: 0.2 %成都: 0.2 %扬州: 0.1 %扬州: 0.1 %杭州: 0.5 %杭州: 0.5 %武汉: 2.2 %武汉: 2.2 %深圳: 0.7 %深圳: 0.7 %温州: 0.2 %温州: 0.2 %湖州: 0.3 %湖州: 0.3 %湘潭: 0.1 %湘潭: 0.1 %漯河: 0.1 %漯河: 0.1 %澳大利亚新南威尔士悉尼: 0.1 %澳大利亚新南威尔士悉尼: 0.1 %盐城: 0.1 %盐城: 0.1 %石家庄: 0.1 %石家庄: 0.1 %美国伊利诺斯芝加哥: 0.1 %美国伊利诺斯芝加哥: 0.1 %芒廷维尤: 15.6 %芒廷维尤: 15.6 %芝加哥: 0.2 %芝加哥: 0.2 %衢州: 0.1 %衢州: 0.1 %西宁: 41.8 %西宁: 41.8 %邯郸: 0.1 %邯郸: 0.1 %重庆: 0.1 %重庆: 0.1 %金华: 0.1 %金华: 0.1 %长沙: 0.4 %长沙: 0.4 %阳泉: 0.1 %阳泉: 0.1 %其他其他ChinaHerndonSeattle上海东莞北京南京南阳台州呼和浩特商丘天津广州张家口成都扬州杭州武汉深圳温州湖州湘潭漯河澳大利亚新南威尔士悉尼盐城石家庄美国伊利诺斯芝加哥芒廷维尤芝加哥衢州西宁邯郸重庆金华长沙阳泉

    Catalog

      通讯作者: 陈斌, bchen63@163.com
      • 1. 

        沈阳化工大学材料科学与工程学院 沈阳 110142

      1. 本站搜索
      2. 百度学术搜索
      3. 万方数据库搜索
      4. CNKI搜索

      Figures(1)

      Article views (4236) PDF downloads(8) Cited by()
      Proportional views

      /

      DownLoad:  Full-Size Img  PowerPoint
      Return
      Return