News for hackers. Stuff that matters.
Re:I Stopped Worrying and Learned to Love Denormalized Tables by makeitdouble on Friday May 12, 2023 @10:21PM (#35924841)
It sounds like the author is calling a kind of materialized/persisted view "denormalized tables". The actual DB tables stay untouched and fully normalized.

It sure makes sense to love them, views are great. I don't know why they need a new name.

> Transformation tools such as dbt (Data Build Tool) have revolutionized the management and maintenance of denormalized tables. With dbt, we can establish clear relationships between table abstractions, create denormalized analytics datasets on top of them, and ensure data integrity and consistency with tests.

Re:I Stopped Worrying and Learned to Love Denormalized Tables by binkHN on Friday May 12, 2023 @10:40PM (#35924961)
Fully concur with this! It succinctly sums up the article! There really isn't much meat there!
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.
Re:I Stopped Worrying and Learned to Love Denormalized Tables by hn_throawlles on Friday May 12, 2023 @11:19PM (#35925145)
> It sure makes sense to love them, views are great. I don't know why they need a new name.

in very many cases, old things get new names so that more people can share in the claim that they invented what has been in fact merely re-invented

Re:I Stopped Worrying and Learned to Love Denormalized Tables by tremon on Saturday May 13, 2023 @08:14AM (#35927617)
merely re-invented

*rediscovered

Re:I Stopped Worrying and Learned to Love Denormalized Tables by mejutoco on Saturday May 13, 2023 @08:45AM (#35927848)
As a thought experiment. Was the original thing invented or discovered?

Many things are re-invented/rediscovered from first principles. In maths, some people prefer to think maths are created, and some prefer to think in terms of discovering/uncovering sth that was already there.

Re:I Stopped Worrying and Learned to Love Denormalized Tables by OJFord on Saturday May 13, 2023 @07:15AM (#35927305)
There was me assuming it was about normal form, you know, what everyone else means when they talk about 'normalising' in a database context...

Which even more confusingly almost applies but the opposite way around:

> create denormalized analytics datasets on top of them

A common pattern is to have source data 'warehoused' or whatever you want to call it, and then build your, er, normalised schema on top of that.

Re:I Stopped Worrying and Learned to Love Denormalized Tables by factormeta on Saturday May 13, 2023 @08:59AM (#35927953)
One of main reason to normalize data is aim to eliminate duplication, and find "the source data" by properly designing the relationships of tables.
Re:I Stopped Worrying and Learned to Love Denormalized Tables by OJFord on Saturday May 13, 2023 @09:09AM (#35928013)
By source data I meant as originally supplied, that's perhaps not normal and which you have no control over.