Results 1 to 7 of 7

Thread: Data mining algorithms in SQL Server 2008

  1. #1
    Join Date
    Feb 2010
    Posts
    149

    Data mining algorithms in SQL Server 2008

    Hi all,

    I am using windows server 2008 and installing SQL server 2008 on it. Basically i am student of MCA and want to know more about data mining. I already read the thread What are the Application of data mining? and Data Mining Query task in SQL Server 2008, Alo i want to know them Data mining algorithms in SQL Server 2008. please help. Thanks in advance.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,948

    Re: Data mining algorithms in SQL Server 2008

    I will describe about the Decision Tree Algorithm. Decision tree, also known as decision tree is a binary tree similar to the binary or multi-tree structure. Decision tree is to use the properties of the sample as a node with the property value as a branch, which is similar to the flow chart of the process in which each internal node represents an attribute of the test, each branch represents a test output, and each a leaf node, on behalf of a class or class distribution. It attributes a large number of samples analyzed and summarized. Root node is the most informative of all the properties of the sample, the middle node is the node to the root of the sub-tree contains a sample of the most informative subset of attributes, decision tree leaf nodes is the value of the sample categories. All the best.

  3. #3
    Join Date
    May 2008
    Posts
    2,012

    Re: Data mining algorithms in SQL Server 2008

    You can use Clustering analysis algorithm that is a measure of similarity between individuals is based on individual data points in the geometry of space to determine the distance, the closer the distance, the more similar, the easier it is classified as a class. Defined in the initial classification, the algorithm will be determined by calculating the classification point of grouping the suitability of the situation, and then try to re-define these groups to create a better way to represent data classification. The algorithm loop to perform this procedure, until it can no longer be improved by redefining the classification results were available. So simple that the clustering is to group data objects into a collection of similar objects from multiple classes process. Clustering used in the business aspects of customer analysis, it can be found from the customer base of different customer base and analyze the behavior patterns of different customer base. Thanks.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,005

    Data mining algorithms in SQL Server 2008

    Naive Bayes algorithm is also a Microsoft SQL Server Analysis Services provides a classification algorithm for predictive modeling. Naive Bayes algorithm uses Bayes theorem, assuming a property value impact of a given class is independent of the value of other properties. Compared with other algorithms, the algorithm for computing the required amount is small, and thus able to quickly generate mining model to find input columns and predictable columns relationship. You can use the algorithm to the initial data acquisition, used for a large database, the algorithm is also demonstrated a high accuracy rate and speed, with decision trees and neural networks comparable. Best of luck.

  5. #5
    Join Date
    Jan 2008
    Posts
    1,521

    Data mining algorithms in SQL Server 2008

    Association rules algorithm to find the database the relationship between the variables and individual level, that is, a lot of data to find an interesting correlation between itemsets or related links. For example, in association rule mining, the typical example is market basket analysis, the analysis process is by analyzing the customer purchased the link between different commodities, to tap the customer's buying habits, and to help vendors to develop marketing strategies. Association rule algorithm there are two important parameters of support and confidence. Refers to support for itemset X and Y entries concentration, simultaneous X, Y the probability of the event. Confidence refers to X and Y items itemsets concentration, X the probability of events, Y the probability of events. Cheers.

  6. #6
    Join Date
    Nov 2005
    Posts
    1,323

    Data mining algorithms in SQL Server 2008

    Sequence analysis and cluster analysis algorithm is a Microsoft SQL Server Analysis Services provides a sequence analysis algorithm. You can use this algorithm to study with available through the following path or sequence of events linked to the data. The algorithm for the same grouping or classification in order to find the most common order. In the SQL Server 2008, we can through the Mining Model Viewer to view the sequence of analysis model. Best of luck.

  7. #7
    Join Date
    Sep 2010
    Posts
    1

    question Re: Data mining algorithms in SQL Server 2008

    hi every one !
    I have one question about algorithms in SQL server 2008! for example for decision tree model we have some algorithm like C4.5 or ID3 or CART. so witch of these algorithms used in SQL sever???
    would U please introduce some sources to me for the same question for neural network , clustering ...!!!???

    thx

Similar Threads

  1. Data exchange between Linux, Windows 7 and Server 2008 R2
    By WHeryut in forum Operating Systems
    Replies: 4
    Last Post: 03-02-2011, 04:45 PM
  2. Data Mining Query task in SQL Server 2008
    By Elijah2010 in forum Software Development
    Replies: 5
    Last Post: 23-02-2010, 05:33 AM
  3. Problems with Data Mining Crawler in Windows 7
    By CRiley in forum Operating Systems
    Replies: 5
    Last Post: 14-02-2010, 01:45 AM
  4. Data Storage Problem in SQL Server 2008
    By Kaufman in forum Software Development
    Replies: 4
    Last Post: 05-02-2010, 04:40 AM
  5. What are the Application of data mining?
    By roodiii in forum Software Development
    Replies: 3
    Last Post: 26-11-2009, 09:17 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,625,536.87770 seconds with 17 queries