Re: The joy of SQL

Subject	Re: The joy of SQL
Newsgroups	comp.os.linux.misc
References	(20 earlier) <vg912r$j4vj$4@dont-email.me> <SIWdnVp4xI2DuLX6nZ2dnZfqnPudnZ2d@earthlink.com> <vgbgm2$14q8q$5@dont-email.me> <pJScnYa_tafcXLT6nZ2dnZfqn_SdnZ2d@earthlink.com> <vggeim$27vjt$5@dont-email.me>
From	"186282@ud0s4.net" <186283@ud0s4.net>
Organization	wokiesux
Date	2024-11-06 19:07 -0500
Message-ID	<x2udnQJd-vlTmbH6nZ2dnZfqn_adnZ2d@earthlink.com> (permalink)

Show all headers | View raw

On 11/6/24 2:03 PM, Lawrence D'Oliveiro wrote:
> 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?

   That wasn't my point ... just saying that updates
   ain't as difficult as you seem to think.

>> 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.

   LDAP is a kinda lightweight 'DB' - not built to
   be really 'general purpose'.

   PICK ... kinda depends on your POV as to whether
   all records are in one table or not. Easier to
   just think of each record as a long string, with
   delims marking fields/subfields/etc. MV records
   are usually not all THAT long so straight searching
   goes quick but you COULD add a small hash table
   if there were mass quantities of fields/subfields.

   Anyway, get or borrow a MV DB and fool around
   with it yourself.

Back to comp.os.linux.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-30 01:55 -0400
  Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-31 02:21 +0000
    Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-31 01:35 -0400
      Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-31 06:20 +0000
        Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-31 23:57 -0400
          Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-01 04:14 +0000
            Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-01 02:45 -0400
              Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-01 20:56 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 01:19 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-02 06:18 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 03:21 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-03 00:15 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 21:51 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-03 23:32 +0000
                Re: The joy of SQL The Natural Philosopher <tnp@invalid.invalid> - 2024-11-02 11:49 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 21:48 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-03 23:30 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-03 20:36 -0500
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-04 22:09 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-05 01:54 -0500
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-06 19:03 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-06 19:07 -0500
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-07 03:14 +0000

csiph-web