Re: Is SQL silly as an RDBMS<->app interface? - Mailing list pgsql-general

From Ron Johnson
Subject Re: Is SQL silly as an RDBMS<->app interface?
Date
Msg-id 1058162095.19794.127.camel@haggis
Whole thread Raw
In response to Re: Is SQL silly as an RDBMS<->app interface?  (nolan@celery.tssi.com)
Responses Re: Is SQL silly as an RDBMS<->app interface?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
On Sun, 2003-07-13 at 10:17, nolan@celery.tssi.com wrote:
> > I understand that SQL is the interface between apps and RDBMS's because
> > of history, not because it is correct design.  Could you point me to a
> > link or book or paper that deals with this paradox? Thanks!
>
> I'm not sure what you mean by 'correct design'.
>
> I think you should go back and read the works of Codd and Date on the
> development of relational databases.  One point that was made early on is
> that RDBMS theory doesn't guarantee efficiency, but it does guarantee

SQL is only one possible relational query language.  It didn't
become de facto standard until the mid- to late-80s.

It is an outgrowth of SEQEL (Structured English QuEry Language),
which was IBM's 1st try at a descriptive query language.  DEC
had RDML (Relational Data Manipulation Language) to access it's
RDBMS.  I'm sure that Burroughs, etc, had their own access methods,
too.

--
+-----------------------------------------------------------+
| Ron Johnson, Jr.     Home: ron.l.johnson@cox.net          |
| Jefferson, LA  USA   http://members.cox.net/ron.l.johnson |
|                                                           |
| 4 degrees from Vladimir Putin
+-----------------------------------------------------------+


pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: select null + 0 question
Next
From: Alvaro Herrera
Date:
Subject: Re: Is SQL silly as an RDBMS<->app interface?