Re: Proper relational database? - Mailing list pgsql-general

From
Subject Re: Proper relational database?
Date
Msg-id 005c01d19dd4$e5fcc2b0$b1f64810$@andl.org
Whole thread Raw
In response to Re: Proper relational database?  (Eric Schwarzenbach <subscriber@blackbrook.org>)
Responses Re: Proper relational database?
List pgsql-general
> owner@postgresql.org] On Behalf Of Eric Schwarzenbach

> >> If I had a few $million to spend in a philanthropical manner, I would
> >> hire some of the best PG devs to develop a proper relational database
> server.
> >> Probably a query language that expressed the relational algebra in a
> >> scheme-like syntax, and the storage model would be properly
> >> relational (eg no duplicate rows).

If there were someone to pay the bills, would you work on it?

> >> It's an enormous tragedy that all the development effort that has
> >> gone into NoSQL database has pretty much all gotten it wrong: by all
> >> means throw out SQL, but not the relational model with it. They're
> >> all just rehashing the debate over hierarchical storage from the 70s.
> >> Comp Sci courses should feature a history class.
> >>
> >> It's a bit odd to me that someone isn't working on such a thing.

Several people are, but without the few $million...

> > Well when IBM were first developing relational databases there were
> > two different teams.  One in California which produced System-R which
> > became what we now know as DB2 and spawned SQL, and the other in
> > Peterlee in the UK which was called PRTV (the Peterlee Relational Test
> > Vehicle).  PRTV rather died but bits of it survived.

And many of the people who worked on it are still around.

> > According to the Wikipedia page it did have a language (ISBL) but from
> > what I recall (and it was nearly 40 years ago) there were a series of
> > PL/1 function calls we used rather than encoding the request as a
> > string as SQL systems require.

Ditto. Including Hugh Darwen.

> One of the people involved in that was Hugh Darwen, who is one of the authors
> of The Third Manifesto, which is an attempt to define what a properly
> relational language and system should look like. So you could say the
> experience of ISBL vs SQL has been folded into that effort.

See http://www.thethirdmanifesto.com/.

Hugh worked for some years for IBM on the SQL Committee, but eventually left over a major disagreement in direction.
TTMis based on the work he's done since (with Chris Date). Andl derives from that. 

I would say that very little of PRTV/ISBL experience was added to SQL once it had been standardised, even with Hugh
doinghis best. 

Regards
David M Bennett FACS

Andl - A New Database Language - andl.org










pgsql-general by date:

Previous
From:
Date:
Subject: Re: Proper relational database?
Next
From: Andrew Sullivan
Date:
Subject: On the right tool (was Re: Proper relational database?)