views:

38

answers:

1

Hi guys,

I have a portal that fetches news from hundreds of resources around the web. How can I be able to use these data to determine trending stories ?

Any ideas would be highly appreciated.

Thanks.

A: 
  1. Get a good dictionary with all kinds of words and their forms.
  2. Split the words in a news story and collect statistics on those words.
  3. Group stories by their word statistics signature and closeness in date-time space.
Denis Valeev
Is this the technique twitter, or any other news site uses ? Does Sql Server 2008 Data mining can help me in this ? Thanks.
Joseph Ghassan
@Joseph Ghassan If you know SSAS then go for it, it's much more powerful than any feeble attempts to solve this problem in plain tsql.
Denis Valeev
Do you know active community about SSAS, or some online tutorials? thanks.
Joseph Ghassan