本文研究了国内大中型船舶制造企业异构数据库的集成现状，并根据船舶制造企业异构数据库的集成需求及企业“信息孤岛”现象，设计了面向船舶制造的统一数据库集成平台。为提高异构数据库的集成效率，采用基于元数据的模式集成技术解决了数据集成中的结构差异与语义差异的问题。通过集成国内某大型船舶制造企业管件加工车间的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.
2020,42(7): 134-138 收稿日期：2019-07-09
DOI：10.3404/j.issn.1672-7649.2020.07.028
分类号：TP311.1
基金项目：工信部船舶智能制造技术集成应用研究项目(工信部联装函[2016]545号)
作者简介：卞德志(1988-),男,硕士,工程师,主要从事云计算、大数据应用及工业软件技术研究
参考文献：
[1] 袁辉, 沈建荣, 黎丽, 等. 船舶企业信息化建设的现状及对策[J]. 电子技术与软件工程, 2018(19): 226
YUAN Hui, SHEN Jian-rong, LI li, GA Xiao-qiang. The current situation and Countermeasures of information construction in ship enterprises[J]. Electronic Technology & Software Engineering, 2018(19): 226
[2] 祁昌, 张祥真. 船舶制造数字化及信息化[J]. 科技创新导报, 2018, 15(22): 84-85
QI Chang, ZHANG Xiang-zhen. Digitalization and informatization of shipbuilding[J]. Science and Technology Consulting Herald, 2018, 15(22): 84-85
[3] 张祖国. 船舶行业企业信息化需求分析[J]. 舰船科学技术, 2008(5): 3-4
ZHANG Zu-guo. Analysis of the informationization requirement of shipbuilding firms[J]. Ship Science and Technology, 2008(5): 3-4
[4] 佟禺明. 基于元数据操作的船舶工业信息化业务平台数据处理研究[J]. 舰船科学技术, 2008, 30(4): 3-3
TONG Yu-ming. Research on data processing of shipbuilding industry information service platform based on metadata operation[J]. Ship Science and Technology, 2008, 30(4): 3-3
[5] 张祖国. 船舶行业企业信息化建设目前面临的问题[J]. 舰船科学技术, 2008, 30(4): 3-3
ZHANG Zu-guo. Challenges to the shipbuilding industry informationization[J]. Ship Science and Technology, 2008, 30(4): 3-3
[6] 苏翔, 宁宣熙, 潘燕华, 等. 面向造船企业的信息化一体化方案研究[J]. 中国造船, 2005(4)
SU Xiang, NI Xuan-xi, PAN Yan-hua at. al Study on unification of informationization catering to shipbuilding enterprises[J]. Shipbuilding of China, 2005(4)
[7] 谢晶. 船用云平台中的海量异构数据集成系统的设计与实现[J]. 舰船科学技术, 2016, 38(14): 178-180
XIE Jing. Design and implementation of marine massive hetergerous data integration system based on cloud platform[J]. Ship Science and Technology, 2016, 38(14): 178-180
[8] 康少伟, 蒙秋琼. 移动Agent和XML在海上异构数据集成中的应用[J]. 舰船科学技术, 2017(4): 161-163
KANG Shao-Wei, MENG Qiu-qiong. Application of mobile Agent and XML in marine heterogenrous data integration[J]. Ship Science and Technology, 2017(4): 161-163
[9] AN Y. Research of heterogeneous data integration in ship design[J]. Information Technology for Manufacturing Systems Ⅲ, 2012, 6-7: 221-225
[10] 王登怡. 数字化造船一体化数据平台关键技术研究[J]. 电子技术与软件工程, 2015(17): 208
WANG Dengyi. Research on key technologies of digital shipbuilding integrated data platform[J]. Electronic Technology & Software Engineering, 2015(17): 208
[11] 夏景. 基于工业互联网数据转化的船舶机械设备多元异构集成平台研究[J]. 船舶物资与市场, 2019(7): 34-35
XIA Jing. Research on multi heterogeneous integration platform of marine mechanical equipment based on data transformation of industrial Internet[J]. Marine Equipment/ Materials & Marketing,, 2019(7): 34-35
[12] 林晨, 周晓梅, 王敏. 智能船舶集成平台数据采集技术研究与实践[J]. 上海船舶运输科学研究所学报, 2018, 41(2): 59-64
LIN Chen, ZHOU Xiao-mei. Data acquisition design of intelligent integrated platform for smart ships[J]. Journal of Shanghai Scientific Research Institute of Shipping, 2018, 41(2): 59-64
[13] 帅晓华. 海上数据集成系统设计与研究[J]. 舰船科学技术, 2016, 38(2): 112-114
SHUAI Xiao-hua. Design and research on marine data integration system[J]. Ship Science and Technology, 2016, 38(2): 112-114
[14] 张雪洁. 基于XML的数据集成平台框架及关键技术研究[D]. 天津: 河海大学, 2004.
ZHANG Xu-jie. Research on Key Technology of XML-based Data Integration Platform[D]. Tianjin:Hohai University, 2004.
