[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