[Info-vax] VMS Software: New US Mailing Address

Arne Vajhøj arne at vajhoej.dk
Fri Oct 14 08:19:51 EDT 2022


On 10/13/2022 10:05 PM, Richard Maher wrote:
>   IIRC Oracle/Rdb is the only RDBMS that executes in the context of the 
> calling process through DSRI. Sounds pretty efficient. Dynamic qyuery 
> optimization notwithstanding.

There are lots of databases executing in process context:
SQLite, Firebird, H2, HSQLDB, good old (or bad old depending on view)
Access.

Rdb uniqueness is:
- it supports both executing in process context (embedded SQL,
   SQL modules, JDBC native driver) and executing in separate
   server (JDBC thin driver, SQL Services API, ODBC)
- even when executing in process context there are still some
   central administrative processes running
- it is geared towards large usage while traditional embedded
   databases are really geared towards small usage or test

Arne




More information about the Info-vax mailing list