基于数据挖掘技术的超市决策系统的实现.doc

基于数据挖掘技术的超市决策系统的实现 摘 要 随着信息技术的日益普及，企业决策系统在企业生产管理过程中已获得了广泛的应用，然而决策系统中积累的大量业务数据并没有得到充分的利用，“数据爆炸但知识贫乏”的现象己日益突出。通过数据挖掘技术，企业根据商业目标对决策系统大量的事务数据进行抽取、转换、分析和其它模型化处理，从中提取出辅助商业决策的关键性数据，在推动企业现代化的进程中，有助于进一步增强企业竞争力。 为此，本文在分析数据挖掘现状的基础上，针对我国超市的现行发展现状，对数据挖掘进行了研究与开发。 首先，在探讨数据挖掘一般理论的基础上，研究了针对超市数据仓库的数据挖掘的基本原理；并且研究了超市数据挖掘常用的一些算法。 其次，针对超市销售的特点，与ERP紧密集成，提出了超市决策系统的体系架构和功能划分，并采用维度建模的方法建立了系统的信息模型； 最后，结合我国超市现行决策的需求，采用三层架构的方式，运用了模块化设计的思想，在Visual Studio 2008环境下，用C# 3.0语言和SQL SERVER 2005工具开发了超市决策原型系统，并对原型系统进行了实例数据挖掘应用，并给出了应用的结果。 关键字：ERP系统；决策支持系统；数据仓库；OLAP Data mining technology’s research and application on the data warehouse of the supermarket Abstract With the increasing popularity of the information technology,the decision-making supporting system has been widely applied to the process of manufacuring and management of the enterprise. However, the mass data accumulated during the running of the decision-making supporting system have not been made full use of Data explodation while the knowledge concerned is far from satisfying. With data mining,information critical to business decision-making can be elicited by transforming,analyzing and modeling the abundant database of the business concerned.Hence,in the course of enterprise modernization,data mining can be enhance its competitiveness. In this paper,by analyzing the present situation of the application of data mining,tries to study and develop data mining on the basis of a distibution decision supporting system of a company. Firstly,after the research on the general theories of data mining and the fundamental principles of data mining, the paper gives a brief account of clustering analysis algorithm. Secondly,according to the characteristics of the management of Supermaket distibution,the author,by using the decision-making suport sysem,presents the structure and function dividing fo a purchasing decision supporting system,and then establishes a systematic information model based on dimensional modeling. Finally,taking the need of mak