多船分布式海洋综合导航系统数据库设计与实现  

Design and implementation of database for multi vessel distributed marine integrated navigation system

作　　者：方守川[1] 曹国发[1] 张瑞天[1] 韩华[1] 吴文俊 FANG Shouchuan;CAO Guofa;ZHANG Ruitian;HAN Hua;WU Wenjun

机构地区：[1]中国石油集团东方地球物理勘探有限责任公司装备服务中心,河北涿州072751

出　　处：《物探装备》2024年第4期215-219,共5页Equipment for Geophysical Prospecting

摘　　要：本文分析了以往的国内外海底地震勘探综合导航系统所采用的数据管理系统在后续开发和产品应用推广过程中存在软件授权成本比较高、平台开放性差等缺陷。从系统架构、安全性、数据存储过程及事务支持、数据访问稳定性及性能、SQL合规性、ACID合规性、数据同步方式、支持的数据类型等八个方面进行分析选型,提出了多船分布式海洋综合导航系统数据库的新设计方案,形成了一套基于PostgreSQL的综合导航系统数据库。经验证测试表明:数据库的访问能力能够应对分布式、多船海洋地震勘探施工组织、以满足复杂且具有挑战性的多船施工项目的需求。This paper analyzes the shortcomings of data management systems used in previous domestic and fo-reign integrated navigation systems in ocean bottom seismic exploration,such as high software licensing costs and poor platform openness,in the subsequent development and product application promotion process.A new design scheme for a multi vessel distributed navigation system database was proposed through analysis and selection from eight aspects,such as system architecture,security,data storage procedures and transaction support,data access stability and performance,SQL compliance,ACID compliance,data synchronization methods,and supported data types.A comprehensive navigation system database based on PostgreSQL was formed.Verified tests have shown that the database's access capability can cope with distributedconstruction organizations of multi vessel marine seismic exploration,to meet the needs of complex and challenging multi vesseloperation projects.

关 键 词：海底地震勘探 综合导航 多船 分布式 数据库 

分 类 号：P631[天文地球—地质矿产勘探]