Design of Database Application System for Hull Structural Steel and Welding Materials
-
摘要: 为了解决结构钢及焊接材料数据的有效存储及高效利用问题,使用SQL Server作为后台数据仓库,VB作系统开发,ODBC数据源作为连接技术,设计开发了船体结构钢及焊接材料数据库应用系统。系统具有结构钢及焊接材料信息查询、标准及报告查询等四大功能模块,并以结构钢配套焊条为例,通过性能预测智慧框架和神经网络模型构建、神经网络矩阵模型转换为VB代码等工作,实现了其力学性能预测,对结构钢及焊接材料设计有一定的参考和实用价值。Abstract: In order to promote the storage validity and utilization efficiency, the database application system of hull structural steel and welding materials is designed and developed by using SQL Server as background database, VB as system development and ODBC data source as connection technology. The system has four functional modules:structural steel information query, welding material information query, standard query and report query. Structural steel welding rod has been taken as an example to test the practicability of the system. The mechanical performance prediction is realized by the construction of the intelligent framework for performance prediction and the neural network model, and the transformation of neural network matrix model into VB code. It has a certain reference and practical value for the design of structural steel and welding materials.
-
-
[1] 张豪, 雷运涛, 魏金山. 高强度船体结构钢的现状与发展[J]. 钢结构, 2004, 19(2):38-40. [2] 王卓, 王礞, 雍歧龙, 等. 材料信息学及其在材料研究中的应用[J]. 中国材料进展, 2017, 36(2):132-140. [3] 杨丽, 苏航, 柴锋, 等. 材料数据库和数据挖掘技术的应用现状[J]. 中国材料进展, 2019, 38(7):672-681. [4] 何冰, 米鹏辉, 张力文, 等. The Most Comprehensive Database of Ionic Transport Characteristics to Date[J]. 材料导报, 2020, 34(20):20001-20002. [5] 向勇, 闫宗楷, 朱焱麟, 等. 材料基因组技术前沿进展[J]. 电子科技大学学报, 2016, 45(4):634-649. [6] GU Q, ZHONG R, JU D Y. Development of materials database system for cae system of heat treatment based on data mining technology[J]. Transactions of Nonferrous Metals Society of China, 2006, 16:s572-s576.
[7] LEI T Y, PENG W P, LEI J, et al. A product mo-dule mining method for PLM database[J]. Journal of Central South University, 2016, 23(7):1754-1766.
[8] XU R, ZHAO Y H, HAN Q Z, et al. On the database-based strategy of candidate extractant generation for de-phenol process in coking wastewater treatment[J]. Chinese Journal of Chemical Engineering, 2018, 26(7):1570-1580.
[9] JIE J S, WENG M Y, LI S N, et al. A new MaterialGo database and its comparison with other high-throughput electronic structure databases for their predicted energy band gaps[J]. Science China Technological Sciences, 2019, 62(8):1423-1430.
[10] 唐辉, 齐乐华, 李贺军. 基于SQL Server的C/C复合材料实验数据库系统平台的设计开发[J]. 新型炭材料, 2007, 22(2):148-152. -
期刊类型引用(1)
1. 郭琼,滕杰,王华方,薛勇,尹蓝. 关于车灯镀铝件耐湿试验等效方法技术研究. 中国照明电器. 2025(02): 47-53 . 百度学术
其他类型引用(0)
计量
- 文章访问数: 168
- HTML全文浏览量: 19
- PDF下载量: 18
- 被引次数: 1