Showing posts with label model. Show all posts
Showing posts with label model. Show all posts

Saturday, February 25, 2012

Rule of thumb about number of attributes and data points?

This is a general question about data modeling. I'm more curious than anything else.

There is much talk about over-training data model, and I'm sure there are under training as well. As a rule of thumb, depending on the algorithm, what is a good ratio of attributes vs data points?

-Young K

Overtraining basically means that you have a model that fit your training data very well. But the model performs very badly on unseen data. For example, if you are training a decision tree, the alogrithm you use may generate a decision tree to fit your training data perfectly. This can be easily achived by keep creating split until each node only contains data points from one sepcific class. In general, this kind of decision does not generalize well on new data. Let's use an extreme case, say, you wish to predict the weather. You have collected the weather data of the past 10 years. And you accidently choose date as input, and the Decision Tree algorithm generate a tree like this:

date

|

-

| |

Nov 15, 2006 ... Nov 15, 2005 ...

| |

Rainny Sunny

This tree is 100% correct on historical data, but totally useless on predict weather data.

Basically, Over training is a common issue for all algorithms, and a lot of techniques have been applied to reduce to risk of overtraining. The most common traditional one is Occam's razor, which prefer to use simpler models. More recently, Bagging and Boosting are also commonly used to address overtraining problem.

In pratical application, you can validate whether or not your model is overfitting by reserving part of your data as indepent testing, and only use the remaining data to train your model, while validate the accuracy of your model with the testing data.

As to the ratio of attribute number vs data points, there is no absolute requirement, although most algorithms perform better with larger training data.

Good luck,

Rule of thumb about number of attributes and data points?

This is a general question about data modeling. I'm more curious than anything else.

There is much talk about over-training data model, and I'm sure there are under training as well. As a rule of thumb, depending on the algorithm, what is a good ratio of attributes vs data points?

-Young K

Overtraining basically means that you have a model that fit your training data very well. But the model performs very badly on unseen data. For example, if you are training a decision tree, the alogrithm you use may generate a decision tree to fit your training data perfectly. This can be easily achived by keep creating split until each node only contains data points from one sepcific class. In general, this kind of decision does not generalize well on new data. Let's use an extreme case, say, you wish to predict the weather. You have collected the weather data of the past 10 years. And you accidently choose date as input, and the Decision Tree algorithm generate a tree like this:

date

|

-

| |

Nov 15, 2006 ... Nov 15, 2005 ...

| |

Rainny Sunny

This tree is 100% correct on historical data, but totally useless on predict weather data.

Basically, Over training is a common issue for all algorithms, and a lot of techniques have been applied to reduce to risk of overtraining. The most common traditional one is Occam's razor, which prefer to use simpler models. More recently, Bagging and Boosting are also commonly used to address overtraining problem.

In pratical application, you can validate whether or not your model is overfitting by reserving part of your data as indepent testing, and only use the remaining data to train your model, while validate the accuracy of your model with the testing data.

As to the ratio of attribute number vs data points, there is no absolute requirement, although most algorithms perform better with larger training data.

Good luck,

|||Does SQLServer 2005 have any support for boosting or bagging?
|||SQL Server doesn't have built in support for Bagging and Boosting. One way you can determine "how much" data you need for your particular problem is to reserve a test set and then create models with different amounts on training data. For example 1000, 2000, 4000, 8000, 16000, etc. cases. Graph the accuracy results of the models and see where the accuracy "flattens out". The point where accuracy stops increasing with additional data is the "ideal" amount of data for that particular problem.

Rule of thumb about number of attributes and data points?

This is a general question about data modeling. I'm more curious than anything else.

There is much talk about over-training data model, and I'm sure there are under training as well. As a rule of thumb, depending on the algorithm, what is a good ratio of attributes vs data points?

-Young K

