DMX-SQL SERVER 数据挖掘简介一
来源:互联网 发布:知其所以然论坛网址 编辑:程序博客网 时间:2024/05/21 07:10
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]
- DMX-SQL SERVER 数据挖掘简介一
- DMX-SQL SERVER 数据挖掘简介一
- DMX- SQL SERVER 数据挖掘简介二
- DMX - SQL SERVER 数据挖掘决策树
- DMX - SQL SERVER 数据挖掘聚类
- SQL Server 数据挖掘系列(一) - 探讨微软数据挖掘理念"全员BI"
- SQL Server 2005数据挖掘
- [分享]微软BI专题-数据挖掘扩展插件语言:DMX
- SQL Server 2005数据挖掘开发者指南
- SQL Server 2005 数据挖掘(1)
- SQL Server 2005数据挖掘步骤
- SQL Server 2005数据挖掘开发者指南
- SQL Server 2008数据挖掘查询任务
- SQL Server 2005数据挖掘算法
- SQL Server 2008 数据挖掘算法浅析
- SQL Server 2008 数据挖掘算法浅析
- SQL Server 2008 R2数据挖掘即学即用
- 数据挖掘SSAS(Sql server analysis service)
- lucene 和hibernate search
- svn: Item is out of date
- 2112-Dynamic Rankings(超时)
- 对于REST中无状态(stateless)的一点认识
- Android之ListView
- DMX-SQL SERVER 数据挖掘简介一
- zoj 1789 The Suspects
- AndEngine 物理世界引擎 JNI 引入
- ImageView属性详解
- Windows文件操作的笔记和关键,MMClassify V2.0
- codeforces上解题感受
- Windows 8实例教程系列 - 开篇
- !!!Chapter 13 Copy Control
- UVa 11559 - Event Planning