Re: The joy of SQL

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/