Overtraining basically means that you have a model that fit your training data very well. But the model performs very badly on unseen data. For example, if you are training a decision tree, the alogrithm you use may generate a decision tree to fit your training data perfectly. This can be easily achived by keep creating split until each node only contains data points from one sepcific class. In general, this kind of decision does not generalize well on new data. Let's use an extreme case, say, you wish to predict the weather. You have collected the weather data of the past 10 years. And you accidently choose date as input, and the Decision Tree algorithm generate a tree like this:

date

|

-

| |

Nov 15, 2006 ... Nov 15, 2005 ...

| |

Rainny Sunny

This tree is 100% correct on historical data, but totally useless on predict weather data.

Basically, Over training is a common issue for all algorithms, and a lot of techniques have been applied to reduce to risk of overtraining. The most common traditional one is Occam's razor, which prefer to use simpler models. More recently, Bagging and Boosting are also commonly used to address overtraining problem.

In pratical application, you can validate whether or not your model is overfitting by reserving part of your data as indepent testing, and only use the remaining data to train your model, while validate the accuracy of your model with the testing data.

As to the ratio of attribute number vs data points, there is no absolute requirement, although most algorithms perform better with larger training data.

Good luck,

|||Does SQLServer 2005 have any support for boosting or bagging?
|||SQL Server doesn't have built in support for Bagging and Boosting. One way you can determine "how much" data you need for your particular problem is to reserve a test set and then create models with different amounts on training data. For example 1000, 2000, 4000, 8000, 16000, etc. cases. Graph the accuracy results of the models and see where the accuracy "flattens out". The point where accuracy stops increasing with additional data is the "ideal" amount of data for that particular problem.

Tuesday, February 21, 2012

RSS Relational Model?

I'm fishing for a model somebody may choose to give me or refer to
documentation for a schema that documents a design for storing RSS and/or
ATOM feeds.
<%= Clinton Gallagher
Not exactly a relational model, but it can give you some ideas "XML to SQL:
Using SQLXML Bulkload in the .NET Framework"
http://msdn.microsoft.com/library/de...exchsqlxml.asp
Cristian Lefter, SQL Server MVP
"clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
> I'm fishing for a model somebody may choose to give me or refer to
> documentation for a schema that documents a design for storing RSS and/or
> ATOM feeds.
> <%= Clinton Gallagher
>
|||Good starting point.
<%= Clinton Gallagher
"Cristian Lefter" <nospam_CristianLefter@.hotmail.com> wrote in message
news:u3%23OBNZVFHA.612@.TK2MSFTNGP12.phx.gbl...
> Not exactly a relational model, but it can give you some ideas "XML to
> SQL: Using SQLXML Bulkload in the .NET Framework"
> http://msdn.microsoft.com/library/de...exchsqlxml.asp
> Cristian Lefter, SQL Server MVP
> "clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
> news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
>

RSS Relational Model?

I'm fishing for a model somebody may choose to give me or refer to
documentation for a schema that documents a design for storing RSS and/or
ATOM feeds.
<%= Clinton GallagherNot exactly a relational model, but it can give you some ideas "XML to SQL:
Using SQLXML Bulkload in the .NET Framework"
http://msdn.microsoft.com/library/d... />
sqlxml.asp
Cristian Lefter, SQL Server MVP
"clintonG" < csgallagher@.REMOVETHISTEXTmetromilwaukee
.com> wrote in message
news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
> I'm fishing for a model somebody may choose to give me or refer to
> documentation for a schema that documents a design for storing RSS and/or
> ATOM feeds.
> <%= Clinton Gallagher
>|||Good starting point.
<%= Clinton Gallagher
"Cristian Lefter" <nospam_CristianLefter@.hotmail.com> wrote in message
news:u3%23OBNZVFHA.612@.TK2MSFTNGP12.phx.gbl...
> Not exactly a relational model, but it can give you some ideas "XML to
> SQL: Using SQLXML Bulkload in the .NET Framework"
> http://msdn.microsoft.com/library/d...>
chsqlxml.asp
> Cristian Lefter, SQL Server MVP
> "clintonG" < csgallagher@.REMOVETHISTEXTmetromilwaukee
.com> wrote in message
> news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
>

