Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Earth Science-journal of China University of Geosciences》 2002-03
Add to Favorite Get Latest Update

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

LI Zhen hua, LIU Xiu guo (Faculty of Information Engineering, China University of Geosciences, Wuhan430074, China)  
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.
【Fund】: 国家“九五”重中之重科技攻关项目 (No .96 -B0 2 - 0 3-0 5 )
【CateGory Index】: P208
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【References】
Chinese Journal Full-text Database 9 Hits
1 HAN Zhi-gang②, QIN Fen②, CUI Cai-hui②(China-Australia Cooperative Research Institute for Geographic Information Analysis and Applications, Henan University,475004,Kaifeng,China; ②College of Environmental & Planning, Henan University,Kaifeng,475004,China);The design and realization of distributed cadastral alteration system based on J2EE[J];Science of Surveying and Mapping;2008-01
2 ZHANG Xi-wang①,LIU Jian-feng②(① Institude of Remote Sensing Applications,CA S,Beijing 100101,China;② Yellow River Conservancy Technical Institute,Henan Kaifeng 475003,China);Research on rural public health management information system based on GIS[J];Science of Surveying and Mapping;2009-01
3 MO Lan, ZHENG Gui-zhou (Faculty of Information Engineering, China University of Geosciences, Wuhan, Hubei430074, China);Examine the Spatial Functions in DBMS/CAD from GIS[J];Surveying and Mapping of Geology and Mineral Resources;2003-04
4 ZHOU Qin1,2, LI Shaojun2, SONG Guanfu1,2, ZENG Zhiming1,2 (1 Institute of Geographic Sciences and Natural Resources Research, CAS, Beijing 100101, China; 2 Beijing Supermap GIS Technologies Company, Beijing 100101, China);Study on Spatial Data Cache Technology Based on Oracle Spatial[J];Geo-Information Science;2007-03
5 XIONG Hua , JIANG Wu-han , ZHANG Chang-geng , HE Jian-hua(School of Resource and Environment Science, Wuhan University, Wuhan, 430079,Hubei Province, China);A Discussion on Key Technologies of Land Consolidation Plan and Auxiliary Design System[J];Management Geological Science and Technology;2003-05
6 LIANG Rui-cai~(1,2),ZHENG Yan-peng~(1,2),ZHOU Wen-sheng~(3),SU Tian-yun~(1,2),WANG Yong~(1,2),ZHANG Zheng-min~(1,2)(1.First Institute of Oceanography,SOA,Qingdao,266061,China;2.Key lab of Marine Sedimentology andEnvironmental Geology,SOA,Qingdao 266061,China;3.Tsinghua University,Beijing 100084,China);Planning and Design of Geographic Information System(GIS) for the Bohai Oil Field Demonstration Area[J];Advances in Marine Science;2006-02
7 CHENG Yan-ni1,ZHAO Yuan2,(1 Beijing Forestry University,Beijing 100083,China;2 The Monitoring Center of the Soil and Water Conservation,the Ministry of Water Resource,Beijing 100053,China);The spatial data management methods for soil and water conservation monitoring based on the oracle spatial[J];Hebei Journal of Forestry and Orchard Research;2007-03
8 LU Wei,ZHOU Cheng-zu,CHEN Xu-dong (Software School,Beijing Jiaotong University,Beijing 100044,China);Application of Java-based GIS in the Telecom Network Management System[J];Aeronautical Computing Technique;2007-03
9 She Jiang-Feng, Feng Xue-Zhi, Du Jin-Kang(GIS and Remote Sensing Laboratory, Nanjing University, Nanjing, 210093, China);A Review on Progress in Spatiotemporal Data Modeling[J];Journal of Nanjing University (Natural Sciences);2005-03
【Citations】
Chinese Journal Full-text Database 3 Hits
1 Yuan Yanbin 1,2 Wu Chonglong 2 Li Weizhong 2 (1.Department of Hydraulic & Water-power & Automation Engineering, Huazhong University of Science and Technology, Wuhan430074, China; 2.Faculty of Earth Resources, China University of Geosciences, Wuh;OBJECT STYLES OF SPATIAL ENTITY FOR FIELD GEOLOGICAL MAPPING BASED ON OBJECT-ORIENTED METHOD[J];;2001-02
2 Zhang Xialin Wang Xinqing Wu Chonglong (Faculty of Earth Resources, China University of Geoscience, Wuhan430074, China);DYNAMIC DATA MODEL APPLIED IN REGIONAL GEOLOGICAL MAPPING COMPUTER-AIDED MAPPING SYSTEM[J];;2001-02
3 Li Chaoling, Zhang Kexin (Faculty of Earth Sciences, China University of Geosciences, Wuhan430074, China);STUDY ON REGIONAL MULTI-SOURCE GEOLOGICAL SPATIAL INFORMATION SYSTEM BASED ON TECHNIQUES OF GIS[J];;2001-05
【Co-citations】
Chinese Journal Full-text Database 10 Hits
1 MA Jin-feng,WU Yan-gang,YAN Jia-yong (College of Geo-Exploration Science and Technology,Jilin University,Changchun 130026,China);Design and implementation of templates in electrical distributed circuity management GIS[J];Journal of Changchun Post and Telecommunication Institute;2004-05
2 NIU Yu-sheng,et al.(Jilin Nonferrous Metals Exploration Bureau,Changchun 130021,China);The plain micro-topography research based on 3S technology[J];Journal of Changchun Institute of Technology(Natural Sciences Edition);2008-03
3 MA Ni1 ,LI Wei-gong2, LIU Yun-li2 ,LI Fu-rong2(1. Beijing Northern Digital Intelligence Systems Technology Co. , Ltd,Beijing 100080,China;2. AVIC Institute of Geotechnical Engineering, Beijing 100098, China);The multi-source data collection techniques for the aviation enterprise's information system[J];Engineering of Surveying and Mapping;2008-03
4 YANG Zhi 1,2, GUO Fu-sheng 1,2, LIU Lin-qing 1,2(1.Geoscience Department of East China Institute of Technology, Fuzhou 344000,China; 2.Digital Land Key Lab of Jiangxi Province, Fuzhou 344000,China);Research and Realization of Danxia Landform Information System of Jiangxi Province Based on MapGIS[J];Geomatics & Spatial Information Technology;2006-01
5 ZHANG Ke-xin 1) , LI Chao-ling 2) , YU Qing-wen 2) , ZHU Yun-hai 1) , ZHANG Zhi-yong 1)2) , GE Meng-chun 1) and LIN Qi-xiang 1) 1) Faculty of Earth Sciences, State Key Laboratory of Geological Processes and Mineral Resources, China University of Geosciences, Wuhan,430074; 2) China Geological Survey Bureau,Beijing,100083;THE DIGITAL SECTION SYSTEM OF DIGITAL MAPPING TECHNIQUES[J];Journal of Stratigraphy;2007-02
6 XU Lei,WU Li-xin,CHE De-fu,LV Xiao-jian,GUO Meng Institute of RS/GPS/GIS & Subsidence Engineering, China University of Mining and Technology, Beijing 100083; Center for RS/GPS/CIS & Digital Mine Research , Northeast University, Shenyang 110004; Beijing Geological & Mineral Exploration and Development Institute, Beijing 100050, China;The Connotation and Features of Urban Spatial Data for Data Integration[J];Geography and Geo-Information Science;2005-06
7 LI Men-lou, HU Cheng, CHEN Zhi-hua (Engineering Faculty, China University of Geoscience, Wuhan430074, China);Establishment of Decision-Making Support System for Groundwater Management of Hebei Plain[J];;2002-02
8 WU Xin cai, CAO Zhi yue (Faculty of Information Engineering, China University of Geosciences, Wuhan430074, China);Basic Conception, Function and Implementation of Temporal GIS[J];;2002-03
9 LIU Xiu guo 1, HUA Wei hua 2 (1.Faculty of Information Engineering, China University of Geosciences, Wuhan430074, China; 2.The Graduate School, China University of Geosciences, Wuhan430074, China)$$$$;Analysis of GeoTag Fields in GeoTiff[J];;2002-03
10 ZENG Wen, FAN Wen you (Faculty of Information Engineering, China University of Geosciences, Wuhan430074, China);Design of MAPGIS Pipeline Management Development Platform[J];;2002-03
【Co-references】
Chinese Journal Full-text Database 10 Hits
1 JIA Guo-xian,LIU Xin-jiang,CHEN Qin-qin(Army 61365, Tianjin 300140, China);Simple Method of Protracting Isoline in MapX[J];Beijing Surveying and Mapping;2004-02
2 MAO Shanjun (Institute of Remote Sensing & GIS of Peking University,Beijing,China,100871);Gray Geographical Information System—the Theory and Technology of Correct Geological Spatial Data Dynamically[J];Acta Scicentiarum Naturalum Universitis Pekinesis;2002-04
3 ZHANG Li-fen,WANG Xiao-hua,HU Jing-song,SONG Wei-jia,LONG Bin (Department of Computer Science and Engineering, School of Information Science and Technology, Beijing Institute of Technology, Beijing100081, China);Spatial Indices Based on Grid Partition[J];Journal of Beijing Institute of Technology;2004-02
4 WU Jian 1, \ NIU Wen qi 2 (1 College of Information Engineering, Beijing Technology and Business University, Beijing 100037, China; 2 Jiangshu Institute of Architectural Material Research, Nanjing 210000, China);RESEARCH AND CONSTRUCTION OF ACCESSING DATABASE MIDDLEWARE[J];JOURNAL OF BEIJING INSTITUTE OF LIGHT INDUSRY;2000-02
5 XIA Ying (College of Computer Science and Technology, CUPT, Chongqing 400065, China);Concurrency Control Scheme of Index Structure for Multi-Dimensional Spatial Data[J];Journal of Chongqing University of Posts and Telecommunications;2002-01
6 YANG Chang\|bao,WANG Kai\|yi,MA Sheng\|zhong (College of Geo\|Exploration Science and Technology of Jilin University,Changchun 130026,China);Implementation of an optimized algorithms in the shortest path analysis[J];Journal of Changchun Post and Telecommunication Institute;2002-02
7 Zhao Junsan Zhao Yaolong (Kunming University of Science and Technology, Kunming, 650093);Research on Trends and Application Prospects of GIS[J];ENGINEERING OF SURVEYING AND MAPPING;2000-02
8 WU Jing-qin (East China Bureau of Geology, CNNC, Nanchang 330046, China);Problems in Current GIS and RS Data Intergration[J];Engineering of Surveying and Mapping;2001-01
9 LUAN Shao-peng,ZHU Chang-qing(Institute of Surveying and Mapping,Information Engineering University,Zhengzhou 450052,China);A new mode of WebGIS development based on Ajax[J];Engineering of Surveying and Mapping;2006-06
10 GONG Jian ya (National Lab for Information Engineering in Surveying, Mapping and Remote Sensing,Wuhan University,Wuhan 430079, China);Concepts and Development of Spatial Database Management System[J];Developments In Surveying and Mapping;2001-03
【Secondary References】
Chinese Journal Full-text Database 10 Hits
1 XIE Jiong1,LIU Ren-yi2,LIU Nan2,LU Li-zhen2(1.State Key Laboratory of Resources and Environment Information System,Chinese Academy of Sciences,Beijing 100101,China;2.Zhejiang Provincial Keylab of GIS,Zhejiang University,Hangzhou 310028,China);A Spatio-temporal Process Trapezoid Multi-level Description Framework and Its Modeling Case[J];Acta Geodaetica et Cartographica Sinica;2007-03
2 PENG Xia,FANG Yu,HUANG Zhou,YIN Shuang-shi,CHEN Bin(Institute of RS & GIS,Peking University,Beijing 100871,China);Research on Spatio-Temporal Data Management Based on Object Relational Database[J];Geography and Geo-Information Science;2006-05
3 CHEN Xinbao1,2, LI Songnian1, ZHU Jianjun2, CHEN Jianqun2 (1. Dept. of Civil Engineering, Ryerson University, Toronto, Canada;2. School of Info-physical and Geometrics Engineering, Central South University, Changsha 410083, China);Spatiotemporal Data Models and Their Extensions: A Review[J];Progress in Geography;2009-01
4 HUANG Menglong1,2,HU Peng1,XIA Lanfang1 (1.Schoole of Resource and Environment Science, Wuhan University, Wuhan, 430079, China; 2.Geomatics Center of Fujian Province, Fuzhou 350003, China);Establishment of Fujian Fundamental Geographic Information Database Based on Oracle and Geodatabase[J];Geospatial Information;2008-01
5 ZHOU Mei1,YANG Kai2,TAN Shun-ping3(1.College of Forestry,Guangxi University,Nanning 530004,China;2.School of Communication and Transportation of Southeast University,Nanjing 210018,China;3.Guangxi University of Finance and Economics,Nanning 530003,China);Discussion on methods of GIS database based in ArcSDE and Oracle[J];Journal of Guangxi University(Natural Science Edition);2007-04
6 MA Wen-qiao,LU Shou-yi,SUN Mei-juan,YE Jing-song(Beijing Forestry University,Beijing 100083,China);Discussion on the method of data updating in forest resources inventory management system[J];Hebei Journal of Forestry and Orchard Research;2006-04
7 LI Yu-lan (Hunan Commercial Techonology College,Zhuzhou 412000,Hunan);About the Study of the Spatio-temporal Data Models[J];Journal of Hunan Industry Polytechnic;2007-01
8 Chen Yanjun;Research and Application of Spatio-temporal Model on the Naval Battlefield[J];Ship Electronic Engineering;2007-03
9 CUI Lun-hui1,ZHANG Wan-chang2,3,XU Shi-jin2(1.International Institute for Earth System Science,Nanjing University,Nanjing 210093;2.Dept.of Earth Science,Nanjing University,Nanjing 210093;3.Key Lab of Climate & Environment in East-Asia Region,Institute of Atmospheric Physics,Chinese Academy of Sciences,Beijing 100029);Design and Implementation of Geographic Information System for Jiangsu Oilfield[J];Computer Engineering;2008-20
10 MA Wen-qiao,LU Shou-yi,SU Mei-juan,YE Jing-song(Beijing Forestry University,Beijing 100083,China);Discussion on the method of data update in forest resources inventory management system[J];Agriculture Network Information;2006-09
【Secondary Citations】
Chinese Journal Full-text Database 5 Hits
1 Wang Xinqing ;Liu Gang; Yuan Yanbin; Han Zhijun(Institute of Geology and Mineral Resource Information Sytem,China University of Geosciences, Wuhan 430074);APPLICATION OF "THE TERMINOLOGY CLASSIFICATION CODES OF GEOLOGY AND MINERAL RESOURCES" ON GEOLOGICAL AND MINERAL RESOURCES POINT-SOURCE INFORMATION SYSTEM[J];;1999-05
2 Wu Chonglong (Institute of Geology and Mineral Resources Information System, China University of Geosciences, Wuhan430074);DEVELOPMENT AND APPLICATIONS OF GEOLOGICAL AND MINERAL RESOURCES POINT-SOURCE INFORMATION SYSTEM (GMPIS)[J];;1998-02
3 Wang Xinqing Liu Gang Han Zhijun Yuan Yanbin (Institute of Geology and Mineral Resources Information System, China University of Geosciences, Wuhan430074);THE CASE MODEL BASE AND ITS CLASSIFICATION SYSTEM OF GEOLOGICAL AND MINERAL POINT-SOURCE DATABASE SYSTEM[J];;1998-02
4 YUAN Yanbin, HAN Zhijun, LIU Gang, WANG Xinqing (Faculty of Earth Resources, China University of Geosciences, Wuhan 430074,China);THE FIELD SPATIAL DATA RAPID COLLECTION TECHNOLOGY IN 1∶50 000 REGIONAL GEOLOGICAL SURVEY BASED ON GIS[J];ADVANCE IN EARTH SCIENCES;2000-03
5 Li Yuwei(Ministry of Geology and Mineral Resources, Beijing, 100812);DEVELOPMENT OF SPATIAL INFORMATION TECHNOLOGY AND ITS APPLICATIONS IN GEOSCIENCES[J];EARTH SCIENCE FRONTIERS;1998-02
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved