A Multidimensional Analytical System Based On .NET Technique

With the development of information technique, a large quantity of data are gathered .People urgently want to find a way to transform data into useful information. The following important techniques: data warehouse, OLAP, data mining build up decision support technique based on data warehouse that solves the strategic problems to be faced by enterprises.In this paper, I not only introduce the fundamental theory and technologies of data warehouse and OLAP but also do some research on pattern recognition based on statistical theory and time series pattern and its application of predictive model algorithm. Combined with the practice in production of carbon rotary kiln for aluminum, I has improved the simple distance for classify algorithm and applied it to collecting and detecting in abnormal character of carbon rotary kiln, and besides, I has applied the time series pattern predictive algorithm to forecast abnormal working state of carbon rotary kiln. I put emphasis on the design and implementation of a multidimensional analytical system for carbon rotate kiln production data. In the system, I mainly realize the following functions: to construct suitable data warehouse based on decision and analysis requirement; based on the algorithm of detecting and predicting abnormal state, to analyze abnormal data and give a alarm to users in order to avoid seriously production accident; to make good use of OLAP technique to implement drilling, slicing, rotating so that improve the ability of scientific decision and analysis; to automatic make various reports in production and management and make statistic of these reports.The system is the part of the large scale aluminum electrolysis pot information integration and control system which has been awarded the science and technology creative excellent prize of 2004 NingXia hui Autonomy district. After the system is put into practice, it has played an important role in a series of fields: instructing production, standardizing carbon rotary kiln production, avoiding serious accident, improving the ability of scientific management and received high praise from users.