User to User subscription model

View previous topic View next topic Go down

User to User subscription model

Post  veskojl on Mon Mar 12, 2012 6:47 pm

I'm modeling a web forum DWH and need to track the followers of a given user.
I'm wavering between factless fact implemented like periodic snapshot or simple factless fact with a flag for active/inactive?
Truncate and reload also sounds like an option, so the problem here is too many choices I have.

Anyone with experience/idea on something like this?

veskojl

Posts : 11
Join date : 2011-07-21

View user profile

Back to top Go down

Re: User to User subscription model

Post  ngalemmo on Mon Mar 12, 2012 7:28 pm

You have a fact table that tracks views. Visitor, page, date, time, subject viewed, and so on. One measure you may want to consider it time spent viewing the page. It's easy to derive and load, but can be a bottleneck when dealing with very large volumes, and it cannot be calculated for the last page viewed, but it's sometimes useful for giving a rough idea of the attention of the visitor.

One other thing, store the timestamp in standard time (Zulu, GMT, or whatever you want to call it) as it doesn't have seasonal and/or political adjustments, which would cause sequencing problems at some times of the year.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum