This Question have no Text answers yet!

Template DB schema for Web Analytics workload (AWS RedShift) [closed]

By : Howard
Source: Stackoverflow.com
Question!

Are there any existing schema template for general web analytics workload, e.g. similar to Google Analytcis, it probably have at least the following tables

  1. users
  2. sites
  3. requests

Since I don't want to re-invent the wheel, I am looking if any existing well defined schema or good relations modeling is suitable for my need.

Any idea?

Remark: I am running on AWS RedShift, but I think most column oriented database should have similar schema.

By : Howard


Video about Template DB schema for Web Analytics workload (AWS RedShift) [closed]