The Application Of Data Warehouse And Data Mining Technologies In A Large Supermarket CRM

With the great development of economy, the retail industry sales model is also changing. Mature customer relationship management theory and implementation of successful cases prompted large supermarket implement CRM. Large supermarket implement CRM provide targeted marketing strategy, eventually improve the turnover of the large supermarket。Large supermarket demand for historical sales data analysis are put forward. And the emergence of data warehouse and data mining technology to analyze related information from the vast amounts of data, become the effective solutions to requirements.This paper first discusses the large supermarket the research background and significance of CRM implementation, analyzes the research status at home and abroad. And then expounds the data warehouse, OLAP, data mining and CRM and other related knowledge, according to the actual needs of large supermarkets, designed the basket correlation analysis model, the customer value model and the model of customer churn, Among them, are mainly introduced in this article basket correlation analysis algorithm, at the same time on the basis of the Apriori algorithm, this paper proposes a new algorithm for mining association rules, This algorithm has a close relationship and a relational database, and the algorithm has better stability and efficiency, better solve the large supermarket in the shopping basket between goods, merchandise category and merchandise, merchandise category the correlation analysis between requirements.In data warehouse, application forms for reporting statistics technology to establish a large supermarket CRM model various statements, and shown in the chart, and other forms as a result, the analysis results show in the Web way to the user.The success of the system design provides decision support for managers.