Sampling data set via Integration Services data flow for data mining models without saving train

Hi, all here,

Thank you very much for your kind attention.

I am wondering if it is possible to use SSIS to sample data set to training set and test set directly to my data mining models without saving them somewhere as occupying too much space? Really need guidance for that.

Thank you very much in advance for any help.

With best regards,

Yours sincerely,

Does the Data Mining Model Training destination offer any solution?

"The Data Mining Model Training destination trains data mining models by passing the data that the destination receives through the data mining model algorithms. Multiple data mining models can be trained by one destination if the models are built on the same data mining structure."

Data Mining Model Training Destination
(http://msdn2.microsoft.com/en-us/library/6bc8cbe2-46af-4f7b-93d6-86779313c9d7.aspx)

|||

Hi, Darren,

Thank you very much for your very helpful guidance.

So it means that If I want to feed data into my mining models for different mining structures, I will have to create different data flows for that goal?

Thank you very much in advance for your further guidance and advices.

With best regards,

Yours sincerely,

|||That is the way I read the documentation. Why not give it a try?|||

Hiya, thank you very much for your guidance. Have got it done.

With best regards,

Yours sincerely,

Sampling data set via Integration Services data flow for data mining models without saving t

Hi, all here,

Thank you very much for your kind attention.

I am wondering if it is possible to use SSIS to sample data set to training set and test set directly to my data mining models without saving them somewhere as occupying too much space? Really need guidance for that.

Thank you very much in advance for any help.

With best regards,

Yours sincerely,

Does the Data Mining Model Training destination offer any solution?

"The Data Mining Model Training destination trains data mining models by passing the data that the destination receives through the data mining model algorithms. Multiple data mining models can be trained by one destination if the models are built on the same data mining structure."

Data Mining Model Training Destination
(http://msdn2.microsoft.com/en-us/library/6bc8cbe2-46af-4f7b-93d6-86779313c9d7.aspx)

|||

Hi, Darren,

Thank you very much for your very helpful guidance.

So it means that If I want to feed data into my mining models for different mining structures, I will have to create different data flows for that goal?

Thank you very much in advance for your further guidance and advices.

With best regards,

Yours sincerely,

|||That is the way I read the documentation. Why not give it a try?|||

Hiya, thank you very much for your guidance. Have got it done.

With best regards,

Yours sincerely,

Sample databases for data mining

Hello

I'm looking for sample database for data mining in SQL Server 2005. In my project I need to use all algorithms provided by SQL Server 2005. I know that we have "SQL Server 2005 Samples and Sample Databases" on microsoft.com site, but there are only AdventureWorks data sets. I need sth less popular, but similar.

I have found http://www.kdnuggets.com/datasets/index.html and others, but I don't see data sets good for multidimensional analysis.

The origin of data may be natural or artificial, it doesn't matter.
I don't have to generate my own data, because I had to discover new knowledge, that will be surprising to me.

Any help would be appreciated.
Thanks in advance.

(sorry for my English)

There are public datasets available on many sites including the UN- they may be interesting.

http://unstats.un.org/unsd/demographic/products/socind/default.htm

And there are still samples available for SQL Server 2000 which may also be useful. You need to know how to install them for 2005. There are some notes on that here.

Sample databases for data mining

Hello

I'm looking for sample database for data mining in SQL Server 2005. In my project I need to use all algorithms provided by SQL Server 2005. I know that we have "SQL Server 2005 Samples and Sample Databases" on microsoft.com site, but there are only AdventureWorks data sets. I need sth less popular, but similar.

I have found http://www.kdnuggets.com/datasets/index.html and others, but I don't see data sets good for multidimensional analysis.

The origin of data may be natural or artificial, it doesn't matter.
I don't have to generate my own data, because I had to discover new knowledge, that will be surprising to me.

Any help would be appreciated.
Thanks in advance.

(sorry for my English)

There are public datasets available on many sites including the UN- they may be interesting.

http://unstats.un.org/unsd/demographic/products/socind/default.htm

And there are still samples available for SQL Server 2000 which may also be useful. You need to know how to install them for 2005. There are some notes on that here.

Sample Data for mining

hi, i am bit new in the field of data warehousing and data mining but catching up fast. I am in the last year of BS(Computer Science) and intend to do a project on a Business Intelligence but i was wondering can i get a sample dummy data for my work is that any way possible?

Try here http://kdd.ics.uci.edu/

Also try the movies data set at www.sqlserverdatamining.com