安全的船舶航行需要详细的海洋信息资料，但是由于信息多样化，数据来源不一，造成数据的存储格式也不尽相同，难以共享。本文经过数据采集、处理，利用Qt与Oracle相结合的方式建立海洋环境信息数据系统。采用电子海图基础显示平台作为基础界面，Oracle作为后台数据库，数据信息显示作为上层客户端，通过对数据库整体设计、数据表结构设计和界面可视化设计，使该数据库系统能够高效快捷为用户提供丰富的数据查询分析及数据修改功能，方便船舶航行。
Safe ship navigation requires detailed marine information.But due to the information diversification and different data sources, the data storage format is also different and hard to be shared. In this paper, through data collection and processing, Qt with Oracle combination is used to set up ocean environmental information database system. Based on electronic chart display platform as interface, Oracle as background database and data information display as the client and through database overall design, data table structure design and visual interface design to make the database system can provide users with efficient and quick data query analysis and data modification function. That can facilitate sailing.
2019,41(6): 129-132 收稿日期：2019-03-04
DOI：10.3404/j.issn.1672-7649.2019.06.027
分类号：P76
作者简介：刘波(1973-),男,讲师,专业为轮机工程与管理
参考文献：
[1] GODIVA[EB/OL]. http://www.nesc.ac.uk/action/projects/project_action.cfm?Title=81
[2] Looking[EB/OL]. 2007.http://lookingtosea.ucsd.edu
[3] Poseidon[EB/OL]. http://czms.mit.edu/poseidon/new1
[4] Sdg[EB/OL]. 2007.http://www.sdg.ac.cn
[5] 蒋文文, 秦勃, 洪峰. 海洋环境信息数据格式分析研究[J]. 微计算机信息, 2010, 26(4):174-176 JIANG Wen-wen, QIN Bo, HONG Feng. Ocean environment information data format analysis and research[J]. Microcomputer information., 2010, 26(4):174-176
[6] 谢炯, 刘仁义, 刘南, 等. 国际海洋环境资源信息采集(ARGO)及处理系统[J]. 浙江大学学报(理学版), 2005, 32(4):459-463 XIE Jiong, LIU Ren-yi, LIU nan, et al. Global marine environment observation data (ARGO) and ARGOGIS[J]. Journal of Zhejiang University (Science Edition), 2005, 32(4):459-463
[7] 王旭红, 周明全, 陈燕. 基于Oracle和Arcsde分布式空间数据库的设计与建立[J]. 西北大学学报, 2004, 34(2):151-154 WANG Xu-hong, ZHOU Ming-quan, CHEN Yan. The design of a distributed spatial database based on Oracle and Arcsde[J]. Journal of Northwest University (Natural Science Edition), 2004, 34(2):151-154
[8] 张岩. 基于Oracle的高速公路收费系统数据库设计及应用[D]. 南京:东南大学, 2005. ZHANG Yan. Design and application of highway toll system database based on Oracle[D]. Nanjing:Southeast University, 2005.
[9] 张学庆. 近岸海域环境数学模型研究及其在胶州湾的应用[D]. 青岛:中国海洋大学, 2006. ZHANG Xue-qing. Study on modeling environment of near shore area and application in Jiaozhou Bay[D]. Qingdao:Ocean University of China, 2006.
