Page 188 - DCAP606_BUSINESS_INTELLIGENCE

Unit 13: Creating Data Mining Queries and Reports

5. In ....................... -, right-click the instance of Analysis Services, point to New Query, and Notes
then click DMX.

13.2 Data Mining Extensions (DMX)

Data Mining Extensions (DMX) is a language that you can use to create and work with data
mining models in Microsoft SQL Server Analysis Services. You can also use DMX to create the
structure of new data mining models, to train these models, and to browse, manage, and predict
against them. It is composed of Data Definition Language (DDL) statements, Data Manipulation
Language (DML) statements, and functions and operators.
13.2.1 DMX Statements

You can use DMX statements to create, process, delete, copy and predict against data mining
models. There are three types of statements in DMX: data definition statements, data manipulation
statements and data query statements.

Task Compare and contrast the data manipulation statements and data query statements.

13.2.2 Data Definition Statements

Data definition statements are used in DMX to create and define new mining structures and
models, to import and export mining models and mining structures, and to drop existing models
from a database. Data definition statements in DMX are part of the data definition language
(DDL). You can perform the following tasks with the data definition statements in DMX:

Create a mining structure by using the CREATE MINING STRUCTURE statement
Add a mining model to the mining structure by using the ALTER MINING STRUCTURE
statement.
Create a mining model and associated mining structure simultaneously by using the
CREATE MINING MODEL

Export a mining model and associated mining structure to a file by using the EXPORT
statement.

Import a mining model and associated mining structure from a file that is created by the
EXPORT statement by using the IMPORT statement.

Copy the structure of an existing mining model into a new model, and train it with the
same data, by using the SELECT INTO statement.

Remove a mining model from a database by using the DROP MINING MODEL statement.
13.2.3 Data Manipulation Statements

Data manipulation statements are used in DMX to work with existing mining models, to browse
the models and to create predictions against them. Data manipulation statements in DMX are
part of the data manipulation language (DML). You can perform the following tasks with the
data manipulation statements in DMX:
Train a mining model by using the INSERT INTO statement.

LOVELY PROFESSIONAL UNIVERSITY 183