Page 192 - DCAP606_BUSINESS_INTELLIGENCE

Unit 13: Creating Data Mining Queries and Reports

In addition to predicting a value, you can customize a prediction query to return various Notes
types of information that are related to the proposition.

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.
There are three types of statements in DMX: data definition statements, data manipulation
statements and data query statements.
Data definition statements in DMX are part of the Data Definition Language (DDL).
Data manipulation statements are used in DMX to work with existing mining models, to
browse the models and to create predictions against them.
DMX functions can be used to obtain information that is discovered during the training of
your models, and to calculate new information.

13.4 Keywords

Data Definition Language (DDL): Data Definition Language (DDL) describes the portion of SQL
that allows you to create, alter, and destroy database objects.
Data Manipulation Language (DML): A data manipulation language (DML) is a family of syntax
elements similar to a computer programming language used for inserting, deleting and updating
data in a database.
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 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.

13.5 Review Questions

1. What is prediction?

2. What are the types of prediction queries?
3. Discuss about basic prediction query design.
4. Write short note on adding prediction functions.
5. Give examples for singleton query.
6. Elaborate the steps to create a singleton prediction query.

7. What is batch query?
8. Explain the concept of Data Mining Extensions (DMX).
9. What is the use of DMX statements?

10. Write short note on data definition statements.
11. Discuss about data manipulation statements.
12. Provide fundamentals of DMX query.

Answers: Self Assessment

1. Predictions 2. New data

LOVELY PROFESSIONAL UNIVERSITY 187