Support Vector Machines for SQL Server Data Mining

Many have requested that we implement Support Vector Machines (SVM’s) for SQL Server 2008, and for a wide variety of reasons, we just couldn’t get to it.  Luckily the community has come to the rescue for those needing an SVM implementation today!  Joris Valkonet of Avanade Netherlands along with colleague Thanh Luc have implemented an…

1

Visual Numerics integration into SQL Server Data Mining

Our friends at Visual Numerics, Inc have created an excellent white paper covering the creation of SQL Server Data Mining plug-in algorithms in C#.  In addition to documenting all of the architecture and concepts required, they have created a step-by-step tutorial demonstrating how to integrate their own K-Means clustering algorithm into SQL Server Data Mining…

1

Tree Utilities in Analysis Services Stored Procedures

This past week I was helping out a customer that wanted to reduce the length of a questionairre by using data mining to determine which of the 300+ questions were actually necessary for them to get the understanding they required.  By using a tree model, and playing with the COMPLEXITY_PENALTY parameter, I was able to…

1

Social Network Analysis with SQL Server 2005 Data Mining

A few years ago John Hancock spent some time with our team and did some interesting work around using the Association Rules algorithm and some custom Analysis Services stored procedures to implement link analysis (a.k.a. social network analysis).  His implementaion was extremely novel, and the product team (self included) was duly impressed by what John…

0

Automatically Label Clusters using Analysis Services Stored Procedures

I just found this awesome posting on CodePlex by furmangg to automatically label the clusters generated by the clustering algorithm.  It examines the cluster content to generate human-readable descriptions and then changes the labels appropriately.  Check it out – it might just save you a bunch of time figuring out what all the clusters mean.

0

Direct Links to Data Mining feature pack items

Many people have asked me for the links to the embeddable viewers and the .NET interfaces for plug-in algorithms.  Instead of my usual response, “go to the feature pack page and scroll until you find them”, here are the direct links.  Enjoy! Data Mining Embeddable Viewershttp://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb#dmviewer Managed Plug-in APIhttp://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb#dmapi Also, you may need to download…

0

Managed Plug-ins at Last!

For all those of  you who have been waiting and waiting to implement your own data mining algorithms for SQL Server 2005, but didn’t want to get into the complexity of writing C++ COM code – it’s finally here!  The Managed Plug-in API’s are available as part of the SQL Server 2005 feature pack.  Scroll…

0

Automatic Generation of CREATE MINING MODEL statements

I noticed through answering newsgroup and forum posts that we always want to know model definitions when discussing a problem.  Luckily we have this great language called DMX that makes it very easy and simple to describe a model.  Unluckily, our tools that we use to create models use an XML DDL that is very…

0

Two similar but different resources now available

There are two new resources available for writing custom algorithms for SQL Server Data Mining “Add Custom Data Mining Algorithms to SQL Server 2005” by our own Raman Iyer, provides an overview of the plug-in process, what you do and what you get, along with links to more technical resources. Implementing Data Mining Algorithms in…

0

Code from book and new XMLA template at SSDM

I just added a couple of new downloads on SQLServerDataMining.com The first is the sample from chapter 16 (Forecasting in Excel) of my book, Data Mining with SQL Server 2005 which was misposted on the publisher’s site (it will be updated there as well, but it’s at SSDM for those of you who want it…

0