Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server data mining > february 2006 > threads for february 8 - 14, 2006

Filter by week: 1 2 3 4

hosting: analsys services 2005??
Posted by sqlster at 2/14/2006 9:21:26 PM
Where could I host my sql server 2005 applications such as sql reporting services, SSIS, analysis services data mining stuff ?? TIA......more >>


PMML
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 2/14/2006 9:20:08 PM
Where Can I Get a PMML Model Consumer? I need an aplication able to read and apply PMML Models......more >>

predict function -- why get most popular items????
Posted by sqlster at 2/14/2006 7:13:27 PM
I still don't understand why do I get most popular items when I try to use function like predict(sometable,5)??? Either it should return the most relevant results or not return any value at all. Lets take movies case that I have been asking question about. If a movie is chosen for which...more >>

PredictTimeSeries function stops predicting?
Posted by Maxim Goncharov at 2/14/2006 4:00:12 PM
After I installed release version of SQL Server 2005 I encountered a strange behavior of PredictTimeSeries function. It stops to predict values after some prediction steps. For example, the query SELECT FLATTENED PredictTimeSeries([ORDER AMOUNT], 30) FROM [SALES BY DATE] issues only 3 predict...more >>

Clustering
Posted by MichaelJJ/DK at 2/14/2006 2:34:01 PM
Hi there I am rying to learn datamining with ss05. And have this problem. I have tried to build a clustering datamodel with a case based on a organisation units and a nested table with activity data: unit activity Measure(Fact) 1 A 5 B ...more >>

Decision Trees - Bayesian Dirichlet Equivalent
Posted by weehyong at 2/14/2006 1:49:57 AM
The default scoring method used in the Decision tree algorithm is Bayesian Dirichlet Equivalent with Uniform Prior (4). 1. Internally, instead of a decision tree, is it stored as a Bayesian network or decision graphs? 2. Any resources/examples to understand this scoring method? Thanxs....more >>

Data mining
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 2/14/2006 12:00:00 AM
I am trying to find more about data mining description. Something like definitions of it. I heard about things like predictive models, classifications, regressions, clasters, sumarisation, etc. but still I couldn't find real meaning in data minig of those words. Can you tell me (or give me some link...more >>

Is the technology of 'Markov's chain' used?
Posted by Peter.c at 2/14/2006 12:00:00 AM
Hello,the term of 'Markov's chain' was mentioned in the message of http://www.sqlserverdatamining.com/DMCommunity/Newsgroup/2274.aspx . But after browsing the content of http://msdn2.microsoft.com/en-us/library/ms175462.aspx ,I get the idea that Markov's chain is unnecessary in implementing Microso...more >>



Text Mining With Sql server 2005 Analysis Services
Posted by Satish Thumar at 2/14/2006 12:00:00 AM
Hi Can any one give me step by step process to do text mining on sql server 2005 I have collection of text files and i want to extract some information from them. Thanks in Advance Satish...more >>

why is DecisionTree view arranged in the Mining Model Viewer of Time Series?
Posted by Peter c at 2/13/2006 1:20:09 PM
Hello, when I use the mining modle viewer of time series modle in BI Development,the decision tree view appears. I don't understand the relationship between the decision tree and the time series modle.So I am puzzled to it. Whould you please tell me the relationship between them and the use of th...more >>

Algorithm plugins
Posted by Paul at 2/13/2006 10:57:20 AM
I'm not a COM wizard so any suggestions on how to debug these? Do you need to somehow attach to the main Analysis Services service? ...more >>

Seattle SQL 2005 Reporting services
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 2/10/2006 11:40:08 PM
Sorry for the blatant ad, but we're looking for help -- any recommended firms in seattle area up to speed on 2005 reporting services?...more >>

Tricky query
Posted by Sonia at 2/10/2006 12:07:18 AM
Hi, I'm reposting my question hoping to get some help since it was not answered some time ago. I need to track the orders placed by salesmen by month. SELECT SUM(CASE MONTH(DATE_SELL) WHEN 1 THEN 1 ELSE 0 END) AS January, ... SUM(CASE M...more >>

query mining model from T-SQL
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 2/9/2006 10:20:13 PM
It is possible to query a relational datatable from DMX using call systemopenquery([Data_Source]'SELECT.....'). Is it possible to make queries of the mining model in the opposite direction from T-SQL on Database engine by any of the functions?...more >>

data mining error
Posted by dan NO[at]SPAM vcat.com at 2/9/2006 2:00:10 AM
Has anyone seen this error before? "An unexpected error occurred (file 'dmcorrcountutils.cpp', line 2045, function 'DMCC_WorkerJobCaseProcessor::CacheCase')." ...more >>

In TSQL how to use OPENXML to open an ntext field in a table? I can not read the ntext into a local var as TSQL does not allowe ntext local variables.
Posted by Daniel at 2/9/2006 1:39:50 AM
In TSQL how to use OPENXML to open an ntext field in a table? I can not read the ntext into a local var as TSQL does not allowe ntext local variables. ...more >>

predict function error: results get repeater over and over
Posted by sqlster at 2/8/2006 10:05:26 PM
I am getting strage results when I try to run prediction query. Lets consider the following structure/model: drop mining model mym_ar drop mining structure myst CREATE MINING STRUCTURE myst ( custid long key, basket table ( moviebought text key ) ) ALTER MINING STR...more >>

anyone knows SPSS plug-in for SQL server 2005?
Posted by Dino Hsu at 2/8/2006 9:51:54 PM
I am told in a webcast today that SPSS 14 can be fully plugged into SQL server 2005, anyone has more information or experience on this? Thanks in advance. ...more >>


DevelopmentNow Blog