Xml-based Iron And Steel Enterprise Production Management System Design And Applications

The characteristics of production process in iron & steel industry are the long production line, multi-process, complicated field devices and Multi-Technology, etc. Most of the production management systems have the phenomena of isolation in control systems and serious isolated information islands, which lead to the fault between the upper corporate information systems and the bottom process control system, and that in the communication among independent enterprise business application systems. And it easily causes many problems, such as the lack of macro-management and centralized scheduling control in the production process, the separation of plans and the production, and the unknown changes in production field for management staff, etc. All these problems have restricted the development of information and automation in iron and steel industry.In order to handle the problem that process control system and production management system are short of integration in iron and steel enterprise, a data integration platform of combination of virtual data integration and physical data integration is designed, which is the basis of production management and business process in enterprise. The virtual data integration uses XML Schema as the common data model and XQuery as the global query language, and presents a transformation algorithm from XQuery to SQL. The integration of relational sources and XML sources is realized through the XQuery decomposition and Schema mapping. The Microsoft SQL Server 2005 Integration Services is used in physical data integration to extract, transform and load the data.In view of the problem that macro-management and centralized scheduling control are lacked in iron and steel enterprise, a XML-based production management system for iron and steel enterprise is designed. The system has functions of information integration, optimization of production process and decision support under the heterogeneous and distributed environment. Finally, the structure, functions and key techniques of the system are respectively presented. The presented methods are applied to an iron and steal enterprise.