[Info-vax] Oracle Database vs Oracle/Rdb

[Jan-Erik Söderholm]

Den 2019-06-25 kl. 02:19, skrev 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.

Yes, most DBs has a central "engine" that does all the work.
I can only think of Rdb that runs the work in the user processes.

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

Yes, of course. Some of that is done at compile-time in Rdb and
some is done by the optimizer at run-time.

> 
> Arne
>