Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
Tony Rogerson wrote:
>>Well - Oracle also supports CLR in the database as well. However the >>ability to extend a database with stored procedures etc written in CLR, >>Java or even a database's own data processing language does not equate to >>the ability to add new features to the database.
I am curious about the in-process aspect - is that akin to loading device drivers in ring 0? What are the memory protection aspects of the various offerings?
> In SQL Server you can write, User Definied - Types, Functions, Aggregates,
> Stored Procedures, Triggers within CLR, so its not just stored procedures;
> so, yes - you can add new features to the database; if I want to write a
> regurlar expression function that can be used anywhere within SQL Server I
> can write it in CLR and call it anywhere I can use a built-in system
> function.
IMO in the CLR option vendors are moving from providing a developer from having a shotgun to blow their left foot off to providing a 155mm howitzer! Of course we are all responsible adults here so there is no risk of it ever happening - yeah right!
Cheers, Frank. Received on Sat Feb 11 2006 - 17:53:49 CST