Tracking pageviews and displaying related data
- by zeky
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.