DMX-SQL SERVER 数据挖掘简介一

SQL SEVER中， DMX可以用于：

1 SSMS

2 SSDT

3 EXCEL DATAMINGING ADDIN

基本句法如下：

创建STRUCTURE

CREATE MINING STRUCTURE [People1]([CustID] LONG KEY,[Name] TEXT DISCRETE,[Gender] TEXT DISCRETE,[Age] LONG CONTINUOUS,[CarMake] TEXT DISCRETE,[CarModel] TEXT DISCRETE)

创建MODEL

ALTER MINING STRUCTURE [People]ADD MINING MODEL [PredictGender-Tree]([CustID],[Gender] PREDICT,[Age],[CarModel]) USING Microsoft Decision Trees

进行TRAIN

INSERT INTO MINING STRUCTURE [People]([CustID], [Name], [Gender], [Age], [CarMake],[CarModel])OPENQUERY(Chapter3Data,’SELECT [Key], Name, Gender, Age, CarMake, CarModelFROM People’)

查询STRUCTURE

SELECT * FROM MINING STRUCTURE People.CASES WHERE IsTestCase()

查询MODEL

SELECT * FROM ClusterDrillthrough.CASES WHERE IsInNode(’001’)

预测查询

SELECT t.[Name], Predict([Gender]) AS PredictedGenderFROM [PredictGender-Bayes]PREDICTION JOINOPENQUERY(Chapter3Data,’SELECT [Key], [Name], [Age], [CarModel]FROM [NewPeople]’) AS tON [PredictGender-Bayes].[Age] = t.[Age] AND[PredictGender-Bayes].[CarModel] = t.[CarModel]