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

Is this possible?

 
   Database Help (Home) -> Datamining RSS
Next:  creating a view with an incremented field.  
Author Message
Lin Jones

External


Since: Nov 25, 2003
Posts: 1



(Msg. 1) Posted: Tue Nov 25, 2003 2:44 pm
Post subject: Is this possible?
Archived from groups: microsoft>public>sqlserver>datamining (more info?)

I am trying to create a mining model so I can predict a
shipment date based on past purchases. Can I have the
shpment date be the predictable column or is that
considered continuous and will not work? Also, I am a
bit confused as to how I would tie together the
purchases, shipments and products tables to reach that
outcome. Any help would be apprciated.

Thanks
Lin

 >> Stay informed about: Is this possible? 
Back to top
Login to vote
Jamie MacLennan 1

External


Since: Aug 24, 2003
Posts: 54



(Msg. 2) Posted: Tue Nov 25, 2003 4:58 pm
Post subject: Re: Is this possible? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

This sounds similar to what ComputerFleet has accomplished in predicting a
return time on rentals. You can see their case study here:
<a style='text-decoration: underline;' href="http://www.microsoft.com/resources/casestudies/CaseStudy.asp?CaseStudyID=14375" target="_blank">http://www.microsoft.com/resources/casestudies/CaseStudy.asp?CaseStudyID=14375</a>

In general I think you want to approach the problem to predict the "days to
ship" rather than the exact "ship date." I.e. "ship date" - "order date".
This number can be discretized and predicted. Your prediction results will
be a range of days representing the time it will take for an order to ship.

Regarding your other questions, I would need more information on your schema
to advise

-Jamie
"Lin Jones" <anonymous.TakeThisOut@discussions.microsoft.com> wrote in message
news:038401c3b38c$96fafb90$a301280a@phx.gbl...
 > I am trying to create a mining model so I can predict a
 > shipment date based on past purchases. Can I have the
 > shpment date be the predictable column or is that
 > considered continuous and will not work? Also, I am a
 > bit confused as to how I would tie together the
 > purchases, shipments and products tables to reach that
 > outcome. Any help would be apprciated.
 >
 > Thanks
 > Lin<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Is this possible? 
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) (change)
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 ]