Skip site navigation (1) Skip section navigation (2)

Re: Dreaming About Redesigning SQL

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Dreaming About Redesigning SQL
Date: 2003-10-03 21:39:03
Message-ID: blkq9n$d9puv$4@ID-125932.news.uni-berlin.de (view raw or flat)
Thread:
Lists: pgsql-hackers
After takin a swig o' Arrakan spice grog, seunosewa(at)inaira(dot)com (Seun Osewa) belched out...:
> This is for relational database theory experts on one hand and
> imlementers of real-world alications on the other hand.  If there was
> a chance to start again and design SQL afresh, for best
> cleaness/power/performance what changes would you make?  What would
> _your_ query language (and the underlying database concept) look
> like?

There are two notable 'projects' out there:

 1.  There's Darwen and Date's "Tutorial D" language, defined as part
     of their "Third Manifesto" about relational databases.

 2.  newSQL <http://newsql.sourceforge.net/>, where they are studying
     two syntaxes, one based on Java, and one based on a
     simplification (to my mind, oversimplification) of SQL.

The "newSQL" project suffers from their definition being something of
a "chip away everything that doesn't look like an elephant"
definition.  They aren't defining, in "mathematical" terms, what their
language is supposed to be able to express; they are instead defining
a big grab-bag of minor syntactic features, and seem to expect that a
database system will emerge from that.

In contrast, "Tutorial D" is _all_ about mathematical definition of
what it is supposed to express, and the text is a tough read,
irrespective of other merits.
-- 
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','cbbrowne.com').
http://cbbrowne.com/info/thirdmanifesto.html
DOS: n.,  A small annoying  boot virus that causes  random spontaneous
system crashes, usually just  before saving a massive project.  Easily
cured  by Unix.   See also  MS-DOS,  IBM-DOS, DR-DOS.   
-- from  David Vicker's .plan

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-10-03 21:41:45
Subject: Re: Thoughts on maintaining 7.3
Previous:From: Bruce MomjianDate: 2003-10-03 21:37:52
Subject: Re: Thoughts on maintaining 7.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group