Clickstream Data
Ie., building a data-warehouse for web-visits data.
Typical Dimensions
session_dimension ()
page_dimension (page_key, path, item_name)
referer_dimension (referer_key, referer)
Typical Fact Tables
fact_page_events (date_key, time_key, user_key, page_key)
fact_sessions (date_key, session_key)
fact_page_aggregate (date_key, page_key, num_hits)
fact_page_transitions (from_page_key, to_page_key, num_transitionn)
Resources
The Data Webhouse Toolkit Ralph Kimball & Richard Merz.
DB Schemas for NetTracker software. This is a large comprehensive schema: ~50 base tables, and ~30 aggregate tables. [Sep 05]