Data Mining Extensions (DMX) is a query language for Data Mining Models, much like SQL is a query language for relational databases and MDX is a query language for OLAP databases. DMX syntax is more similar to SQL than MDX. Data mining (DM), also called Knowledge-Discovery in Databases (KDD) or Knowledge-Discovery and Data Mining, is the process of automatically searching large volumes of data for patterns such as association rules. ... SQL (commonly expanded to Structured Query Language — see History for the terms derivation) is the most popular computer language used to create, modify, retrieve and manipulate data from relational database management systems. ... A relational database is a database based on the relational model. ... Multidimensional Expressions (MDX) is a query language for OLAP databases, much like SQL is a query language for relational databases. ... OLAP is an acronym for On Line Analytical Processing. ...
Data Definition Language (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
Data Manipulation Language (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 of prediction query
This example is a singleton prediction query, which predicts for the given customer whether he will be interested in the home loan products.
SELECT [Loan Seeker], PredictProbability([Loan Seeker]) FROM [Decision Tree] NATURAL PREDICTION JOIN (SELECT 35 AS [Age], 'Y' AS [House Owner], 'M' AS [Marital Status], 'F' AS [Gender], 2 AS [Number Cars Owned], 2 AS [Total Children], 18 AS [Total Years of Education] )
Feeds |
Contact