基于MySQL和BP神经网络的船舶焊接专家库软件研发  

Software Development of Ship Welding Expert Database Based on MySQL and BP Neural Network

作　　者：朱若凡[1] 聂加俊 郑惠锦[1] ZHU Ruofan;NIE Jiajun;ZHENG Huijin(Shanghai Shipbuilding Technology Research Institute,Shanghai 200032,China;Wuhu Shipyard Co.,Ltd.,Wuhu 241001,Anhui,China)

机构地区：[1]上海船舶工艺研究所,上海200032 [2]芜湖造船厂有限公司,安徽芜湖241001

出　　处：《造船技术》2021年第4期27-32,共6页

基　　金：科工局科工计[2016]1477号批文“舰船先进制造工艺技术条件建设项目”(编号:A201700081)。

摘　　要：为提高船舶焊接试验过程中的工艺实施效率,研发一种基于MySQL和反向传播(Back Propagation,BP)神经网络的船舶焊接专家库软件。该软件由专家数据库、报表生成器、热输入值预测机、人机交互界面、通信接口组成,基于MySQL开发焊接专家数据库,基于BP神经网络设计热输入值预测机,具备自动坡口图生成、自动焊接工艺规范(Welding Procedure Specification,WPS)生成、自动专家经验数据存取等自动化功能,具备智能热输入值预测等智能功能。实船焊接试验结果表明,该软件可满足实船焊接试验需求,快速存取专家经验数据,提高焊接试验过程效率。In order to improve the technology implementation efficiency during ship welding test,a software of ship welding expert database based on MySQL and Back Propagation(BP)neural network is developed.The software is composed of expert database,report form generator,heat input value predictor,human machine interface,and communication interface.The welding expert database is developed based on MySQL,and the heat input value predictor is designed based on BP neural network.The software possesses the automatic functions such as automatic groove figure generation,automatic Welding Procedure Specification(WPS)generation,and automatic expert experience data access,etc.,and possesses the intelligent heat input value prediction and other intelligent functions.The results of actual ship welding test show that the software can meet the requirements of actual ship welding test,access the expert experience data quickly,and improve the efficiency of welding test process.

关 键 词：船舶焊接 专家库 软件研发 MYSQL BP神经网络 

分 类 号：U671.83[交通运输工程—船舶及航道工程]