Data Mining Extensions: Difference between revisions

Revision as of 21:47, 9 February 2011

Revision as of 14:36, 7 June 2011

Line 1:

'''Data Mining Extensions''' (DMX) is a query language for [[Data Mining]] Models, muchsupported likeby [[SQLMicrosoft]] is a query language for's [[relationalSQL databases]]Server andAnalysis [[Multidimensional Expressions|MDXServices]] is a query language for [[OLAP]] databases. DMX syntax is more similar to SQL than MDXproduct.

Like SQL, it supports a data definition language, data manipulation language and a data query language, all three with SQL-like syntax.

Whereas SQL statements operate on relational tables, DMX statements operate on data mining models.

Similarly, SQL Server supports the [[Multidimensional Expressions|MDX]] language for [[OLAP]] databases.

== DMX Queries ==

DMX Queries are formulated using the <code>SELECT</code> statement.

They can extract information from existing data mining models in various ways.

==Data Definition Language==

The Data Definition Language (DDL) part of DMX can be used to

* Create new data mining models and mining structures - <code>CREATE MINING STRUCTURE, CREATE MINING MODEL</code>

* Delete existing data mining models and mining structures - <code>DROP MINING STRUCTURE, DROP MINING MODEL</code>

Line 9 ⟶ 17:

==Data Manipulation Language==

The Data Manipulation Language (DML) part of DMX can be used to

* Train mining models - <code>INSERT INTO</code>

* Browse data in mining models - <code>SELECT FROM</code>

* Make predictions using mining model - <code>SELECT ... FROM PREDICTION JOIN</code>

==Example: ofa prediction query==

This example is a singleton prediction query, which predicts for the given customer whether she will be interested in the home loan products.

<code>

Line 38 ⟶ 46:

==External links==

*[http://msdn2.microsoft.com/en-us/library/ms132058(en-us,VS.90).aspx MicrosoftData AnalysisMining ServicesExtensions Data(DMX) MiningReference], BOL(at [[MSDN]])

*[http://www.sqlserverdatamining.com SQL Server Data Mining]

*[http://blogs.msdn.com/jamiemac Jamie MacLennan's Blog]