RSS Relational Model?

I'm fishing for a model somebody may choose to give me or refer to
documentation for a schema that documents a design for storing RSS and/or
ATOM feeds.
<%= Clinton GallagherNot exactly a relational model, but it can give you some ideas "XML to SQL:
Using SQLXML Bulkload in the .NET Framework"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp
Cristian Lefter, SQL Server MVP
"clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
> I'm fishing for a model somebody may choose to give me or refer to
> documentation for a schema that documents a design for storing RSS and/or
> ATOM feeds.
> <%= Clinton Gallagher
>|||Good starting point.
<%= Clinton Gallagher
"Cristian Lefter" <nospam_CristianLefter@.hotmail.com> wrote in message
news:u3%23OBNZVFHA.612@.TK2MSFTNGP12.phx.gbl...
> Not exactly a relational model, but it can give you some ideas "XML to
> SQL: Using SQLXML Bulkload in the .NET Framework"
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/exchsqlxml.asp
> Cristian Lefter, SQL Server MVP
> "clintonG" <csgallagher@.REMOVETHISTEXTmetromilwaukee.com> wrote in message
> news:%23LfOhmYVFHA.2796@.TK2MSFTNGP09.phx.gbl...
>> I'm fishing for a model somebody may choose to give me or refer to
>> documentation for a schema that documents a design for storing RSS and/or
>> ATOM feeds.
>> <%= Clinton Gallagher
>

RSS or Atom Relational Model?

I'm fishing for a model somebody may choose to give me or refer to
documentation for a schema that documents a design for storing RSS and/or
ATOM feeds.
<%= Clinton GallagherThis is an article about using xml bulkload to store RSS feeds in a database
.
It includes a simple annotated XSD schema.
http://msdn.microsoft.com/xml/build.../exchsqlxml.asp
It may be what you are looking for.
-Todd
"clintonG" wrote:

> I'm fishing for a model somebody may choose to give me or refer to
> documentation for a schema that documents a design for storing RSS and/or
> ATOM feeds.
> <%= Clinton Gallagher
>
>|||Thanks Todd. That's a good start.
<%= Clinton Gallagher
"Todd Pfleiger [MSFT]" <ToddPfleigerMSFT@.discussions.microsoft.com> wrote in
message news:66D653E6-E1CC-4C64-86DE-D7F3441906A5@.microsoft.com...
> This is an article about using xml bulkload to store RSS feeds in a
> database.
> It includes a simple annotated XSD schema.
> http://msdn.microsoft.com/xml/build.../exchsqlxml.asp
> It may be what you are looking for.
> -Todd
> "clintonG" wrote:
>

RSS or Atom Relational Model?

I'm fishing for a model somebody may choose to give me or refer to
documentation for a schema that documents a design for storing RSS and/or
ATOM feeds.
<%= Clinton Gallagher
This is an article about using xml bulkload to store RSS feeds in a database.
It includes a simple annotated XSD schema.
http://msdn.microsoft.com/xml/buildi...exchsqlxml.asp
It may be what you are looking for.
-Todd
"clintonG" wrote:

> I'm fishing for a model somebody may choose to give me or refer to
> documentation for a schema that documents a design for storing RSS and/or
> ATOM feeds.
> <%= Clinton Gallagher
>
>
|||Thanks Todd. That's a good start.
<%= Clinton Gallagher
"Todd Pfleiger [MSFT]" <ToddPfleigerMSFT@.discussions.microsoft.com> wrote in
message news:66D653E6-E1CC-4C64-86DE-D7F3441906A5@.microsoft.com...[vbcol=seagreen]
> This is an article about using xml bulkload to store RSS feeds in a
> database.
> It includes a simple annotated XSD schema.
> http://msdn.microsoft.com/xml/buildi...exchsqlxml.asp
> It may be what you are looking for.
> -Todd
> "clintonG" wrote: