[Info-vax] Oracle Database vs Oracle/Rdb

[Jan-Erik Söderholm]

Den 2019-06-27 kl. 23:02, skrev Hein RMS van den Heuvel:
> On Tuesday, June 18, 2019 at 11:51:13 AM UTC-4, DTL wrote:
>> Hi, a) has anyone here faced an Rdb/OpenVMS-IA64 to Oracle Database
>> migration in a real time environment driven by Integrity Servers,
>> please? b) Should the Customer worry about response time? Thanks.
> 
> Folks... FOCUS. Look at the original question once more! (Hi Didier!)
> 
> How come this discussion is now all about RMS???
> 
> I know... some things, some folks, never chance. Neil started this time
> with a gratuitous and incorrect comment: "Recall that RDB was developed
> by DEC as a successor to RMS. ".

You are perfectly right there, but...

> If anything RDB was developed as a next
> step from the RDBMS Codasyl database when the relation model and notably
> 'SQL' became relevant in the late 70's...

Note that it took a while before Rdb got support for SQL.
Was it in V3.x something? And if I'm not totaly wrong, SQL
support was an add-on option from the start (extra cost).
Today it is of course the standard interface.

> (Ted Codd, Chris Date,...). It
> was never meant to replace to follow up on RMS. It never had native
> language support like Codasyl (in Cobol) and RMS.
> 
> Anyway, it is best to probe for the reasons to move a little more.
> 
> If the reason is 'access' then please consider that RDB offers ODBC and
> OCI API's and to a large degree can be indistinguishable from
> Oracle-Oracle when called from the outside so to speak.
> 
> If the reason is local production support, maintenance, backup,
> recovery, training, well that may indeed be harder and harder to come
> by. The RDB product is still great, and needs only minimal handholding,
> but who is around to admit to still know about it now, and who will be
> there in 5 years?
> 
> Surely it is easier to find (or train) 'regular' Oracle support and
> operational folks, but if/when they move why move to Oracle at all?
> Money to burn?
> 
> If Oracle is somehow magically desirable/required then, as much as I
> care for OpenVMS, I would recommend moving to some Linux X64 platform.
> 
> From a performance perspective, RDb on OpenVMS is probably, but not
> certainly, superior to Oracle-Oracle. They'll probably need more
> capacity (Memory, CPU) to run Oracle-Oracle with similar performance.
> 
> Good luck!
>