Sujet : Re: The joy of SQL
De : ldo (at) *nospam* nz.invalid (Lawrence D'Oliveiro)
Groupes : comp.os.linux.miscDate : 04. Nov 2024, 00:32:22
Autres entêtes
Organisation : A noiseless patient Spider
Message-ID : <vg9166$j4vj$5@dont-email.me>
References : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
User-Agent : Pan/0.160 (Toresk; )
On Sat, 2 Nov 2024 21:51:27 -0400,
186282@ud0s4.net wrote:
On 11/2/24 8:15 PM, Lawrence D'Oliveiro wrote:
>
On Sat, 2 Nov 2024 03:21:40 -0400, 186282@ud0s4.net wrote:
IMHO, MV is still the 'best', 'most logical', 'most compact'.
Except when you need to do updates.
As said, that's NOT as complex or resource-consuming as you believe.
It’s quite complicated: you have to retrieve all the current values, add
the new ones, then put them all back. Much easier if you can just add the
new ones, or delete the old ones, directly.
This is why normalization was invented. And First Normal Form is just the
first step along that road: higher orders of normalization also simplify
updates in additional situations, involving more subtle functional
dependencies among fields.
All this was worked out when you were still a babe in arms.
Re: The joy of SQL