Sujet : Re: The joy of SQL
De : ldo (at) *nospam* nz.invalid (Lawrence D'Oliveiro)
Groupes : comp.os.linux.miscDate : 06. Nov 2024, 20:03:50
Autres entêtes
Organisation : A noiseless patient Spider
Message-ID : <vggeim$27vjt$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 Tue, 5 Nov 2024 01:54:56 -0500,
186282@ud0s4.net wrote:
On 11/4/24 5:09 PM, Lawrence D'Oliveiro wrote:
>
On Sun, 3 Nov 2024 20:36:29 -0500, 186282@ud0s4.net wrote:
Why join when the MV approach keeps yer data in an already-joined
state ???
Because the MV approach makes that hard to maintain.
Never noticed that ...
What kind of database doesn’t need updating?
You CAN download OpenQM if you want, see how the MV approach can be
useful.
LDAP has multi-valued attributes. But then, it has a different model where
all the records are in the same table, and the primary key has a
hierarchical form. And it has a “modify” operation that can add/remove
individual values for an attribute.
Re: The joy of SQL
Re: The joy of SQL