| 海洋地质调查数据库数据录入方法 |
| |
| 引用本文： | 宋怀荣, 林峰, 苏国辉, 戴勤奋, 何书锋, 孙记红. 海洋地质调查数据库数据录入方法[J]. 海洋地质前沿, 2016, 32(2): 66-70. doi: 10.16028/j.1009-2722.2016.02010 |
| |
| 作者姓名： | 宋怀荣 林峰 苏国辉 戴勤奋 何书锋 孙记红 |
| |
| 作者单位： | 中国地质调查局青岛海洋地质研究所, 青岛 266071;国土资源部海洋油气资源与环境地质重点实验室, 青岛 266071 |
| |
| 基金项目： | 中国地质调查局项目(GZH201100313) |
| |
| 摘 要： | 海洋地质调查数据库通常根据已有数据库结构标准创建各数据表和要素类,采用相关软件工具进行数据管理。基于数据的录入实践,探讨了海洋地质调查数据录入的几个关键环节:表空间和用户对应创建、表之间关联的创建、大对象数据加载等。结果表明,合理的创建用户和表空间、适当的创建数据表与公共索引表和空间站位信息表之间的关联、大对象数据采用BLOB格式存储,有助于实现高效、正确的数据录入。
|
| 关 键 词： | 海洋地质调查 数据库 数据录入 表关联 |
| 收稿时间： | 2015-10-16 |
IMPROVEMENT OF DATA ENTRY SYSTEM FOR MARINE GEOLOGICAL SURVEY DATABASE |
| |
| SONG Huairong, LIN Feng, SU Guohui, DAI Qinfen, HE Shufeng, SUN Jihong. IMPROVEMENT OF DATA ENTRY SYSTEM FOR MARINE GEOLOGICAL SURVEY DATABASE[J]. Marine Geology Frontiers, 2016, 32(2): 66-70. doi: 10.16028/j.1009-2722.2016.02010 |
| |
| Authors: | SONG Huairong LIN Feng SU Guohui DAI Qinfen HE Shufeng SUN Jihong |
| |
| Affiliation: | Qingdao Institute of Marine Geology, CGS, Qingdao 266071, China;Key Laboratory of Marine Hydrocarbon Resources and Environment Geology, Ministry of Land and Resources, Qingdao 266071, China |
| |
| Abstract: | The Marine geology survey database(MGSDB) usually manages data in the forms of tables and features created according to the MGSDB structure standards using related software. In this paper, a few key areas of MGSDB are selected for improvement, including the table space and corresponding system, the association between tables, and the large object data entry system. The results show that it would be helpful for efficient and correct data entry if a user and table space reasonably created, the appropriate relationship between data tables and public index table estabished, station location information table made available and BLOB storage used for the large object data. |
| |
| Keywords: | marine geological survey database data entry table constraints |
| 本文献已被 CNKI 等数据库收录！ |
| 点击此处可从《海洋地质前沿》浏览原始摘要信息 |
|
点击此处可从《海洋地质前沿》下载全文 |
|
