What is Knowledge Discovery and Data Mining?

Question

I suppose SQL queries fetch "raw data"...

Is there any good point to start regarding data mining in SQL server?

Are there any available KDD ready-to-go, algorithms in MS-SQL server 2005, 2008?

Answer 1

Well, there certainly are tons of excellent resources to start with in terms of understanding what's available, how to use it, where to use it, etc. And yes, there are pre-packaged algorithms included with both Sql 2005 and 2008, including:

• Microsoft Decision Trees
• Microsoft Naive Bayes
• Microsoft Clustering and Sequence Clustering
• Microsoft Neural Network
• Microsoft Association
• And more

As well as extensibility support for 3rd party algorithm plug-ins.

Excellent resources for starting out with mining in sql server:

• Sql Server data mining team home
• Jamie T's blog
• Data mining on MSDN
• Brent Ozar's discussion on mining Stack Overflow
• And of course google