面向产品设计制造过程的中间集成平台研究及应用
|
摘要
随着企业信息化建设的不断深入,各个应用系统之间的信息共享与协同工作问题越来越受到重视。企业应用系统本身强大的功能已经不能满足日益发展的需要,而应用系统间的数据、功能和流程集成的需求越来越迫切。传统的异构系统间的集成模式存在集成功能单一、非架构化、可扩展性差等缺点,难以满足新的集成需求。中间集成平台弥补以上缺点,能够解决企业不同层次集成问题。
木文分析了中间集成平台在国内外的发展历程和现状,包括相关技术和产品的概况,得出现有企业应用集成所而临的主要问题。根据对这些问题分析,文章提出了面向产品设计制造过程的应用系统集成需求。在这些需求的指引下,文章通过分析研究异构系统数据集成层次、数据结构、体系架构和功能模块,提出了一套基于XML数据总线型的中间集成平台解决方案。该平台是基于XML数据总线的三层体系架构,通过关系型数据与XML数据互相转换,嵌入式适配器和数据库访问等关键技术,实现CAX/PDM/ERP系统集成数据交换。中间集成平台基于模块化设计,使得具有较好的可维护性和可扩展性。
为了对以上研究的验证,作者深入制造业企业需求调研,深入分析面向产品设计制造过程的应用系统集成数据内容、数据结构、体系架构和功能模块,运用数据集成关键实现技术,开发了基于XML数据总线CAX/PDM/ERP系统的迈特中间集成平台(MIT-MIP)原型系统。最后,作者以AutoCAD/MITPDM和UG/MITPDM数据集成为例,描述了数据集成的整个过程,再次验证本文提出的中间集成平台系统框架和实现策略的可行性。
As enterprise's informatization process stepping further, more attention has been paid to the problem of sharing information between various application systems. Most of enterprise application systems are functionally strong, but their functions have not been adapted to ever-developing business needs. However, application integration covering data integration, functionality integration and workflow becomes more and more urgent. Traditional end-to-end integration mode is not qualified for fulfilling these new requirements since it has many limitations, such as functionality singularity, non-framework infrastructure and weak expansibility. Middle integration platform (MIP) technique makes up above defects and solves different enterprise integration problems.
By analyzing the development course and general state of MIP including the related technology and products at home and abroad, this thesis encloses some primary problems that MIP faces currently. After analyzing and describing these problems, this thesis proposes a viewpoint of overall integration needs of MIP in product design and manufacturing process. Under the lead of these needs, this thesis researches into integration layer, data structure, system architecture and function model of different application systems, and then presents a solution of MIP based on XML data bus. MIP is based on three-layer framework. It makes use of some primary technology including data conversion between relational schema and XML schema, embedded adapter, data base access to exchange integration data among CAX, PDM and ERP. MIP based on the modularized design possesses better maintainability and expansibility。
In order to verify the research described above,the author collects integration needs from many enterprises in manufacturing, and analyzes integration data, data structure, system architecture and function model of different application systems in product design and manufacturing process. Then the author uses some primary technology to develop MIT-middle integration platform system (MIT-MIP) based on XML data bus among CAX, PDM and ERP. At last, the author uses AutoCAD/MITPDM data integration and UG/MITPDM data integration to describe data integration process, which verifies the feasibility of the systematic framework and realization tactics presented before.
木文分析了中间集成平台在国内外的发展历程和现状,包括相关技术和产品的概况,得出现有企业应用集成所而临的主要问题。根据对这些问题分析,文章提出了面向产品设计制造过程的应用系统集成需求。在这些需求的指引下,文章通过分析研究异构系统数据集成层次、数据结构、体系架构和功能模块,提出了一套基于XML数据总线型的中间集成平台解决方案。该平台是基于XML数据总线的三层体系架构,通过关系型数据与XML数据互相转换,嵌入式适配器和数据库访问等关键技术,实现CAX/PDM/ERP系统集成数据交换。中间集成平台基于模块化设计,使得具有较好的可维护性和可扩展性。
为了对以上研究的验证,作者深入制造业企业需求调研,深入分析面向产品设计制造过程的应用系统集成数据内容、数据结构、体系架构和功能模块,运用数据集成关键实现技术,开发了基于XML数据总线CAX/PDM/ERP系统的迈特中间集成平台(MIT-MIP)原型系统。最后,作者以AutoCAD/MITPDM和UG/MITPDM数据集成为例,描述了数据集成的整个过程,再次验证本文提出的中间集成平台系统框架和实现策略的可行性。
As enterprise's informatization process stepping further, more attention has been paid to the problem of sharing information between various application systems. Most of enterprise application systems are functionally strong, but their functions have not been adapted to ever-developing business needs. However, application integration covering data integration, functionality integration and workflow becomes more and more urgent. Traditional end-to-end integration mode is not qualified for fulfilling these new requirements since it has many limitations, such as functionality singularity, non-framework infrastructure and weak expansibility. Middle integration platform (MIP) technique makes up above defects and solves different enterprise integration problems.
By analyzing the development course and general state of MIP including the related technology and products at home and abroad, this thesis encloses some primary problems that MIP faces currently. After analyzing and describing these problems, this thesis proposes a viewpoint of overall integration needs of MIP in product design and manufacturing process. Under the lead of these needs, this thesis researches into integration layer, data structure, system architecture and function model of different application systems, and then presents a solution of MIP based on XML data bus. MIP is based on three-layer framework. It makes use of some primary technology including data conversion between relational schema and XML schema, embedded adapter, data base access to exchange integration data among CAX, PDM and ERP. MIP based on the modularized design possesses better maintainability and expansibility。
In order to verify the research described above,the author collects integration needs from many enterprises in manufacturing, and analyzes integration data, data structure, system architecture and function model of different application systems in product design and manufacturing process. Then the author uses some primary technology to develop MIT-middle integration platform system (MIT-MIP) based on XML data bus among CAX, PDM and ERP. At last, the author uses AutoCAD/MITPDM data integration and UG/MITPDM data integration to describe data integration process, which verifies the feasibility of the systematic framework and realization tactics presented before.
引文
[1] Takashi Kobayashi, Masato Tamaki, Norihisa Komoda. Business process integration as a solution to the implementation of supply chain management systems. Information& Management. 2003,(40): pp769-780
[2] 王弘钰,刘宇清.企业信息集成研究.情报科学.2002,(7): pp753-755
[3] 罗钢,林健.实施 EAI 一一解决信息孤岛问题.商业研究.2003,(17): pp54-56
[4] 范玉顺,李建强.制造网络集成平台技术研究.计算机集成制造系统——CIMS.2003,9(3): pp169-174
[5] 蔡斌,赵卫东,戴伟辉.面向变化管理的流程建模技术.系统工程理论方法应用.2003,12 (9): pp237-242
[6] Fan Yushun, Shi Wei, Wu Cheng. Enterprise wide application integration platform for CIMS implementation. Journal of Intelligent Manufacturing, 1999, 10 (6):pp587-601
[7] Haibin Luo, Yushun Fan. “CIMFlow: A Workflow Management System Based on Integration Platform Environment”, 7th IEEE International Conference on Emerging Technologies and Factory Automation. 1999. pp233-241
[8] Microsoft. 企业应用集成服务平台白皮书. http://www.microsoft.com/china/technet/ prodtechnol/biztalk/roadshow /Product/a7.asp
[9] BEA. BEA WebLogic Enterprise Platform 技术解决方案.http://www.bea.com.cn/solutions/ techsolu/beawebenterplat/index.jsp
[10] 麒麟远创.麒麟远创 BusinessWare 集成平台解决方案.http://www.qilinsoft.com.cn /indexleb.asp? CategoryID=24&CategoryID2=56
[11] 谢铱洋,谢容传.基于 XML 的企业应用集成体系结构.计算机应用.2002,(05):pp25-27
[12] Ben Chang.Oracle XML 开发手册.机械工业出版社.2001 年第 1 版
[13] Extensible Markup Language (XML). http://www.w3.org/TR/REC-xml. W3C
[14] 金昊,李海峰,吴介一,张少博.基于 XML 的企业信息交换.计算机应用研究.2002,19(11):pp27-29
[15] Java Message Service Specification V1.1.Sun Microspstem. 2002-04-12
[16] Richard Monson-Haefel, Dawid A. Chappell. Java Message Service. 0'Roilly, 2001
[17] 蒋志强,冯锡兰.面向 Web 服务的制造企业应用集成技术.郑州航空工业管理学院学报.2002, (12):pp7-11
[18] 陈彦仓.ERP:为企业增强活力.企业活力.2003 ,(6): pp44-45
[19] Mark L Fussell. Foundations of Object Relational Mapping. http://ww.Ambysoft.com/mappingObject.pdf
[20] Anton Eliens. Principles of Object-Oriented Software Development Second Edition. China Machine Press, 2003.1
[21] Scott W Ambler. Mapping Objects To Relational Database. http://www.Ambysoft.com/ mappingObject.pdf
[22] 赵文龙.CAD 平台下装配 BOM 信息管理的研究与实践[D].重庆大学,2004:pp30-31
[23] C. W. Chung, "DATAPLEX: An access to heterogeneous distributed databases”, Comm. ACM, Vol. 33 No.1 2002
[24] Y. Breitrart et a1,”Overview of multidatabase transaction management”, VLDB J., Vol. 1 No.2 2002
[25] Ian Gorton, Dave Thurman, .Judi Thomson. Next Generation Application Integration:Challenges and New Approaches. Proceedings of the 27th Annual International Computer Software and Applications Conference. 2003
[26] Estrem, William A. An evaluation framework for deploying Web Services in the next generation manufacturing enterprise. Robotics and Computer--Integrated Manufacturing. 2003, 19 (6): pp509-519
[27] Gannodm, Gerald C. Zhu, Huimin, On-the-fly Wrapping of Web Services to Support Dynamic Integration. Mudiam, Sudhakiran V. Reverse Engineering-Working Conference Proceedings. 2003, pp175--184
[28] 范玉顺,李建强.制造网络集成平台技术研究.计算机集成制造系统——CIMS.2003, 9 (3)
[29] 严隽薇,董志斌,戴毅茹,王坚.面向 CIMS 企业的应用集成平台体系结构.同济大学学报. 2002, 30 (4)
[30] 杨海成,王海龙,敬石开.制造业信息化集成平台技术发展的认识与思考.航空制造技术.2004, (1) : pp22-25
[31] Unigraphics Essentials User Manual Version 18.0.Unigraphics Solutions Inc,1999
[32] UG/open Menuscript User Guide Version 18.0.Unigraphics Solutions Inc,1999
[33] UG/open API Reference Version 18.0.Unigraphics Solutions Inc,1999
[34] UG/open API Programmer’s Guide Version 18.0.Unigraphics Solutions Inc,1999
[35] 董正卫,田立中,付宜利.UG/open API 编程基础.北京:清华大学出版社,2002,8:205-210
[36] 叶华,张森.一种异构数据库间的 XML 接口方案.计算机应用,2001,6: pp33-37
[37] 邱俊.如何有效利用 DOM 处理 XML 文档.重庆上学院学报,2002,4: pp7-8
[38] 梁允荣,杨茜,刘艳梅.联网分布环境下异构数据库的数据转换.办公自动化国际学术研讨会暨展览会论文集,2002,10: pp56-57
[39] Tom Myers, Alexander. XML 编程指南(M)北京:电子上业出版社,2001,1:233-314
[40] 王茂华,赵继,韩松乔,庄新妹.CIMS 环境下异构数据库互操作技术的实现.农业机械学报,2002,5: pp43-47
[41] 王亮,高阳,陈世福,陈震解.基于 SQL 的 XML 到关系数据库的转换方法.计算机应用研究,2002(2): pp70-72
[42] 杜宾,王明文.跨平台数据迁移的研究和实现.计算机与现代化,2001(6): pp5-10
[43] L. Ling, P.Colton, H. Wei. An XML-enabled data extraction toollat for web sources Information System, 2001, 26: pp563-583
[44] A. Deutsch, M. Fernandez, D. Florescu, et al. A query language for XML. Computer Networks, 1999, 31: pp1155-1169
[45] E. Bertino, B. Catania. Integrating XML and Databases. IEEE Internet Computing, 2001, 6: pp84-88
[46] 黄俊,许满武,陆剑锋.中间件 XML 及其在物资运输调配系统中的应用.微型计算机,1997,4:17
[47] 吴婉莲.基于 XML 的异构数据库集成技术研究[D].华东师范大学,2005:pp30-50
[48] 姚国祥,毛涛,沈镇林.基于 www 的 Browser/Server 结构的信息系统研究与实现.计算机科学,1998,21:33
[49] 翁莉,宋翰涛.ODBC 连接异构数据库.计算机世界,1998,13: pp48-50
[50] William Stalling. Operating System Internals and Design Principles[M]. Prentice-Ha11 International, Inc, 1998
[51] W Richard Stevens. TCP/IP 译解.北京:机械工业出版社,2002:56-130
[52] Martin Rohnneier. WEB BASED ROBOT SIMULATION USING VRML. Proceedings of the 2000 Winter Simulation Conference. 2000: pp1525-1528
[53] William A. Ruh Francis X. Maginnis. Enterprise Application Integration. John Wiley & Sons, Inc.2003-4
[2] 王弘钰,刘宇清.企业信息集成研究.情报科学.2002,(7): pp753-755
[3] 罗钢,林健.实施 EAI 一一解决信息孤岛问题.商业研究.2003,(17): pp54-56
[4] 范玉顺,李建强.制造网络集成平台技术研究.计算机集成制造系统——CIMS.2003,9(3): pp169-174
[5] 蔡斌,赵卫东,戴伟辉.面向变化管理的流程建模技术.系统工程理论方法应用.2003,12 (9): pp237-242
[6] Fan Yushun, Shi Wei, Wu Cheng. Enterprise wide application integration platform for CIMS implementation. Journal of Intelligent Manufacturing, 1999, 10 (6):pp587-601
[7] Haibin Luo, Yushun Fan. “CIMFlow: A Workflow Management System Based on Integration Platform Environment”, 7th IEEE International Conference on Emerging Technologies and Factory Automation. 1999. pp233-241
[8] Microsoft. 企业应用集成服务平台白皮书. http://www.microsoft.com/china/technet/ prodtechnol/biztalk/roadshow /Product/a7.asp
[9] BEA. BEA WebLogic Enterprise Platform 技术解决方案.http://www.bea.com.cn/solutions/ techsolu/beawebenterplat/index.jsp
[10] 麒麟远创.麒麟远创 BusinessWare 集成平台解决方案.http://www.qilinsoft.com.cn /indexleb.asp? CategoryID=24&CategoryID2=56
[11] 谢铱洋,谢容传.基于 XML 的企业应用集成体系结构.计算机应用.2002,(05):pp25-27
[12] Ben Chang.Oracle XML 开发手册.机械工业出版社.2001 年第 1 版
[13] Extensible Markup Language (XML). http://www.w3.org/TR/REC-xml. W3C
[14] 金昊,李海峰,吴介一,张少博.基于 XML 的企业信息交换.计算机应用研究.2002,19(11):pp27-29
[15] Java Message Service Specification V1.1.Sun Microspstem. 2002-04-12
[16] Richard Monson-Haefel, Dawid A. Chappell. Java Message Service. 0'Roilly, 2001
[17] 蒋志强,冯锡兰.面向 Web 服务的制造企业应用集成技术.郑州航空工业管理学院学报.2002, (12):pp7-11
[18] 陈彦仓.ERP:为企业增强活力.企业活力.2003 ,(6): pp44-45
[19] Mark L Fussell. Foundations of Object Relational Mapping. http://ww.Ambysoft.com/mappingObject.pdf
[20] Anton Eliens. Principles of Object-Oriented Software Development Second Edition. China Machine Press, 2003.1
[21] Scott W Ambler. Mapping Objects To Relational Database. http://www.Ambysoft.com/ mappingObject.pdf
[22] 赵文龙.CAD 平台下装配 BOM 信息管理的研究与实践[D].重庆大学,2004:pp30-31
[23] C. W. Chung, "DATAPLEX: An access to heterogeneous distributed databases”, Comm. ACM, Vol. 33 No.1 2002
[24] Y. Breitrart et a1,”Overview of multidatabase transaction management”, VLDB J., Vol. 1 No.2 2002
[25] Ian Gorton, Dave Thurman, .Judi Thomson. Next Generation Application Integration:Challenges and New Approaches. Proceedings of the 27th Annual International Computer Software and Applications Conference. 2003
[26] Estrem, William A. An evaluation framework for deploying Web Services in the next generation manufacturing enterprise. Robotics and Computer--Integrated Manufacturing. 2003, 19 (6): pp509-519
[27] Gannodm, Gerald C. Zhu, Huimin, On-the-fly Wrapping of Web Services to Support Dynamic Integration. Mudiam, Sudhakiran V. Reverse Engineering-Working Conference Proceedings. 2003, pp175--184
[28] 范玉顺,李建强.制造网络集成平台技术研究.计算机集成制造系统——CIMS.2003, 9 (3)
[29] 严隽薇,董志斌,戴毅茹,王坚.面向 CIMS 企业的应用集成平台体系结构.同济大学学报. 2002, 30 (4)
[30] 杨海成,王海龙,敬石开.制造业信息化集成平台技术发展的认识与思考.航空制造技术.2004, (1) : pp22-25
[31] Unigraphics Essentials User Manual Version 18.0.Unigraphics Solutions Inc,1999
[32] UG/open Menuscript User Guide Version 18.0.Unigraphics Solutions Inc,1999
[33] UG/open API Reference Version 18.0.Unigraphics Solutions Inc,1999
[34] UG/open API Programmer’s Guide Version 18.0.Unigraphics Solutions Inc,1999
[35] 董正卫,田立中,付宜利.UG/open API 编程基础.北京:清华大学出版社,2002,8:205-210
[36] 叶华,张森.一种异构数据库间的 XML 接口方案.计算机应用,2001,6: pp33-37
[37] 邱俊.如何有效利用 DOM 处理 XML 文档.重庆上学院学报,2002,4: pp7-8
[38] 梁允荣,杨茜,刘艳梅.联网分布环境下异构数据库的数据转换.办公自动化国际学术研讨会暨展览会论文集,2002,10: pp56-57
[39] Tom Myers, Alexander. XML 编程指南(M)北京:电子上业出版社,2001,1:233-314
[40] 王茂华,赵继,韩松乔,庄新妹.CIMS 环境下异构数据库互操作技术的实现.农业机械学报,2002,5: pp43-47
[41] 王亮,高阳,陈世福,陈震解.基于 SQL 的 XML 到关系数据库的转换方法.计算机应用研究,2002(2): pp70-72
[42] 杜宾,王明文.跨平台数据迁移的研究和实现.计算机与现代化,2001(6): pp5-10
[43] L. Ling, P.Colton, H. Wei. An XML-enabled data extraction toollat for web sources Information System, 2001, 26: pp563-583
[44] A. Deutsch, M. Fernandez, D. Florescu, et al. A query language for XML. Computer Networks, 1999, 31: pp1155-1169
[45] E. Bertino, B. Catania. Integrating XML and Databases. IEEE Internet Computing, 2001, 6: pp84-88
[46] 黄俊,许满武,陆剑锋.中间件 XML 及其在物资运输调配系统中的应用.微型计算机,1997,4:17
[47] 吴婉莲.基于 XML 的异构数据库集成技术研究[D].华东师范大学,2005:pp30-50
[48] 姚国祥,毛涛,沈镇林.基于 www 的 Browser/Server 结构的信息系统研究与实现.计算机科学,1998,21:33
[49] 翁莉,宋翰涛.ODBC 连接异构数据库.计算机世界,1998,13: pp48-50
[50] William Stalling. Operating System Internals and Design Principles[M]. Prentice-Ha11 International, Inc, 1998
[51] W Richard Stevens. TCP/IP 译解.北京:机械工业出版社,2002:56-130
[52] Martin Rohnneier. WEB BASED ROBOT SIMULATION USING VRML. Proceedings of the 2000 Winter Simulation Conference. 2000: pp1525-1528
[53] William A. Ruh Francis X. Maginnis. Enterprise Application Integration. John Wiley & Sons, Inc.2003-4