Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Myth of the database independent applications (Was: Are you using PL/SQL)

Re: Myth of the database independent applications (Was: Are you using PL/SQL)

From: Serge Rielau <>
Date: Thu, 24 May 2007 21:32:00 -0400
Message-ID: <>

William Robertson wrote:

> On May 24, 9:18 pm, Serge Rielau <> wrote:

>> The market drives standardization.
>> If vendors of do not agree on standards then the market abandons the
>> fractured interface. That is exactly what is happening.
>> One reason why apps are written in Java and abuse DBMS as mere file
>> systems is that vendors have not been able to keep SQL standardized.
>> This is not the first time this happens and it won't be the last.
>> The very fact that deep exploitation of the DBMS is preached as a
>> "requirement" drives the app vendors away.
>> Why would an app vendor want to be held hostage by any specific database
>> vendor just to get a performance improvement that Moore's law will fix
>> for them in short time anyway?
>> Why would customers put themselves into a position where the vendor can
>> dictate the support price upon next renewal because the customers cannot
>> threaten to change the supplier and the vendor knows that all to well.
>> The premise of SQL was and is that it's the DBMS' job to optimize. It is
>> not the app developers job to write e.g. EXIST instead of IN to achieve
>> performance.
>> If vendors cannot agree on a procedural language then the customers
>> cannot be blamed for refusing or at least minimizing its usage.
> So if Oracle and SQL Server are not the same we should complain about
> standards compatibility, while if Java and .Net are not the same that
> is OK?

ODBC is a standard. And so is Java.
Anyone can write a JVM, Anyone can write an ODBC driver. May the better implementation win.
True for VHS and BetaMax. There is room for more than one standard. They do not need to be the same.
There is long term no room in the global market for closed API's. You can run your shaver on 120V/60Hz or 240V/50Hz. Both are well defined.

I couldn't care less whether the ANSI SQL, DB2 SQL, MS SQL or Oracle SQL or whatever "wins" in the end. Today however only ANSI SQL is well defined. ("Well" not to be confused with pretty or good)


Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Received on Thu May 24 2007 - 20:32:00 CDT

Original text of this message