Path: ...!local-2.nntp.ord.giganews.com!Xl.tags.giganews.com!local-4.nntp.ord.giganews.com!nntp.earthlink.com!news.earthlink.com.POSTED!not-for-mail
NNTP-Posting-Date: Sun, 03 Nov 2024 01:49:02 +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>
 <vg53kg$3otcc$11@dont-email.me>
From: "186282@ud0s4.net" <186283@ud0s4.net>
Organization: wokiesux
Date: Sat, 2 Nov 2024 21:48:47 -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: <vg53kg$3otcc$11@dont-email.me>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Message-ID: <uX2dnRuXzJsTS7v6nZ2dnZfqnPWdnZ2d@earthlink.com>
Lines: 44
X-Usenet-Provider: http://www.giganews.com
NNTP-Posting-Host: 99.101.150.97
X-Trace: sv3-JqnLsnpLet+mreqhDIj3kCusmCHedqk6aMXm9XHmVZgG4IIca7L8RUSo8Xjz/f2aQf9/3ZQt2Kd4e7O!UdgbGNWN26SsJ8U75KR43DUyScmmyvbcxwc41eIpwPAf3b/0vrt9/K7P5tpuya9AVCJT1nyr5Nkd!uo26A+XIjREAvsnSwFHM
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: 3697

On 11/2/24 7:49 AM, The Natural Philosopher wrote:
> On 02/11/2024 05:19, 186282@ud0s4.net wrote:
>> I don't think there's any distinct "advantage" these
>>    days in either flat-file or MV. Plusses and minuses
>>    for each approach. It's all a matter of how you FEEL
>>    data should be structured/stored.
>>
>>    In short, 'religion'.
> 
> MV? no one seems to know what 'MV' is. Did you invent it?


   ???

   MV = Multi-Valued = Data fields that can hold long
   lists of that KIND of information. If you have a
   fleet-tracking DB then there'd be ONE field saying
   "mileage" and likely another for "fuel-added" and
   they'd just be added-to over time. The record for
   that vehicle is read all-at-once, rather than there
   being dozens, hundreds, of records for said vehicle
   every time it was fueled-up.

> Insofar as data storage goes there are considerable advantages to a 
> normalised database with indices et al.
> 
> It is not a religious choice.

   Ummm ... I'd still say so.

   MV DBs can also have indexes BTW.

> The religion comes in with supporters who have been told that 
> *irrespective of the actual context or uses* it is 'simply the best'
> 
> Rules are for the guidance of wise men and the obedience of fools.

   MV DBs are still sold - sometimes for really serious
   money - so clearly a lot of people/corps DO like that
   way of dealing with data. OpenQM is likely best known
   to Linux users.

https://www.predictiveanalyticstoday.com/top-free-commercial-multivalue-database/