News for hackers. Stuff that matters.
Re:I Stopped Worrying and Learned to Love Denormalized Tables by teej on Friday May 12, 2023 @10:46PM (#35924987)
It’s complicated. Databases have entities called “views” and “materialized views” that have a specific meaning in that ecosystem. dbt let’s you define views in the abstract sense, but they’re implemented using a variety of different database primitives, like tables, temp tables, common table expressions, and views. dbt calls them “models”.
Re:I Stopped Worrying and Learned to Love Denormalized Tables by PeeMcGee on Friday May 12, 2023 @11:29PM (#35925209)
Sounds like a typical workflow in any BI tool. I wish the author would have taken a moment to explain how Glean is any different.
Re:I Stopped Worrying and Learned to Love Denormalized Tables by roncesvalles on Saturday May 13, 2023 @01:07AM (#35925754)
The debate over normalized/denormalized has to do with how authoritative online data should be stored. What you do with derived datasets is not really contentious; do whatever you want.