基于三次设计理论的质量优化设计系统研究
|
摘要
三次设计理论是日本著名学者田口玄一博士于本世纪70年代创立的一种优化设计方法,其基本思想是用正交试验表安排试验方案,用误差因素模拟各种干扰,以信噪比作为衡量产品质量特性的稳定性指标,从而设计出质量上乘,成本低廉,性能稳定可靠的产品。
但是三次设计理论在应用过程中存在设计流程复杂、统计分析数据多、计算量大,对设计人员本身数学能力要求较高等不足,在一定程度上,影响了理论的推广和应用。
本文针对这些不足,利用可视化编程技术与数据库技术相结合,开发出了基于三次设计理论的质量优化设计系统。该系统以三次设计理论为基础,按功能进行模块化的构建,在一定程度上,实现了设计过程的可视化、数据管理的标准化和计算分析的自动化。同时,根据系统导航提示,可以有效地辅助使用者完成整个设计工作,使设计人员从繁杂的设计流程和计算中解放出来,更好地专注于对产品设计细节的考虑。
在系统的开发中,采用了MATLAB与VB的混合编程技术,利用调用MATLAB的DLL文件实现了混合编程,大大提高了系统方程解算能力。此外,对系统模型通用计算进行了研究,利用Microsoft(R) Script Control技术,在一定程度上实现了数学模型的输入和计算。作者利用数据库技术解决了参数设计的内、外表直积法正交试验、设计方案优选等问题。同时,通过数据库编程实现了数据录入、修改、查询等管理功能,保证了数据的一致性、可靠性和准确性。作者还根据F分布计算公式,结合数值分析等相关知识,编写了F分布分位数计算程序,有效解决了数据统计分析中显著性检验的问题。
文章最后,结合气动换向装置的优化设计应用实例,介绍了系统的功能、界面、操作使用方法,验证了本系统的实用性和有效性。
The three stage design theory is established in 70's in this century by Taguchi. It is a new method of optimization design. Its basic theory is to use orthogonal arrays, Imitates various interference with the error margin factor, and measures the stability sign of the product quality characteristic by SNR. By these, it will lead designers to finish design of product which the cost is cheap, the quality is best, the function is dependable.
But the three stage design has some shortage in using,example design process complexity, statistical analysis and computation workload more heavier, the ability to design their own higher mathematics. To a certain extent, affected the development and application of the theory.
In this paper,aim to this deficiencies, make use of visual programming technology and database technology,to make the quality optimization design system based on the three stage design theory.This system is based on the three stage design theory,to construct by the functions of modular, to a certain extent, realize the visualization of design process, the standardization of data management, the automation of analysis and computation.By cue of the system,user can be effectively supported to complete design work,to make designer be liberate from complex design process and computation,and better focus on the details of product design considerations.
In this paper,use hybrid programming technology between MATLAB and VB by making use of DLL file,to greatly improve system capacity of the equation solving. Furthermore, general calculation model of the system have been studied,make use of Microsoft(R) Script Control technology to realize mathematical model of input and calculation. Author make use of database technology solve some problem,example the orthogonal design of two table acrossing,design result optimization.And by database technology realize the data management function,including the data entry,the data modification,the data query,to Ensure data consistency, reliability, accuracy. Yet expressions of F distribution and data analysis, programming programme of the F distribution median,to solve significant checkout in the Stat.analyse.
In the end, make quality optimization design of pneumatic commutator as example,to introduce function,frame,how to using. Verify the availability and reliability of the system.
但是三次设计理论在应用过程中存在设计流程复杂、统计分析数据多、计算量大,对设计人员本身数学能力要求较高等不足,在一定程度上,影响了理论的推广和应用。
本文针对这些不足,利用可视化编程技术与数据库技术相结合,开发出了基于三次设计理论的质量优化设计系统。该系统以三次设计理论为基础,按功能进行模块化的构建,在一定程度上,实现了设计过程的可视化、数据管理的标准化和计算分析的自动化。同时,根据系统导航提示,可以有效地辅助使用者完成整个设计工作,使设计人员从繁杂的设计流程和计算中解放出来,更好地专注于对产品设计细节的考虑。
在系统的开发中,采用了MATLAB与VB的混合编程技术,利用调用MATLAB的DLL文件实现了混合编程,大大提高了系统方程解算能力。此外,对系统模型通用计算进行了研究,利用Microsoft(R) Script Control技术,在一定程度上实现了数学模型的输入和计算。作者利用数据库技术解决了参数设计的内、外表直积法正交试验、设计方案优选等问题。同时,通过数据库编程实现了数据录入、修改、查询等管理功能,保证了数据的一致性、可靠性和准确性。作者还根据F分布计算公式,结合数值分析等相关知识,编写了F分布分位数计算程序,有效解决了数据统计分析中显著性检验的问题。
文章最后,结合气动换向装置的优化设计应用实例,介绍了系统的功能、界面、操作使用方法,验证了本系统的实用性和有效性。
The three stage design theory is established in 70's in this century by Taguchi. It is a new method of optimization design. Its basic theory is to use orthogonal arrays, Imitates various interference with the error margin factor, and measures the stability sign of the product quality characteristic by SNR. By these, it will lead designers to finish design of product which the cost is cheap, the quality is best, the function is dependable.
But the three stage design has some shortage in using,example design process complexity, statistical analysis and computation workload more heavier, the ability to design their own higher mathematics. To a certain extent, affected the development and application of the theory.
In this paper,aim to this deficiencies, make use of visual programming technology and database technology,to make the quality optimization design system based on the three stage design theory.This system is based on the three stage design theory,to construct by the functions of modular, to a certain extent, realize the visualization of design process, the standardization of data management, the automation of analysis and computation.By cue of the system,user can be effectively supported to complete design work,to make designer be liberate from complex design process and computation,and better focus on the details of product design considerations.
In this paper,use hybrid programming technology between MATLAB and VB by making use of DLL file,to greatly improve system capacity of the equation solving. Furthermore, general calculation model of the system have been studied,make use of Microsoft(R) Script Control technology to realize mathematical model of input and calculation. Author make use of database technology solve some problem,example the orthogonal design of two table acrossing,design result optimization.And by database technology realize the data management function,including the data entry,the data modification,the data query,to Ensure data consistency, reliability, accuracy. Yet expressions of F distribution and data analysis, programming programme of the F distribution median,to solve significant checkout in the Stat.analyse.
In the end, make quality optimization design of pneumatic commutator as example,to introduce function,frame,how to using. Verify the availability and reliability of the system.
引文
1.张建方.技术创新、质量改进与正交优化设计[J],国际技术经济研究,1999,2(2)：35-39.
2.GBox.Signal-to-Noise.Ration,Performance,Criteria,and,Transformations[J].Technom-e trics,1998,30(1):1-18
3.G.Box, Fung. Studiesin Quality Improvement:M inimizingTransmited Variation by Parameter Design[J],Report NO.8 of Center for Quality Improvement,1986:23-25.
4.Li.Chen. A Coordination-Based Approach to Robust Product Design[J],Proceedings of the 1999 ASME Design Engineering Technical Conference,1999:127-128.
5.Xiaoping Du,Wei Chen. Towards a Beter Understanding of Modeling Feasibility Robustness in Engineering Design[J] Journal of Mechanical Design,2000,(12):385-393.
6.D.L.Thurston. Optimization of Design Utility [J], Journal of Mechanical Design,1994,116:801-807.
7.Kai Yang,Guan in Yang. Robust Reliability Design Using Environmental Stress Testing[J],Quality and reliability engineering international,1998:409-416.
8.Gabriel Hernandez.Robust Design of Families of Products with Production Modeling and Evaluation[J],journal of Mechancal Design,2001,123:183-190.
9.张公绪.新编质量管理学[M],北京：高等教育出版社,1998.
10.李瑞.质量管理和质量保证国家标准实施指南[M],北京：中国标准出版社,1995.
11.J.M.Juran,F.M.Gryna. of Quality Planning and Analysis[M],New York:2nd Ed,McGraw-Hill,1987.
12.U.Pighini. Design for Properly,Design for Quality[J],Seminar on Design Science.Prague,1991,Dec.4.
13.U.pighini. Engineering Design:Core of Total Quality[M],Zurich:Proceedings of ICED91,1991.
14.韩新民.主观质量及质价关系研究[M],西安：陕西科技出版社,1998.
15.韩俊先.线内质量管理应用初探[J],广东化纤,1994,(9)：38-40.
16.张公绪、孙静.现代质量控制与诊断工程[M],北京：经济科学出版社,1999.
17.朱祖平.面向可持续发展的企业技术创新与管理[J],中外科技政策与管理, 1997(8)：13-14.
18.韩之俊、李昭阳.试论田口参数设计与试验设计的区别[J],中国质量,2000,(1)：36-37.
19.吴育华、杜纲.管理科学基础[M],天津：天津大学出版社,2000.
20.张公绪、孙静.现代质量控制与诊断工程[M],北京：经济科学出版社,1999.
21.吉晓民.面向用户的产品质量设计与热气机[D],西安理工大学,2000.
22.田口玄一.开发、设计阶段的质量工程学[M],北京：兵器工业出版社,1990.
23.韩之俊.质量工程学——线内、线外质量管理[M],南京：华东工学院,1988.
24.田口玄一.质量工程学概论[M],北京：中国对外翻译出版公司,1985.
25.韩之俊.质量管理[M],北京：科学出版社,2003.
26.韩之俊.三次设计[M],北京：机械工业出版社,1992.
27.邵家骏.质量工程与健壮设计简介[M],北京：国防科工委质量与可靠性研究中心,1991.
28.谢贤士等.考虑质量分布的容差设计准则修正[J],机械设计,2007,24(9)：26-28.
29.盛骤、谢式千等.概率论与数理统计[M],北京：高等教育出版社,2003.
30.李泳鲜.三次设计中望目特性的讨论和改进[J],机械设计,2001,(1)：10-12.
31.姬振豫.正交设计[M],天津：天津科技翻译出版公司,1994.
32.钟晓芳、韩之俊.信噪比望大特性[J],南京理工大学学报,2004,28(2)：109-112.
33.杨大地.实用数值分析[M],重庆：重庆大学出版社,2000.
34.李鸿吉.Visual Basic 6.0数理统计实用算法,北京：科学出版社,2003.
35.何光渝.VB常用算法大全[M],西安：西安电子科技大学出版社,2007.
36.杜克胜.水文频率计算程序的编制[J],水资源研究,2004,25(1)：5-6
37.GB 4086.4统计分布数值表F分布[M],北京：标准出版社,1983.
38.卢秋蓝.VB与MATLAB混合编程研究[J],计算机仿真,2004,20(12)：115-117.
39.王家文等.MATLAB 7.0编程基础[M],北京：机械工业出版社,2005.
40.董维国.深入浅出MATLAB 7.X混合编程[M],北京：机械工业出版社,2006.
41.冯莉等.VB与MATLAB混合编程方法[J],兵工自动化,2005,24(5)：110-112.
42.雷长海等.基于ActiveX技术实现Visual Basic对MATLAB调用的方法研究[J],医疗卫生装备,2007,28(11)：75-76.
43.王雅静.VB调用MATLAB的编程技术与干涉图像处理系统[J],微计算机信息,2007,23(26)：105-106,176.
44.孟庆国.基于三次设计和模糊理论的机械稳健设计[J],机械设计与制造,2000,(4)：47-49.
45.MSDN Library[M], http://www.msn.com.cn/,2000.
46.李敏业等.Visual Basic+Access数据库应用实例完全解析[M],北京：人民邮电出版社,2006.
47.谭浩强.Visual Basic语言简明教程[M],北京：电子工业出版社,1998.
48.姚魏.Visual Basic数据库开发从入门到精通[M],北京：人民邮电出版社,2006.
49.牛占文等.实现产品创新的关键技术——计算机辅助创新设计[J],机械工程学报,2000,(1)：1-4
50.陈少威等.产品需求分析中需求方法的映射研究和实现[J],计算机辅助工程,2002,6(2)：25-26.
51.周济、王群等.机械设计专家系统概论[M],武汉：华中理工大学出版社,1998.
2.GBox.Signal-to-Noise.Ration,Performance,Criteria,and,Transformations[J].Technom-e trics,1998,30(1):1-18
3.G.Box, Fung. Studiesin Quality Improvement:M inimizingTransmited Variation by Parameter Design[J],Report NO.8 of Center for Quality Improvement,1986:23-25.
4.Li.Chen. A Coordination-Based Approach to Robust Product Design[J],Proceedings of the 1999 ASME Design Engineering Technical Conference,1999:127-128.
5.Xiaoping Du,Wei Chen. Towards a Beter Understanding of Modeling Feasibility Robustness in Engineering Design[J] Journal of Mechanical Design,2000,(12):385-393.
6.D.L.Thurston. Optimization of Design Utility [J], Journal of Mechanical Design,1994,116:801-807.
7.Kai Yang,Guan in Yang. Robust Reliability Design Using Environmental Stress Testing[J],Quality and reliability engineering international,1998:409-416.
8.Gabriel Hernandez.Robust Design of Families of Products with Production Modeling and Evaluation[J],journal of Mechancal Design,2001,123:183-190.
9.张公绪.新编质量管理学[M],北京：高等教育出版社,1998.
10.李瑞.质量管理和质量保证国家标准实施指南[M],北京：中国标准出版社,1995.
11.J.M.Juran,F.M.Gryna. of Quality Planning and Analysis[M],New York:2nd Ed,McGraw-Hill,1987.
12.U.Pighini. Design for Properly,Design for Quality[J],Seminar on Design Science.Prague,1991,Dec.4.
13.U.pighini. Engineering Design:Core of Total Quality[M],Zurich:Proceedings of ICED91,1991.
14.韩新民.主观质量及质价关系研究[M],西安：陕西科技出版社,1998.
15.韩俊先.线内质量管理应用初探[J],广东化纤,1994,(9)：38-40.
16.张公绪、孙静.现代质量控制与诊断工程[M],北京：经济科学出版社,1999.
17.朱祖平.面向可持续发展的企业技术创新与管理[J],中外科技政策与管理, 1997(8)：13-14.
18.韩之俊、李昭阳.试论田口参数设计与试验设计的区别[J],中国质量,2000,(1)：36-37.
19.吴育华、杜纲.管理科学基础[M],天津：天津大学出版社,2000.
20.张公绪、孙静.现代质量控制与诊断工程[M],北京：经济科学出版社,1999.
21.吉晓民.面向用户的产品质量设计与热气机[D],西安理工大学,2000.
22.田口玄一.开发、设计阶段的质量工程学[M],北京：兵器工业出版社,1990.
23.韩之俊.质量工程学——线内、线外质量管理[M],南京：华东工学院,1988.
24.田口玄一.质量工程学概论[M],北京：中国对外翻译出版公司,1985.
25.韩之俊.质量管理[M],北京：科学出版社,2003.
26.韩之俊.三次设计[M],北京：机械工业出版社,1992.
27.邵家骏.质量工程与健壮设计简介[M],北京：国防科工委质量与可靠性研究中心,1991.
28.谢贤士等.考虑质量分布的容差设计准则修正[J],机械设计,2007,24(9)：26-28.
29.盛骤、谢式千等.概率论与数理统计[M],北京：高等教育出版社,2003.
30.李泳鲜.三次设计中望目特性的讨论和改进[J],机械设计,2001,(1)：10-12.
31.姬振豫.正交设计[M],天津：天津科技翻译出版公司,1994.
32.钟晓芳、韩之俊.信噪比望大特性[J],南京理工大学学报,2004,28(2)：109-112.
33.杨大地.实用数值分析[M],重庆：重庆大学出版社,2000.
34.李鸿吉.Visual Basic 6.0数理统计实用算法,北京：科学出版社,2003.
35.何光渝.VB常用算法大全[M],西安：西安电子科技大学出版社,2007.
36.杜克胜.水文频率计算程序的编制[J],水资源研究,2004,25(1)：5-6
37.GB 4086.4统计分布数值表F分布[M],北京：标准出版社,1983.
38.卢秋蓝.VB与MATLAB混合编程研究[J],计算机仿真,2004,20(12)：115-117.
39.王家文等.MATLAB 7.0编程基础[M],北京：机械工业出版社,2005.
40.董维国.深入浅出MATLAB 7.X混合编程[M],北京：机械工业出版社,2006.
41.冯莉等.VB与MATLAB混合编程方法[J],兵工自动化,2005,24(5)：110-112.
42.雷长海等.基于ActiveX技术实现Visual Basic对MATLAB调用的方法研究[J],医疗卫生装备,2007,28(11)：75-76.
43.王雅静.VB调用MATLAB的编程技术与干涉图像处理系统[J],微计算机信息,2007,23(26)：105-106,176.
44.孟庆国.基于三次设计和模糊理论的机械稳健设计[J],机械设计与制造,2000,(4)：47-49.
45.MSDN Library[M], http://www.msn.com.cn/,2000.
46.李敏业等.Visual Basic+Access数据库应用实例完全解析[M],北京：人民邮电出版社,2006.
47.谭浩强.Visual Basic语言简明教程[M],北京：电子工业出版社,1998.
48.姚魏.Visual Basic数据库开发从入门到精通[M],北京：人民邮电出版社,2006.
49.牛占文等.实现产品创新的关键技术——计算机辅助创新设计[J],机械工程学报,2000,(1)：1-4
50.陈少威等.产品需求分析中需求方法的映射研究和实现[J],计算机辅助工程,2002,6(2)：25-26.
51.周济、王群等.机械设计专家系统概论[M],武汉：华中理工大学出版社,1998.