DATABASE

Programming Microsoft SQL Server 2005: Using the Data Mining Wizard and Data Mining Designer (part 4) - Deploying and Processing Data Mining Objects

1/14/2011 5:35:24 PM

Deploying and Processing Data Mining Objects

We have done a good bit of work already, having defined a mining structure with several mining models. We are almost ready to view and query the models, but we must first deploy and process the SSAS database that contains them. We can deploy the database and process the mining models in a single step by choosing the Start Debugging command from the Debug menu, clicking the Start Debugging (play) toolbar button, or pressing the F5 key.


Deployment and processing might take several minutes. You can monitor deployment and processing progress in the Deployment Progress window, which by default appears as a docked window in the lower-right corner of Visual Studio when you start the deployment. If the Deployment Progress window is not visible, you can show it by choosing Show Deployment Progress from the View menu or by right-clicking the project node and choosing Show Deployment Progress in Solution Explorer.

It is easiest to monitor the progress of the deployment and processing of your mining structure and models by undocking the Deployment Progress window and resizing it to a relatively large size. Figure 10 shows the Deployment Progress window for a successfully deployed and processed SSAS project.

Figure 10. The Deployment Progress window after a successful deployment

Tip

The easiest way to undock the Deployment Progress window is to double-click its title bar. You can redock it after processing has completed by double-clicking the title bar a second time. This avoids the sometimes confusing drag-and-drop procedure for undocking and redocking the window.


Caution

If you encounter processing errors indicating that columns of your data source do not exist, you might need to change the impersonation information of the data source in your SSAS project. To do this, double-click the data source node under the Data Sources node in Solution Explorer, click the Impersonation Information tab, and select an appropriate user. During development, you can select the Use The Service Account option button. Before deploying the database and mining models to production, however, you should select a specific user account with the appropriate rights.


After the initial deployment of the SSAS database, you can process mining models without deploying the database. To process all the mining models within a structure, choose Process Mining Structure and All Models from the Mining Model menu. To process a single model in a mining structure, select the model on the Mining Models tab and then choose Process Model from the Mining Model menu. Both the Process Mining Structure and All Models command and the Process Model command are also available from each model’s shortcut menu on the Mining Models tab and from the two leftmost buttons on that tab’s toolbar.

Other  
 
Video
Top 10
SG50 Ferrari F12berlinetta : Prancing Horse for Lion City's 50th
The latest Audi TT : New angles for TT
Era of million-dollar luxury cars
Game Review : Hearthstone - Blackrock Mountain
Game Review : Battlefield Hardline
Google Chromecast
Keyboards for Apple iPad Air 2 (part 3) - Logitech Ultrathin Keyboard Cover for iPad Air 2
Keyboards for Apple iPad Air 2 (part 2) - Zagg Slim Book for iPad Air 2
Keyboards for Apple iPad Air 2 (part 1) - Belkin Qode Ultimate Pro Keyboard Case for iPad Air 2
Michael Kors Designs Stylish Tech Products for Women
REVIEW
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
Popular Tags
Video Tutorail Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Exchange Server Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe Photoshop CorelDRAW X5 CorelDraw 10 windows Phone 7 windows Phone 8 Iphone