all groups > sql server data mining > march 2004 > threads for march 22 - 28, 2004
Filter by week: 1 2 3 4 5
Clustering data
Posted by Lars Roith at 3/25/2004 4:28:40 PM
Hello everybody,
I have a relational database containign a table with a lot of facts (e.g.
yearly income).
Now I want to build groups/clusters for the yearly income.
Is there a way to have the analysis services doing the job automtically?
The result should be:
e.g 7 Clusters with the foll... more >>
Getting Just The Date
Posted by Atley at 3/25/2004 12:57:00 PM
This sounds stupid, but I cannot find a way to just get today's date without
the time to pull a date range...
I have tried convert (datetime, GetDate(), 112) and some others, all to no
avail... isn't there just a date function that doesn't include the time?
... more >>
Problem converting to a date...
Posted by Atley at 3/25/2004 10:47:41 AM
I have a field in a table that contains date data in the following format:
20040301
what is the best, low impact method for converting this to a useable date
field?
... more >>
Joins vs Where Clause
Posted by Dave Debreceni at 3/24/2004 3:16:09 PM
I have a query which used 2 tables in the from clause and used the where clause to get the result like so
Select tb1.*, tb2.
from tb1, tb
where tb1.id = tb2.i
and tb1.data_dt = '20031231
This query for these tables where are large, about 2 million rows a piece, returned the correct result, but... more >>
3rd party tools for viewing clustering and decision tree models
Posted by jrock at 3/23/2004 6:16:15 PM
i'm writing a program in VB that predicts customer buying patterns using MS AS as the back end....i've create the mining model using VB but i want to show the decision trees and the cluster models to the user through the front end.....are there any 3rd party tools that i could use to do this.....and... more >>
Angoss SDK sample - Interpreting the clusters?
Posted by Sinex at 3/23/2004 5:25:06 PM
Hi !
I tried the Angoss sample application that comes with the SDK. The
cluster model shows up in the SegView control.
The first column makes sense - it talks abt the distinct clusters in the
entire population. But wat are the other pie charts? How was cluster 001 to
cluster 010 created? D... more >>
|