Based On Data Warehouse Technology In Steel Metal Balance Management Applied Research

In steel enterprises, according to conservation of mass that the quality maintains a balance of the procedure that it comes from beginning to ending in theory, it is called "metal balance".Based on the principle of metal materials for steel enterprise internal statistic analysis, effectively improve each working procedure and metal loss, improve the utilization efficiency of metal work called "metal balance management". It is a comprehensive steel enterprise technical management, important symbol of smelting, steel rolling technology and management level.From the law of conservation of mass, we summarize the model of metal balance. With the characteristics and the difficulties of the production management, it can be combined with the data warehouse principle and method. With the actual production line for the prototype put forward a set of practical based on data warehouse technology of metal balance management solutions, including the system architecture, the ETL process, index system,report query and statistical analysis.This application solution can improve enterprise management, strengthen the basic work of production management, improve the level of management. The enterprise can also support the planning department and finance department with the work plan and data supporting. IT also accounts for the leadership important reference and decision-making.