Page 189 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes Extend the SELECT statement to browse the information that is calculated during model
training and stored in the data mining model, such as statistics of the source data.

Create predictions that are based on an existing mining model by using the PREDICTION
JOIN clause of the SELECT statement.
Remove all the trained data from a model or a structure by using the DELETE (DMX)
statement.

13.2.4 DMX Query Fundamentals

DMX functions can be used to obtain information that is discovered during the training of your
models, and to calculate new information. One can also use these functions for many purposes,
including to return statistics that describe the underlying data or the accuracy of a prediction, or
to return an expanded explanation of a prediction.

Self Assessment

State whether the following statements are true or false:
6. Data manipulation language (DML) is a language that you can use to create and work with
data mining models in Microsoft SQL Server Analysis Services.

7. You can use DMX statements to create process, delete, copy and predict against data
mining models.
8. Data definition statements are used in DMX to create and define, to import and export, and
to drop existing models from a database.
9. Data manipulation statements in DMX are not a part of the Data Manipulation Language
(DML).

10. DMX functions can be used to obtain information that is discovered during the training of
your models, and to calculate new information.

Case Study Federal Agency Data Mining Reporting

(a) Short title
This section may be cited as the “Federal Agency Data Mining Reporting Act of 2007”.
(b) Definitions
In this section:

(1) Data mining: The term “data mining” means a program involving pattern-based
queries, searches, or other analyses of 1 or more electronic databases, where—
(A) A department or agency of the Federal Government, or a non-Federal entity
acting on behalf of the Federal Government, is conducting the queries, searches,
or other analyses to discover or locate a predictive pattern or anomaly
indicative of terrorist or criminal activity on the part of any individual or
individuals;

Contd....

184 LOVELY PROFESSIONAL UNIVERSITY