User to User subscription model
2 posters
Page 1 of 1
User to User subscription model
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?
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
Re: User to User subscription model
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.
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.
Similar topics
» How do I model Bundled Product Subscription Facts??
» How to model a generic user
» Customer - User Model
» How to best model online User Session
» User Access Control + Dimensional Model
» How to model a generic user
» Customer - User Model
» How to best model online User Session
» User Access Control + Dimensional Model
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum