News for hackers. Stuff that matters.
Re:Denormalization for Performance: Don't Blame the Relation... by calpaterson on Wednesday October 19, 2016 @10:51AM (#12744280)
No, relations describe facts, not things. Heath's theorem means you can decompose a table/relation that has n non-key attributes into n tables. This is something you have to do for BCNF.

Theoretically it's possible to imagine a normalised relation with 50 columns. In practice a table like that is unusual and suspect (frankly, even in a denormalised design).

Re:Denormalization for Performance: Don't Blame the Relation... by sgeneris on Wednesday October 19, 2016 @01:39PM (#12745866)
There NO relationships whatsoever between normalization and the number of attributes, which are determined by the number of properties that entities have in the real world i.e., the conceptual model.
Re:Denormalization for Performance: Don't Blame the Relation... by calpaterson on Wednesday October 19, 2016 @03:56PM (#12747141)
That is not in conflict with what I said
Re:Denormalization for Performance: Don't Blame the Relation... by sgeneris on Wednesday October 19, 2016 @05:12PM (#12747714)
No. I just thought the clarification was important.
Re:Denormalization for Performance: Don't Blame the Relation... by MustardTiger on Wednesday October 19, 2016 @10:15PM (#12749389)
>No, relations describe facts, not things.

That is impressively pointless pedantry even for HN, well done.

>Theoretically it's possible to imagine a normalised relation with 50 columns

Yes, that would be what I said. "You're wrong because exactly what you said is correct!"

Re:Denormalization for Performance: Don't Blame the Relation... by sgeneris on Thursday October 20, 2016 @02:34PM (#12754933)
No, correctness is not pedantry, except for the ignorant. The database facts are axioms and the facts in query results are theorems -- logical inferences from the axioms. If you don't understand that you have no clue what a relational database is and what a RDBMS does. But hey, you're in the majority.

Any linking of number of columns to normalization is pure nonsense. The only accurate thing that can be said is that if you split a relation into multiple projections, by definition each will have less attributes than the original relation. But this is a triviality and it says nothing about the number of columns in the projected relations.

Re:Denormalization for Performance: Don't Blame the Relation... by MustardTiger on Friday October 21, 2016 @10:15AM (#12760594)
>No, correctness is not pedantry

Pedantry is though. And that's what that entirely pointless post was.

>Any linking of number of columns to normalization is pure nonsense.

That's what I said, that's the point. Don't jump in to a thread you can't be bothered to read.

Re:Denormalization for Performance: Don't Blame the Relation... by sgeneris on Tuesday October 25, 2016 @07:26PM (#12792684)
Pointless to anybody incapable of getting the point, of which there are too many.