[Info-vax] CRTL and RMS vs SSIO

[Arne Vajhøj]

On 10/14/2021 8:15 AM, chris wrote:
> On 10/14/21 01:46, Lawrence D’Oliveiro wrote:
>> On Thursday, October 14, 2021 at 9:44:56 AM UTC+13, Dave Froble wrote:
>>> A simple loop processing an RMS file looking in each record in the field
>>> Name for "Dave" can be an open and a couple lines of code.
>>>
>>> Not such a big difference.
>>
>> Even on a single table, SQL allows for ORDER BY clauses so the records 
>> get returned in an order more suited to the application’s needs. And 
>> the ordering can be an expression, not necessary a simple field. Try 
>> doing that in RMS.
>>
>> But beyond that, SQL allows lookups using JOINs on multiple tables, 
>> plus of course subqueries -- try implementing that in RMS!
> 
> I come here to bury Caesar, not to praise him :-) ?. RMS is a Record
> Management System, not a database, not the same thing at all. As a
> foundation, or set of system services, yes, but not the complete
> product.
> 
> Comparing Apples to Oranges is rarely productive...

Here we are not talking about RMS in general, but specifically
about index-sequential files.

VMS index-sequential files are per modern terminology a NoSQL
database of the Key Value Store type.

And the RMS services is the API to that.

Yes a relational database provide a lot
more functionality.

But that is sort of the point. If one can benefit from
any of these extra functionalities (and one does not have a
problem with the HW resource requirements for a relational
database which few will have today) then a relational database
saves writing code.

You pick a product that does more so you have to do less.

Arne