Data Mining Extensions (DMX) is a

query language A query language, also known as data query language or database query language (DQL), is a computer language used to make queries in databases and information systems. In database systems, query languages rely on strict theory to retrieve informa ...

for

data mining Data mining is the process of extracting and finding patterns in massive data sets involving methods at the intersection of machine learning, statistics, and database systems. Data mining is an interdisciplinary subfield of computer science and ...

models supported by

Microsoft Microsoft Corporation is an American multinational corporation and technology company, technology conglomerate headquartered in Redmond, Washington. Founded in 1975, the company became influential in the History of personal computers#The ear ...

's SQL Server Analysis Services product. Like

SQL Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...

, it supports a

data definition language In the context of SQL, data definition or data description language (DDL) is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements are similar to a computer programming language for defining d ...

(DDL),

data manipulation language A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage of a broader database language such as SQL, with the DML com ...

(DML) and a data query language (DQL), all three with SQL-like syntax. Whereas SQL statements operate on relational tables, DMX statements operate on data mining models. Similarly,

Microsoft SQL Server Microsoft SQL Server is a proprietary relational database management system developed by Microsoft using Structured Query Language (SQL, often pronounced "sequel"). As a database server, it is a software product with the primary function of ...

supports the MDX language for

OLAP In computing, online analytical processing (OLAP) (), is an approach to quickly answer multi-dimensional analytical (MDA) queries. The term ''OLAP'' was created as a slight modification of the traditional database term online transaction processi ...

databases. DMX is used to create and train data mining models, and to browse, manage, and predict against them. DMX is composed of data definition language (DDL) statements, data manipulation language (DML) statements, and functions and operators.

Queries

DMX Queries are formulated using the SELECT statement. They can extract information from existing data mining models in various ways.

Data definition language

The

(DDL) part of DMX can be used to * Create new data mining models and mining structures - CREATE MINING STRUCTURE, CREATE MINING MODEL * Delete existing data mining models and mining structures - DROP MINING STRUCTURE, DROP MINING MODEL * Export and import mining structures - EXPORT, IMPORT * Copy data from one mining model to another - SELECT INTO

Data manipulation language

The

(DML) part of DMX can be used to * Train mining models - INSERT INTO * Browse data in mining models - SELECT FROM * Make predictions using mining model - SELECT ... FROM PREDICTION JOIN

Example: a prediction query

This example is a singleton prediction query, which predicts for the given customer whether she will be interested in home loan products. SELECT oan Seeker PredictProbability( oan Seeker FROM ecision TreeNATURAL PREDICTION JOIN (SELECT 35 AS ge 'Y' AS ouse Owner 'M' AS arital Status 'F' AS ender 2 AS umber Cars Owned 2 AS otal Children 18 AS otal Years of Education)

References

External links

Data Mining Extensions (DMX) Reference
(at

MSDN Microsoft Developer Network (MSDN) was the division of Microsoft responsible for managing the firm's relationship with developers and testers, such as hardware developers interested in the operating system (OS), and software developers developing ...