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@programming.dev
    link
    fedilink
    English
    arrow-up
    3
    ·
    11 months 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.