Tracking pageviews and displaying related data

Posted by zeky on Stack Overflow See other posts from Stack Overflow or by zeky
Published on 2011-01-02T00:49:56Z Indexed on 2011/01/02 0:54 UTC
Read the original article Hit count: 266

I want track which articles a user read on a website.

Then with that data, be able to know:

1) - top N articles read in the last hour/day/week/month

2) - show recommendations ("users who read this, also read that")

3) - same as (1), but for a specific section on the site

Since the site has high traffic ( >1M views/day) i can't use a RDBMS for this.

I started to look at NoSQL (cassandra specifically) and since it's all new to me i'm not sure it's what i need or not.

I'm possitive i'm not the first one who needs something like this but couldn't find links/articles giving me pointers on how to do something like this. Is NoSQL the best aproach? Any tips on the data model?

Thanks.

© Stack Overflow or respective owner

Related posts about nosql

Related posts about tracking