海洋地质调查数据库数据录入方法

详细信息

收稿日期: 2015-10-16

IMPROVEMENT OF DATA ENTRY SYSTEM FOR MARINE GEOLOGICAL SURVEY DATABASE

Received Date: 16 October 2015

摘要: 海洋地质调查数据库通常根据已有数据库结构标准创建各数据表和要素类,采用相关软件工具进行数据管理。基于数据的录入实践,探讨了海洋地质调查数据录入的几个关键环节:表空间和用户对应创建、表之间关联的创建、大对象数据加载等。结果表明,合理的创建用户和表空间、适当的创建数据表与公共索引表和空间站位信息表之间的关联、大对象数据采用BLOB格式存储,有助于实现高效、正确的数据录入。
- 海洋地质调查 /
- 数据库 /
- 数据录入 /
- 表关联
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.
- marine geological survey /
- database /
- data entry /
- table constraints