Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

User to User subscription model

2 posters

Go down

User to User subscription model Empty User to User subscription model

Post  veskojl 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

Back to top Go down

User to User subscription model Empty Re: User to User subscription model

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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