Unified Star Schema

3 years ago by Andy to c/dataengineering

Invented by F. Puppini and promoted by B. Inmon it pretends to be a revolution in Self Service BI

Hi all,

I was recently reading about the Unified Star Schema and the Puppini Bridge. I’m curious whether anyone here has experience with it and what their thoughts are.

TIA

Sl00k 3 points 3 years ago

Haven't heard of this before, but I've basically implemented it in my own work and it's worked out great.

I believe implementing facts and dimensions via a star schema is still very useful and serves as a great modeling format, however there's definitely times where my downstream users need a single OBT type table. Ex. CSMs use a tool fed by data warehouse but none of them know SQL, so we feed a single "bridges" table to them that includes everything.

One interesting flaw with my implementation I've found, my users are looking for all the data under the sun, and I wasn't previously prepared originally and had to add a lot of columns over time. This grew into a massive mess that needs to be remodeled via multiple OBT type bridge tables. It's very easy to just throw everything in these tables and lose all structure.

path: 0 2072893, hotness: undefined, score: 3, children: 0
dataengineering

@lemmy.ml

login for more options
346
15
1

News and discussion on Data Engineering topics

go to feed...