计算机毕业设计---数据挖掘

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

摘要

随着信息技术的日益普及，企业决策系统在企业生产管理过程中已获得了广泛的应用，然而决策系统中积累的大量业务数据并没有得到充分的利用，“数据爆炸但知识贫乏”的现象己日益突出。通过数据挖掘技术，企业根据商业目标对决策系统大量的事务数据进行抽取、转换、分析和其它模型化处理，从中提取出辅助商业决策的关键性数据，在推动企业现代化的进程中，有助于进一步增强企业竞争力。

为此，本文在分析数据挖掘现状的基础上，针对我国超市的现行发展现状，对数据挖掘进行了研究与开发。

首先，在探讨数据挖掘一般理论的基础上，研究了针对超市数据仓库的数据挖掘的基本原理；并且研究了超市数据挖掘常用的一些算法。

其次，针对超市销售的特点，与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 making distribution decisions of a manufacturing company into consideration, the author has developed a

prototype distribution system of data mining by using C#3.0 and SQL SERVER2005 in the Visual Studio 2008 environment,the system basing the supermaket data warehouse,has been put to actual use, the result of which is presented in the paper.

Key words：ERP；decision-making supporting system；data warehouse；OLAP

目录

第一章绪论 (1)

1.1 课题的研究背景、内容和意义 (1)

1.1.1 课题的研究背景 (1)

1.1.2 课题的研究内容及意义 (1)

1.1.3 国内外的研究状况 (1)

1.2 论文的主要工作 (2)

1.2.1 本文工作内容 (2)

1.2.2 创新点 (2)

1.3 小结 (2)

第二章数据挖掘的基本原理及主要算法 (3)

2.1 数据挖掘的基本原理 (3)

2.1.1 数据挖掘的概念 (3)

2.1.2 数据挖掘的任务 (3)

2.1.3 数据挖掘的基本原理 (3)

2.2 数据挖掘的算法模型 (4)

2.2.1 数据挖掘算法概述 (4)

2.2.2 聚类分析概念和理论 (5)

2.3 小结 (6)

第三章系统的分析与建模 (7)

3.1 现状调研与分析 (7)

3.2 数据理解 (7)

3.2.1 数据的特点 (7)

3.2.2 数据的描述 (7)

3.2.3 超市决策系统应解决的问题 (9)

3.3 系统模型构建 (10)

3.3.1 销售主题维度模型 (10)