Pros and Cons of SQL Sever Datamining

  • Mitra_Misra

    Mr or Mrs. 500

    Points: 566

    Hi,

    I need to give a proposal for a project where i need to suggest SQL server data mining. I need some information on the pros and cons of SQL server data mining like how much data it can handle , performance , flexibility , which business scenarios it will not help etc.

    Any information on comparison of SQL server data mining with other data mining tools in market like SAS , Clementine , Intelligent Miner etc.

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    As I don't really know the other tools I can't really give any cons of SQL Server, aside from the learning curve perhaps.

    But I've got some pro's:

    * If you have already SQL Server: it is free!

    * Good integration with Excel (which is still the most commonly used BI interface)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • jcrawf02

    SSC-Insane

    Points: 24198

    BOL has some good links to get you started:

    http://msdn.microsoft.com/en-us/library/ms345131(SQL.90).aspx for 2005, http://msdn.microsoft.com/en-us/library/bb510516(v=SQL.100).aspx for 2008 and

    http://msdn.microsoft.com/en-us/library/bb510516.aspx for 2008 R2.

    Other alternative to consider is the R Project[/url], free, open-source, widely used in the statistical community. Not sure if there's any direct comparison to SQL Server out there, probably something comparing to SAS

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply