Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Forcing splits in a decision tree

 
   Database Help (Home) -> Datamining RSS
Next:  Third CEU Summerschool on Advanced Statistics and..  
Author Message
jennifer_chan

External


Since: Apr 09, 2008
Posts: 1



(Msg. 1) Posted: Wed Apr 09, 2008 5:32 am
Post subject: Forcing splits in a decision tree
Archived from groups: microsoft>public>sqlserver>datamining (more info?)

Hi there,

I'm fairly new to decision trees and have just got my head around using DMX
and ADOMD.NET to create and process Analysis Services mining models using the
Microsoft Decision Trees Algorithm. I am able to embed the resultant tree
into my C#.NET windows form using the MiningModelViewerControl class.

Is it possible to force a split on a node in the decision tree within the
viewer? I cannot get this to happen in the viewer or via the code. Also i
cannot see this being possible in SQL Server Management Studio.

Forcing a split refers to specifying a variable or characteristic on which to
further split a node (e.g age of customers > 25 years). It is expected that
the node on which a split is forced, will get some child nodes as a result. I
cannot add child nodes to any existing node in the code. And i cannot do
anything in the Model Viewer. Any help i can get is greatly appreciated.

Thank you!

 >> Stay informed about: Forcing splits in a decision tree 
Back to top
Login to vote
Bogdan Crivat MSFT

External


Since: Feb 20, 2004
Posts: 12



(Msg. 2) Posted: Fri Apr 11, 2008 9:49 am
Post subject: Re: Forcing splits in a decision tree [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Interactive training of models is not supported in SQL Server Data Mining.
A workaround is available, in SQL Server 2008, for your problem: you can
create two mining models in the same mining structure and use data filters
for each mining model -- the first model filters by Age > 25, the second by
Age <= 25

--
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.

thanks,
bogdan

"jennifer_chan" wrote in message
> Hi there,
>
> I'm fairly new to decision trees and have just got my head around using
> DMX
> and ADOMD.NET to create and process Analysis Services mining models using
> the
> Microsoft Decision Trees Algorithm. I am able to embed the resultant tree
> into my C#.NET windows form using the MiningModelViewerControl class.
>
> Is it possible to force a split on a node in the decision tree within the
> viewer? I cannot get this to happen in the viewer or via the code. Also i
> cannot see this being possible in SQL Server Management Studio.
>
> Forcing a split refers to specifying a variable or characteristic on which
> to
> further split a node (e.g age of customers > 25 years). It is expected
> that
> the node on which a split is forced, will get some child nodes as a
> result. I
> cannot add child nodes to any existing node in the code. And i cannot do
> anything in the Model Viewer. Any help i can get is greatly appreciated.
>
> Thank you!
>

 >> Stay informed about: Forcing splits in a decision tree 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Collation Problem any help - Hello all : My problem is like the following I have an online databse with a latin collation, this database is using ntext and nvarchar values that was with our previous admin ok the problem is in the data is stored should use another collation (the...

Reprocessing a mining model - I'm currently developing a user registration prototype. The aim is to classify certain types of users. However, after the registration I query a decision tree model in Analysis Services with DMX and I want to send the user data into the warehouse to....

Trying to cut down query times - I have a query that is based on two other queries that are based on tables in a database. All of the queries that are used for this final query use grouping and totals. In the application I am making, I need to choose a date range to select the subset....

Update serial number in database - Hi, I want to update specific fields in a existing table in SQL database as below example: L240100001-LG L240100002-LG *serial number is difficult to update one by one L240100003-LG L240100004-LG L240100005-LG change to L240100001-L L240100002-L..

Newbie question - I have SQL Server 2000. What add-ons do I need to try data mining, and where do I best go for resources/references?
   Database Help (Home) -> Datamining All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]