Data Mining on SQL 2005 database

Is it possible to enable data mining tools on SQL SERVER 2005 database.

i need some tutorials on this? Please help ou

Ronald

Yes, it is possible.

http://msdn2.microsoft.com/en-us/library/ms166552.aspx

http://msdn2.microsoft.com/en-us/library/ms167488.aspx

|||

Hi Andrew, I have created some mining models based on the Adventure Wiorks database (Microsoft Decision Trees, Microsoft Time Series).

How can executives managers be able to view trends, forecasting charts based on Microsoft Time Series Model using ASP.NET 2.0 with C#.

Please help me out.

Thanx

Ronald

|||

For Time Series, perhaps the easiest way is to :

- connect to Analysis Services using the Profiler tool

- launch the Time series model in the BI Developer Studio viewer

- capture the query sent by the user

- create a report in Reporting services that sends the same query and then renders the charts.

If you want to do your own rendering, then you should follow the same steps to get the query of interest, then execute it from your web app using Adomd.Net Client or even OLE DB.

SQL Server 2005 comes with some sample web viewers for some of the Data Mining algorithms: Decision Trees, Naive Bayes and Clustering. You can see those viewers at work on sqlserverdatamining.com:

http://www.sqlserverdatamining.com/MovieSurveyDemo

|||

How do i capture the query sent by the user?

Can't I use reportviewer to render repoerts with cahrts? Please I kindly ask you to elaborate more on the last point of using Adomd.NET Client or even OLEDB.

Thanx in advance

Ronnie

|||

You can use SQL Profiler to see all communication between the client and server. You can use RS to create reports with charts - somewhat. The charting is a bit limited, so it's difficult to replicate the charts in our viewer, and the viewers execute multiple queries and you would need a single query response to render a report.

You can work around the latter part by creating a .NET stored procedure for Analysis Services that would generate the appropriate rowset that you want to render in RS. You will likely need to do some finagling to get the charts rendered appropriately in a report though (e.g. different line styles for actual vs. predicted)

|||Hi Bogdan,

I have accessed the website, but I don't find the web viewers you mention. Where is it?
My customer want to see the result of mining in their web client/browser.

Bernaridho