Processing Data Mining Objects

Processing a mining structure or mining model is different than processing OLAP objects, such as dimensions and cubes. In OLAP processing you build cubes with aggregations, whereas in data mining processing you create training data and run mining algorithms on that data. For more information, see Processing in Analysis Services.

Processing Mining Structures

To control how the models are processed within your mining structure, you can process a mining structure separately from its associated mining models. First, you must process the associated mining structure and then you can proceed to process the mining model you are interested in. For example, if you have a mining structure named msSalesCluster that has several models associated with it, but you only want to process one model, named mm1SalesCluster, you can process msSalesCluster first, and then process mm1SalesCluster by itself. You can process a mining structure using the menus or buttons in the Mining Models tab or Mining Structure tab in Data Mining Editor. In the processing dialog box, select a processing option and click Run.

If you are concerned about conserving hard disk space, note that Analysis Services retains mining structure caches locally. That is, it writes out all the training data to your local hard disk. If you do not want the data cached, you can change the default by setting the CachingMode property on the mining structure to destroy the cache after models are processed.

Processing Mining Models

You must process the Analysis Services models that you define before you can start to work with them. You also must reprocess the mining models whenever you change the mining model structure, update the training data, change an existing mining model, or add a new mining model to the structure.

You can process the mining models in the following ways.

  • Deploy the project. Depending on the project settings and the current state of the project, the mining models in the project may be processed when the project is deployed. When you initiate deployment, processing begins automatically, unless there is a previously processed version on the Analysis Services server and there have been no structural changes. You can deploy a project by selecting Deploy solution from the drop-down list or by pressing the F5 key. You can control how mining models are deployed by adjusting the deployment properties. For more information about deploying an Analysis Services solution, see Deploying Analysis Services Development and Production Systems.
  • Use the menus or buttons in the Mining Models tab or Mining Structure tab in Data Mining Editor. In the Mining Models tab, you can reprocess the mining structure, or process just the selected mining models, or process all the mining models associated with the structure.
  • Open the Mining Model Viewer tab in the Data Mining Editor. If the mining model structure is out-of -date, the editor prompts you to redeploy and process the mining model.

See Also


Data Mining Concepts
Mining Structures (Analysis Services)
Processing in Analysis Services

Help and Information

Getting SQL Server 2005 Assistance