Research Of Data Mining Technology In The Supermarket's Data Warehouse

The data of large database can't be fully used and analyzed by the traditional database management information system, on the other hand, data mining and data warehouse resolve such problem well. This paper first introduces the data mining and data warehouse's knowledge, including the relation of data mining and data warehouse and the connection of olap and statistics, then puts the data mining pattern and the data mining process model in detail. It addresses the dynamic cluster arithmetic and preprocess data by the primary component analysis arithmetic, then improves the dynamic cluster arithmetic.As one application, this paper analyses the operational database, then builds the supermarket's data warehouse logical model with the method of starschema, after that, the data is extracted from operational database. The "valuable and clean" data is loaded into the data warehouse after transformed by some tools or programming languages, then the physical model of supermarket's data warehouse is finished. Following the Two Crows data mining process model, the product data, transaction data and customer's demographic data are accumulated, such data is preprocessed by the primary component analysis method which can low the connection of variants and reduce the number of variants. One model is built by the improved dynamic cluster method. The quality of the model's result will be improved with deleted the outlier data. At last the result of this model is explained in detail.There is closed connection between the data mining and the data warehouse: data warehouse is one excellent platform of data mining, what's more, the decision function of data warehouse can be developed well withthe help of data mining, so the seamless integration of data mining anddata warehouse is one hit topic, this trend also be addressed more in thispaper.