[Info-vax] Oracle Database vs Oracle/Rdb

[Arne Vajhøj]

On 6/24/2019 8:44 AM, Jan-Erik Söderholm wrote:
> Den 2019-06-24 kl. 13:39, skrev Neil Rieck:
>> http://neilrieck.net/demo_vms_html/openvms_demo_index.html#hybrid_basic_c_mariadb 
>>
>>  This shows the hoops anyone will need to go through if something like
>> an RDB pre-compiler is not available.
>>
> 
> Many tools today (in particulary scripting tools like Python, PHP and
> so on) has a form of embedded SQL that is not pre-compiled. The raw
> SQL is simply sent to the DB enginge for compilation and execution.
> 
> In the Rdb case, the pre-compiler does all the SQL compilation and calls
> to the relevant Rdb runtime routines are instered into the source code
> and a lot of glue-code is alrady (pre-) compiled into object/machine code.

Most modern database API's whether script language or compiled
language send SQL to the database.

What the database usually does is that it does some stuff with the SQL
and cache the result for later usage.

Arne