基于SQL Server的OLAM的研究及应用  

Research and Application of OLAM Based on SQL Server

作　　者：王万川[1] 吴陈[1] 

机构地区：[1]江苏科技大学计算机科学与工程学院,江苏镇江212003

出　　处：《计算机与现代化》2012年第2期202-206,共5页Computer and Modernization

摘　　要：OLAM(On-line Analytical Mining)是当前的热点技术,是融合了联机分析处理(OLAP)和数据挖掘(Data Mining)的一种新的数据挖掘技术。本文主要研究数据仓库中OLAP,On-line Analytical Processing和数据挖掘技术,这两个技术是商业智能中的核心技术和主要内容,在两者的基础上引入OLAM的概念,并阐述其基本原理和核心技术。基于微软的SQL Server平台,为一个商业案例建立数据仓库,利用Analysis Services服务,建立销售分析的多维数据集,利用OLAM的基本模型实现OLAP和聚类挖掘技术的结合,借助两者的各自优势,得到很好的客户聚类分析结果。OLAM（On-line Analytical Mining） is current hot technology and a new mining method which fuses the advantages of OLAP and data mining.This paper focuses on the OLAP and data mining technology which are the core technologies and primary content of business intelligence.OLAM is introduced on the basis of the two technologies,and the basic principles and core technologies are expounded.A data warehouse for a business case is built based on SQL Server platform,and a sales cube is built by OLAP using Analysis Services.The combination of OLAP and clustering mining is realized by means of OLAM model,the conclusion is that a good clustering result of customer is obtained with the aid of superiority of OLAP and clustering mining.

关 键 词：数据仓库 SQL SERVER 联机分析处理 数据挖掘 联机分析挖掘 聚类分析 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]