MES中间件的构建及其数据处理专家系统
|
摘要
随着中国加入WTO后市场的逐步开发以及经济全球化的不断深入,企业面临着巨大的竞争压力。为了提高生产管理水平,增强竞争力,企业信息化已是大势所趋,而构建企业的制造执行系统(Manufacturing Execution System,MES)则是企业信息化的重要步骤。
制造执行系统是现代信息技术在生产管理中应用的体现,是位于上层的计划管理系统和底层的工业控制之间的面向生产的管理信息系统。它通过控制包括物料、设备、人员和设施在内的所有工厂资源来提高制造竞争力,提供了一种系统的在统一平台上集成诸如质量控制、模型优化、生产调度等功能的方式。
本文以某煤化工企业的MES项目的研发和实施为背景,详细介绍了一种以中间件技术来解决实时数据库(PI)与关系数据库(SQL Server 2000)之间的数据共享问题,并以此为基础开发了数据处理与分析系统,同时构造了一种简单的专家系统在实时数据处理中加以应用,为整个MES系统提供了稳定可靠的数据支持。
As China joins WTO and opens its civil market step by step, and with the enhancing economy globalization, the enterprises are under a great competitive pressure. In order to improve the management ability and enhance the competitiveness, building enterprise information system is a main trend, while constructing manufacturing execution system is the key step.
Manufacturing execution system, which is located between the Enterprise Resource Planning (ERP) system on the upper level and the industrial control system on the bottom level, is an application of modern information technology on product management. It can enhance the competitive ability through controlling all of the resources in the enterprise, including material, equipment and people, and provide a unified platform to integrate functional modules, such as quality control, model optimization and production planning.
This thesis is based on the development and implementation of MES project for a coking & chemical enterprise. A method using middleware technology to solve data sharing problem between real-time database (PI) and relational database (SQL Server 2000) is introduced in detail, and a data processing and analysis system is developed based on it. Meanwhile, a simple expert system is also constructed to process the real-time data. The system provides steady and excellent data for the whole MES project.
制造执行系统是现代信息技术在生产管理中应用的体现,是位于上层的计划管理系统和底层的工业控制之间的面向生产的管理信息系统。它通过控制包括物料、设备、人员和设施在内的所有工厂资源来提高制造竞争力,提供了一种系统的在统一平台上集成诸如质量控制、模型优化、生产调度等功能的方式。
本文以某煤化工企业的MES项目的研发和实施为背景,详细介绍了一种以中间件技术来解决实时数据库(PI)与关系数据库(SQL Server 2000)之间的数据共享问题,并以此为基础开发了数据处理与分析系统,同时构造了一种简单的专家系统在实时数据处理中加以应用,为整个MES系统提供了稳定可靠的数据支持。
As China joins WTO and opens its civil market step by step, and with the enhancing economy globalization, the enterprises are under a great competitive pressure. In order to improve the management ability and enhance the competitiveness, building enterprise information system is a main trend, while constructing manufacturing execution system is the key step.
Manufacturing execution system, which is located between the Enterprise Resource Planning (ERP) system on the upper level and the industrial control system on the bottom level, is an application of modern information technology on product management. It can enhance the competitive ability through controlling all of the resources in the enterprise, including material, equipment and people, and provide a unified platform to integrate functional modules, such as quality control, model optimization and production planning.
This thesis is based on the development and implementation of MES project for a coking & chemical enterprise. A method using middleware technology to solve data sharing problem between real-time database (PI) and relational database (SQL Server 2000) is introduced in detail, and a data processing and analysis system is developed based on it. Meanwhile, a simple expert system is also constructed to process the real-time data. The system provides steady and excellent data for the whole MES project.
引文
[1] 罗国富,施法中.制造执行系统及其相关技术研究.机械制造,2004,4
[2] MESA International. MES functionalities &MRP to MES date flow Possibilities[R].MESA International White Paper Number 2,1997
[3] Amber Computer System Inc. Integratable MES the challenge and the opportunity advanced manufacturing research consulting [EB/0L]. http://www.amrc.com,1999.
[4] 陈庄,ERP原理与应用教程,北京,电子工业出版社,2003
[5] 汪定伟,敏捷制造的ERP及其决策优化,北京,机械工业出版社,2003
[6] 张毅,企业资源规划(ERP),北京,电子工业出版社,2001
[7] 叶宏漠,企业资源规划—制造业管理篇,北京,电子工业出版社,2000
[8] 林勇,ERP理论与实践,安徽,中国科学技术大学出版社,2007
[9] 蔡宗琰, 制造执行系统研究, 机床与液压,2007,35(02),31~35
[10] 王宏安,荣冈,冯梅等,化工生产执行系统MES,北京,化工工业出版社,2007
[11] 武彦峰,制造企业制造执行系统(MES)的研究与应用,[学位论文],上海交通大学,2004
[12] 王志新,金寿松,制造执行系统MES及应用,北京,中国电力出版社,2006
[13] Gonia M, Using manufacturing execution systems (MES) to track complex manufacturing processes Electronics Manufacturing Technology Symposium, IEEE/CPMT/SEMI 29th International, 2004, 171–173
[14] Li Shuxia, Shan Hongbo, MES Disturbance Information Handling Modeling Automation and Logistics, 2007 IEEE International Conference, 2007, 11~15
[15] Zhou Wei, Jin Yi-hui, A MES design based multi-Agent system, Intelligent Control and Automation, Proceedings of the 4th World Congress, 2002, 2655 ~2659
[16] 冯毅萍,荣冈,流程工业MES体系结构及模型设计,化工自动化及仪表,2006,33(1),1~5
[17] 李文辉,制造执行系统(MES)的应用与发展,兰州理工大学学报,2006,32(02),51~54
[18] Kang,Weonjoon Kim,Hyoungyuk Park,Hong Seong. Design and performance analysis of middleware-based distributed control systems. IEEE Symposium on Emerging Technologies and Factory Automation,ETFA v 2 2001. 253-260
[19] Desmond Dsouza. Enterprise Integration. Software Development, 1999
[20] 张志擦,等. 中间件技术、产品、应用. 中国石化出版社,2002
[21] 李冕等,数据库中间件在一般企业网络信息系统中的应用,计算机工程与应用,2001,Vol.14,pp18-19
[22] 李文辉,制造执行系统(MES)的应用与发展,兰州理工大学学报,2006,32(02),51~54
[23] 张立.中间件技术在企业信息系统中的应用研究.北京工业大学硕士学位论文.2005:10~12
[24] 李成林.基于中间件技术的应用研究.西北工业大学硕士学位论 文.2003:11~13
[25] Heather Kreger,Web服务概念性体系结构http://www-900.ibm.com/developerWorks/cn/webservices/ws-wsca/part1/index.shtml
[26] 谷和启,构建企业门户网站的Web服务 http://software.ccidnet.com/pub/disp/Article?articleID=46175&columnID=214
[27] 周斌,王少红.EIP技术基础及其结构.计算机应用[J] 2001 21( 8):18~19
[28] 公司企业门户及集成应用技术研究,选自先锋资讯http://www.21eb.org/2004/11-22/21210.html
[29] OSI Software Company. PI Universal Data Server Reference Guide, 3rd. USA, March 2002
[30] OSI Software Company. PI Universal Data Server System Management Guide, 3rd. USA, March 2002
[31] OSI Software Company. PI Server Application Guide, 3rd. USA, March 2002
[32] Thuan Thai,Hoang Q Lam 著, .Net 框架精髓[M]. 王敏之译,北京:中国电力出版社, 2001
[33] 施鸿宝、王秋和,专家系统,西安:西安交通大学出版社,1991
[34] 何新贵.,知识处理和专家系统,北京:国防工业出版社,1990
[35] 史忠植.,知识工程北京:清华大学出版社,1988
[36] 杨叔子、丁洪等, 基于知识的诊断推理,北京:清华大学出版社,1993
[37] Joseph Giarratano,Gray Riley著,印鉴译,Expert System Prineiples and Progranuning,北京:机械工业出版社,2000
[2] MESA International. MES functionalities &MRP to MES date flow Possibilities[R].MESA International White Paper Number 2,1997
[3] Amber Computer System Inc. Integratable MES the challenge and the opportunity advanced manufacturing research consulting [EB/0L]. http://www.amrc.com,1999.
[4] 陈庄,ERP原理与应用教程,北京,电子工业出版社,2003
[5] 汪定伟,敏捷制造的ERP及其决策优化,北京,机械工业出版社,2003
[6] 张毅,企业资源规划(ERP),北京,电子工业出版社,2001
[7] 叶宏漠,企业资源规划—制造业管理篇,北京,电子工业出版社,2000
[8] 林勇,ERP理论与实践,安徽,中国科学技术大学出版社,2007
[9] 蔡宗琰, 制造执行系统研究, 机床与液压,2007,35(02),31~35
[10] 王宏安,荣冈,冯梅等,化工生产执行系统MES,北京,化工工业出版社,2007
[11] 武彦峰,制造企业制造执行系统(MES)的研究与应用,[学位论文],上海交通大学,2004
[12] 王志新,金寿松,制造执行系统MES及应用,北京,中国电力出版社,2006
[13] Gonia M, Using manufacturing execution systems (MES) to track complex manufacturing processes Electronics Manufacturing Technology Symposium, IEEE/CPMT/SEMI 29th International, 2004, 171–173
[14] Li Shuxia, Shan Hongbo, MES Disturbance Information Handling Modeling Automation and Logistics, 2007 IEEE International Conference, 2007, 11~15
[15] Zhou Wei, Jin Yi-hui, A MES design based multi-Agent system, Intelligent Control and Automation, Proceedings of the 4th World Congress, 2002, 2655 ~2659
[16] 冯毅萍,荣冈,流程工业MES体系结构及模型设计,化工自动化及仪表,2006,33(1),1~5
[17] 李文辉,制造执行系统(MES)的应用与发展,兰州理工大学学报,2006,32(02),51~54
[18] Kang,Weonjoon Kim,Hyoungyuk Park,Hong Seong. Design and performance analysis of middleware-based distributed control systems. IEEE Symposium on Emerging Technologies and Factory Automation,ETFA v 2 2001. 253-260
[19] Desmond Dsouza. Enterprise Integration. Software Development, 1999
[20] 张志擦,等. 中间件技术、产品、应用. 中国石化出版社,2002
[21] 李冕等,数据库中间件在一般企业网络信息系统中的应用,计算机工程与应用,2001,Vol.14,pp18-19
[22] 李文辉,制造执行系统(MES)的应用与发展,兰州理工大学学报,2006,32(02),51~54
[23] 张立.中间件技术在企业信息系统中的应用研究.北京工业大学硕士学位论文.2005:10~12
[24] 李成林.基于中间件技术的应用研究.西北工业大学硕士学位论 文.2003:11~13
[25] Heather Kreger,Web服务概念性体系结构http://www-900.ibm.com/developerWorks/cn/webservices/ws-wsca/part1/index.shtml
[26] 谷和启,构建企业门户网站的Web服务 http://software.ccidnet.com/pub/disp/Article?articleID=46175&columnID=214
[27] 周斌,王少红.EIP技术基础及其结构.计算机应用[J] 2001 21( 8):18~19
[28] 公司企业门户及集成应用技术研究,选自先锋资讯http://www.21eb.org/2004/11-22/21210.html
[29] OSI Software Company. PI Universal Data Server Reference Guide, 3rd. USA, March 2002
[30] OSI Software Company. PI Universal Data Server System Management Guide, 3rd. USA, March 2002
[31] OSI Software Company. PI Server Application Guide, 3rd. USA, March 2002
[32] Thuan Thai,Hoang Q Lam 著, .Net 框架精髓[M]. 王敏之译,北京:中国电力出版社, 2001
[33] 施鸿宝、王秋和,专家系统,西安:西安交通大学出版社,1991
[34] 何新贵.,知识处理和专家系统,北京:国防工业出版社,1990
[35] 史忠植.,知识工程北京:清华大学出版社,1988
[36] 杨叔子、丁洪等, 基于知识的诊断推理,北京:清华大学出版社,1993
[37] Joseph Giarratano,Gray Riley著,印鉴译,Expert System Prineiples and Progranuning,北京:机械工业出版社,2000