铝合金宽幅板带材数据库的构建及基于数据的工艺优化模型研究-材料科学与工程专业毕业论文.docxVIP

重庆大 重庆大学硕士学位论文 英文摘要 PAGE PAGE IV Secondly, in accordance with the general database development process, the demand analysis, conceptual model design, logical model design and physical model design of aluminum alloy wide plates and strips were studied. Then, the relationship data table produced by the establishment of Entity-Relationship model (E-R model) are transferred into SQL Server 2005 database. Thirdly, utilizing development program of IIS +ASP+SQL 2005, the Web network database system on aluminum alloy wide plates and strips data is developed with the Dreamweaver development platform. And the functions of user management, information query, save and print, system maintenance and other functions related are finished. Finally, Significant process parameters such as alloy composition, rolling force, thickness of import and export, rolling speed, rolling temperature were utilized to build a rolling process model through BP artificial neural network method. The optimal model built exhibits predicted correlation coefficients of rolling speed and rolling temperature are up to 0.99759, 0.97873 respectively, what’s more, prediction error remained at less than 5%. Research shows that the use of artificial neural network is feasible to predict the complex manufacturing procedure of aluminum alloy wide plates and strips. Keywords：aluminum alloy wide plates and strips，database，artificial neural network， optimization model 重庆大学 重庆大学硕士学位论文 目 录 目 录 中文摘要I 英文摘要 II 1 绪论 1 1.1 铝合金宽幅板带材的研究现状及发展趋势 1 1.2 铝合金数据库的研究现状及发展趋势 5 1.3 模型研究进展 7 1.4 课题研究的目的和意义 8 1.5 课题的主要研究目标及内容 9 2 铝合金宽幅板带材数据分析 10 2.1 铝合金基本特性 10 2.1.1 化学成分 10 2.1.2 力学性能 10 2.1.3 物理性能 11 2.2 铝合金宽幅板带材生产工艺 11 2.2.1 生产线 12 2.2.2 热处理工艺 13 2.2.3 轧制工艺 13 2.3 铝合金宽幅板带材产品质量 14 2.3.1 产品信息 14 2.3.2 产品要求 14 2.3.3 产品缺陷 14 3 数据库总体结构设计 16 3.1 需求分析 17 3.2 概念模型设计 18 3.3 逻辑模型设计 20 3.4 物理模型设计 25 4 Web 数据库系统设计 26 4.1 数据库体系结构 26 4.2 系统开发工具 27 IIS 27 SQL Sever20