Path: ...!Xl.tags.giganews.com!local-4.nntp.ord.giganews.com!nntp.earthlink.com!news.earthlink.com.POSTED!not-for-mail
NNTP-Posting-Date: Sat, 02 Nov 2024 07:21:41 +0000
Subject: Re: The joy of SQL
Newsgroups: comp.os.linux.misc
References: <pan$96411$d204da43$cc34bb91$1fe98651@linux.rocks>
 <vfcptl$2hjp4$1@dont-email.me>
 <CCadnQ4B-oXSboT6nZ2dnZfqnPidnZ2d@earthlink.com>
 <vfebuf$2pkdl$4@dont-email.me>
 <Os6dnedZ6uqxbof6nZ2dnZfqn_WdnZ2d@earthlink.com>
 <nCQSO.297925$EEm7.62385@fx16.iad> <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>
 <vg4g89$3m51s$1@dont-email.me>
From: "186282@ud0s4.net" <186283@ud0s4.net>
Organization: wokiesux
Date: Sat, 2 Nov 2024 03:21:40 -0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.13.0
MIME-Version: 1.0
In-Reply-To: <vg4g89$3m51s$1@dont-email.me>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Message-ID: <9YydncI2l-2YTrj6nZ2dnZfqnPadnZ2d@earthlink.com>
Lines: 76
X-Usenet-Provider: http://www.giganews.com
NNTP-Posting-Host: 99.101.150.97
X-Trace: sv3-gx5/3k653/g+59WmgFw43epdodT+Vt6arI2blq1LJv0PafUlxDionwlDkFscWZMZhAFqIOm0g3iKsxv!AdMnYeBN1cc5wE1x9QU6JWizUgaCNfo/SUfJlFmaF+izmYIGkPoXukPGa3cs/f4f2gkuklR4frEH!x/xWYCHChvIe8sVMSApi
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
Bytes: 4801

On 11/2/24 2:18 AM, Lawrence D'Oliveiro wrote:
> On Sat, 2 Nov 2024 01:19:13 -0400, 186282@ud0s4.net wrote:
> 
>> On 11/1/24 4:56 PM, Lawrence D'Oliveiro wrote:
>>>
>>> On Fri, 1 Nov 2024 02:45:56 -0400, 186282@ud0s4.net wrote:
>>>
>>>> On 11/1/24 12:14 AM, Lawrence D'Oliveiro wrote:
>>>>>
>>>>> On Thu, 31 Oct 2024 23:57:11 -0400, 186282@ud0s4.net wrote:
>>>>>
>>>>>> On 10/31/24 2:20 AM, Lawrence D'Oliveiro wrote:
>>>>>>
>>>>>>> On Thu, 31 Oct 2024 01:35:23 -0400, 186282@ud0s4.net wrote:
>>>>>>>
>>>>>>>> On 10/30/24 10:21 PM, Lawrence D'Oliveiro wrote:
>>>>>>>>
>>>>>>>>> The trouble with unnormalized fields is: how do you do updates?
>>>>>>>>> You have to delete all the values and insert them all again.
>>>>>>>>
>>>>>>>> Updates CAN be annoying.
>>>>>>>
>>>>>>> Easy way to remove the annoyance: normalize your field values.
>>>>>>
>>>>>> But the 'easy' way removes some of your flexibility and reasoning
>>>>>> ability in the process.
>>>>>
>>>>> No it doesn’t. Prove me wrong.
>>>>
>>>> This can't be "proven" per-se ... it's a matter of how you "feel"
>>>> about how data should be represented to best effect/clarity. Call it
>>>> 'religion' if you want ...
>>>
>>> “Religion” is when followers are rewarded for believing in doctrine,
>>> not just in the absence of evidence, but directly contrary to the
>>> evidence.
>>>
>>> In other words, I think you’ve just admitted my point.
>>
>> And you just admitted mine  :-)
> 
> The fact of normalized attributes being easier to update isn’t a religious
> issue: it’s a well-established foundation element of database theory.


   I disagree.


> It’s
> the reason why we have first normal form. And subsequent higher normal
> forms impose further restrictions which in their turn make other kinds of
> updates easier.

   Still crusading for your religion I see  :-)

   Do you sell burkha's ?

   IMHO, MV is still the 'best', 'most logical',
   'most compact'.

   You're not gonna convert me to your heresy !  :-)

   Oh wait, have to turn off the hour-long ad for
   Shark vacuum cleaners ... another attempted
   religion ......... all worship Hoover !!!

   You seem obsessed with this word "normal"/"normalized".
   Nothing normal about a mistaken paradigm. It's just
   theological propaganda.

   As said before, at this point, the CPU/Time equation
   between accessing/analyzing/updating flat -vs- MV is
   about nil. One is as good as another from an objective
   standpoint. It's just a matter of "feel", how you think,
   as to which is really "better". I don't care about who
   is "winning", doesn't affect my eval.