Storing RSS web feeds in the db?

Have any best practices been learned to store (aggregate) RSS web feeds in
the db? Shred or XML data type or what? Any design documents I might be
referenced to? Which coding methodology to "get er done?"

I think the answer depends on what you want to do with the aggregated feed.
As far as storage is concerned, it is a good idea to store as an XML
document. But if this document is frequently queried/searched, then
shredding the data to relational tables might be a better choice.

--
Jacob Sebastian
SQL Server MVP
http://www.sqlserverandxml.com

"Hillbilly" <somebody@somewhere.com> wrote in message
news:enAfgdDEJHA.1280@TK2MSFTNGP02.phx.gbl...
> Have any best practices been learned to store (aggregate) RSS web feeds in
> the db? Shred or XML data type or what? Any design documents I might be
> referenced to? Which coding methodology to "get er done?"

I seem to have a situation that calls for D.) All of the Above.

Any comments on query of data in XML files when they are on the file system?


"Jacob Sebastian" <jacob.reliancesp@gmail.com> wrote in message
news:296468CE-A902-4156-9ED4-5BB500025F98@microsoft.com...
>I think the answer depends on what you want to do with the aggregated feed.
>As far as storage is concerned, it is a good idea to store as an XML
>document. But if this document is frequently queried/searched, then
>shredding the data to relational tables might be a better choice.
>
> --
> Jacob Sebastian
> SQL Server MVP
> http://www.sqlserverandxml.com
>
> "Hillbilly" <somebody@somewhere.com> wrote in message
> news:enAfgdDEJHA.1280@TK2MSFTNGP02.phx.gbl...
>> Have any best practices been learned to store (aggregate) RSS web feeds
>> in the db? Shred or XML data type or what? Any design documents I might
>> be referenced to? Which coding methodology to "get er done?"
>