Data Warehouse System Based on Iron & Steel Enterprise

This paper firstly reviews common construction of information system of iron & steel enterprise, and then detailedly introduces five-layer structure of data warehouse. It is made of data source layer, operation data storage layer, subject data set layer, data analysis layer and data display layer. Among all, the concept and building process of subject data set and the characteristics of various models in data analysis layer are explained detailedly. Lastly this paper gives an analysis example of important quality index of rolling coil which introduces the process of selecting data source, building subject data set, analyzing data by calling methods and models in data analysis layer. It is proved that by building data warehouse system, it can improve efficiency of production and support enterprise's decision.