| Qingdao Institute of marine geology, China Geological Survey | Host |
| Citation: |
SONG Huairong, LIN Feng, WEI Helong, SU Guohui. THE TRANSPLANTATION OF MARINE GEOLOGICAL DATABASE BASED ON USER CLASSIFICATION[J]. Marine Geology Frontiers, 2018, 34(5): 67-72. doi: 10.16028/j.1009-2722.2018.05010
|
THE TRANSPLANTATION OF MARINE GEOLOGICAL DATABASE BASED ON USER CLASSIFICATION
-
Abstract
In order to strengthen the construction of the testing environment for the application of marine geological information service, a method of transplanting marine geological database based on user classification, was proposed in this paper. Combined with PL/SQL developer and ArcGIS software, marine geologic data packages are created based on users as a unit and then migrate to a new platform under the same hardware and software environment to rebuild the marine geological database under the new platform. The paper started with the data type and user classification, puts forward the route of database transplantation based on attribute data and spatial data, and then discuss the steps and key points of the transplantation of marine geological database.
-
-
References
[1] 王敏.Oracle数据库移植方案[J].中南民族大学学报:自然科学版, 2005, 24(3):71-74. doi: 10.3969/j.issn.1672-4321.2005.03.021 [2] 宋怀荣, 苏国辉, 戴勤奋, 等.海洋地质数据库数据处理流程[J].价值工程, 2014(33):218-221. doi: 10.3969/j.issn.1006-4311.2014.33.123 [3] 宋付英, 韩萌, 李媛媛.Oracle数据库移植技术探索[J].数字技术与应用, 2014(4):117-119. [4] 宋永欣.基于Oracle Spatial的MapInfo空间数据移植[J].城市勘测2008(5):55-58. [5] 于宝琴, 王太勇, 郭晓军, 等.基于Oracle的企业异构数据流整合[J].计算机工程, 2004, 30(24):47-48. doi: 10.3969/j.issn.1000-3428.2004.24.019 [6] 王敏, 吴银琴.用于软件维护的Oracle数据库移植工具[J].计算机应用与软件, 2006, 23(8):60-62. doi: 10.3969/j.issn.1000-386X.2006.08.025 -
Access History
Figures(6)
Tables(2)
Export File
Citation
SONG Huairong, LIN Feng, WEI Helong, SU Guohui. THE TRANSPLANTATION OF MARINE GEOLOGICAL DATABASE BASED ON USER CLASSIFICATION[J]. Marine Geology Frontiers, 2018, 34(5): 67-72. doi: 10.16028/j.1009-2722.2018.05010
Format
Content
DownLoad:
-
Figure 1.
The relationship diagram of ArcCatalog 10.1, Oracle 11g and PL/SQL developer
-
Figure 2.
The flow chart for Marine Geological Survey Database Transplantation
-
Figure 3.
The schematic about manually export by PL/SQL developer
-
Figure 4.
The SQL statements about setting empty table of the expansion of storage space
-
Figure 5.
The example diagram of spatial data
-
Figure 6.
The connected configuration diagram between PL/SQL developer and database