Creating DMX Prediction Queries
The main goal of most data mining projects is to use mining models to create predictions for new data. For example, you may want to predict how many bicycles your company will sell next year during December, or whether a potential customer will purchase a bicycle in response to an advertising campaign. You can also use predictions to explore the information that the algorithms discover when they train the mining models.
Prediction queries are based on the Data Mining Extensions (DMX) language. DMX extends the SQL language, to provide support for working with mining models.
For More Information:Data Mining Extensions (DMX) Reference, Understanding the Select Statement (DMX), Prediction Queries (DMX)
Prediction Query Tools
SQL Server provides two tools that you can use to build prediction queries: Prediction Query Builder and the Query Editor. Prediction Query Builder is included in the Mining Model Prediction tab of Data Mining Designer. When you use the query builder, you can use graphical tools to design a query, use a text editor to manually modify the query, and use a simple results pane to view the results of the query. The Query Editor provides tools that you can use to build and run DMX queries.
You can also include prediction queries as part of a SQL Server 2005 Integration Services (SSIS) package.
For More Information:Using the Prediction Query Builder to Create DMX Prediction Queries, Creating DMX Queries in SQL Server Management Studio
See Also
Concepts
Data Mining Concepts
Working with Data Mining
Other Resources
Data Mining Extensions (DMX) Reference
Mining Model Prediction Tab How-to Topics