面向船舶制造的统一数据库集成平台应用研究  

Research on application of unified database integration platform to shipbuilding enterprises

作　　者：卞德志 胡昌平 杨哲[1] 王梦 单文金 宋飞飞[3] BIAN De-zhi;HU Chang-ping;YANG Zhe;WANG Meng;SHAN Wen-jin;SONG Fei-fei(Jiangsu Automation Research Institute,Lianyungang 222006,China;CSIC Information Technology Co.,Ltd,Lianyungang 222006,China;Kangda College of Nanjing Medical University,Lianyungang 222000,China)

机构地区：[1]中国船舶重工集团公司第七一六研究所,江苏连云港222006 [2]中船重工信息科技有限公司,江苏连云港222006 [3]南京医科大学康达学院,江苏连云港222000

出　　处：《舰船科学技术》2020年第7期134-138,共5页Ship Science and Technology

基　　金：工信部船舶智能制造技术集成应用研究项目(工信部联装函[2016]545号)。

摘　　要：本文研究了国内大中型船舶制造企业异构数据库的集成现状,并根据船舶制造企业异构数据库的集成需求及企业"信息孤岛"现象,设计了面向船舶制造的统一数据库集成平台。为提高异构数据库的集成效率,采用基于元数据的模式集成技术解决了数据集成中的结构差异与语义差异的问题。通过集成国内某大型船舶制造企业管件加工车间的ERP,PDM,MES,DNC,QMS,WMS,BCS等系统的数据库,实现了各异构业务数据库的快速联通,验证了该平台数据集成的有效性和先进性,为其他船舶制造企业异构数据的集成提供有效解决方案。This article studies the integration status of heterogeneous databases in large and medium-sized shipbuilding enterprises in China,and according to the integration requirement of heterogeneous databases in shipbuilding enterprises and the phenomenon of information island,the unified database integration platform is designed for shipbuilding enterprises.In order to improve the integration efficiency of heterogeneous databases,the schema integration technology based on metadata is adopted to solve the problems of structural and semantic differences in data integration.By integrating the data of ERP,PDM,MES,DNC,QMS,WMS,BCS and other databases in the domestic large shipyard pipe workshops,the rapid interconnection of heterogeneous business databases is realized.The validity and advancement of data integration of this platform are verified,which provides an effective solution for heterogeneous data integration of other shipbuilding enterprises.

关 键 词：船舶制造 异构数据库 信息孤岛 统一数据库集成平台 模式集成 

分 类 号：TP311.1[自动化与计算机技术—计算机软件与理论]