Path: ...!eternal-september.org!feeder2.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Lawrence D'Oliveiro <ldo@nz.invalid>
Newsgroups: comp.os.linux.misc
Subject: Re: The joy of SQL
Date: Wed, 6 Nov 2024 19:03:50 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 23
Message-ID: <vggeim$27vjt$5@dont-email.me>
References: <pan$96411$d204da43$cc34bb91$1fe98651@linux.rocks>
	<lo2as5Fj476U1@mid.individual.net> <qn_SO.297938$EEm7.187626@fx16.iad>
	<vfif3b$3m055$4@dont-email.me> <y7aTO.203218$WtV9.22893@fx10.iad>
	<vfl257$bic6$4@dont-email.me> <vfmbct$jekn$9@dont-email.me>
	<VjKdnS8_KJVnhIL6nZ2dnZfqnPSdnZ2d@earthlink.com>
	<vfn6b5$rnim$1@dont-email.me> <69FTO.586561$1m96.459888@fx15.iad>
	<IPCcnWfc5tPKV7z6nZ2dnZfqn_QAAAAA@earthlink.com>
	<vfupjk$2d5v5$7@dont-email.me>
	<etqcnYUgc8mBir76nZ2dnZfqnPudnZ2d@earthlink.com>
	<vfv7j2$2j460$1@dont-email.me>
	<D1GdnVpNqtM5zLn6nZ2dnZfqnPWdnZ2d@earthlink.com>
	<vg1kji$33ioi$1@dont-email.me>
	<A7udnUgO7Ye45Ln6nZ2dnZfqn_ednZ2d@earthlink.com>
	<vg3fal$3d77d$6@dont-email.me>
	<lUmdnTqFc8TPK7j6nZ2dnZfqn_GdnZ2d@earthlink.com>
	<vg53kg$3otcc$11@dont-email.me>
	<uX2dnRuXzJsTS7v6nZ2dnZfqnPWdnZ2d@earthlink.com>
	<vg912r$j4vj$4@dont-email.me>
	<SIWdnVp4xI2DuLX6nZ2dnZfqnPudnZ2d@earthlink.com>
	<vgbgm2$14q8q$5@dont-email.me>
	<pJScnYa_tafcXLT6nZ2dnZfqn_SdnZ2d@earthlink.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 06 Nov 2024 20:03:50 +0100 (CET)
Injection-Info: dont-email.me; posting-host="9da3f1ccac00940d5d7a2a8d9ec54262";
	logging-data="2358909"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1/TvTfK6kyXGwqXHlxwuUly"
User-Agent: Pan/0.160 (Toresk; )
Cancel-Lock: sha1:kAA3x4BhndpBkRd/KTzTyqLMMd4=
Bytes: 2624

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.