Data Warehouse And Data Mining, Alloy Production Control

Data Warehouse and Data Mining Technology in the manufacturing production control process parameters to determine has a broad application prospects. Nanjing Lian Xun Technology Co.,Ltd. magnesium alloy production process to do a number of production automation and information technology in concrete terms. A good summary of these efforts have not yet explored. System fragmented, production reporting and control systems do not effectively deal with the use of large amounts of data, field data on the actual historical production process of production is far from being the guiding role to play.Papers to be in the Nanjing Lian Xun Technology Co., Ltd. has been made of magnesium alloy production automation, computer configuration to run real-time adjustment and historical reports based on the build host computer database, collecting production data on the actual historical process information for the system can increase market competition to establish a Ability Data Warehouse. Use of these data, the application of data mining techniques for data mining and analysis, to identify magnesium alloy production line in product quality and process temperature, liquid level, flow, pressure and other major process parameters of the better settings, click here to optimize the parameters of operation will increase the passing rate of magnesium alloy products. In this industry, the gating system in general passing rate of production of 90% or less, through the analysis of the data, using the new process parameters can gradually increase the rate of qualified products to 93% or more. This can greatly improve product quality, reduce production costs, improve enterprise competitiveness.Domestic small and medium manufacturing enterprises in the automation, information technology with the developed countries there is a certain gap between the urgent need for advanced software engineering concepts and advanced technology methods, tools used in production practice, database technology in the production control system applications with more of high practical value and prospects of papers to be done in this regard to explore a number of specific applications, database technology for control applications in the enterprise can learn ideas.This paper analyzes the data warehouse and data mining technology in the application of production control system has high practical value and prospects. Alloy production process the company pouring system of quantitative parameters and the quality of the relationship between production process specific data mining warehouse and data analysis to create the design as the core, From the parameter analysis of the idea of starting the decision-making design research to clarify the production process parameters to obtain historical data; discusses the characteristics of the data warehouse, architecture and design methods and procedures; The specific data warehouse design alloy production are described in the historical data to understand and needs analysis, From the conceptual model, logical model, physical model of the specific model transformation start, built on product quality analysis as the theme, production time, melt temperature, pouring flow, such as the dimensions of the melt level data warehouse; On this basis, carry on the alloy pouring system to create the physical data warehouse and data mining. The decision tree obtained information clearly passing rate of the alloy product with the main parameters of the relationship between the adjustment of process parameters for the production provides a basis; The end of the paper at the conclusion of the paper, analyzes the problems of the system, as well as follow-up.