Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!uunet!mcsun!cernvax!chx400!ethz!neptune!mint!marti
From: marti@mint.inf.ethz.ch (Robert Marti)
Newsgroups: comp.sys.mac.apps
Subject: Re: Relational Databases
Message-ID: <8293@neptune.inf.ethz.ch>
Date: 18 Sep 90 15:47:25 GMT
References: <9009181240.AA00676@lilac.berkeley.edu>
Sender: news@neptune.inf.ethz.ch
Reply-To: marti@mint.inf.ethz.ch (Robert Marti)
Organization: Departement Informatik, ETH, Zurich
Lines: 27

In article <9009181240.AA00676@lilac.berkeley.edu> A6014RVD@HASARA11.BITNET
(Raymond) writes:
>I am interested in buying a relational database for my Mac IIci [...].
>It has to have SQL as query language (stated as in the ISO/ANSI standards,
>f.e SQL/DS and DB2).

That's a pretty tall order.  As far as I know, neither the SQL offered
by SQL/DS nor the one offerd by DB2 comply to any ISO/ANSI SQL standard.
Note the word *any*:  There are at least the '86 and '89 ANSI SQL
standards.  On top of that, there is also an X/OPEN SQL standard,
and IBM's SAA SQL standard.  Finally, there is a proposed SQL2 standard.
I think I can safely claim that no pair of the above mentioned SQL
versions are identical.  (As they say: The good thing about standards
is that there are so many of them ... ;-)


>Which [other] databases are commercially available with the requirements
>as mentioned above?

Strictly speaking, none (see above).
For practical purposes, the only Mac DB supporting SQL on the Mac (under
MacOS aka System/Finder) is -- to the best of my knowledge -- Oracle.

Robert Marti                        Phone:    +41 1 254 72 60
Institut fur Informationssysteme
ETH-Zentrum                         Internet: marti@inf.ethz.ch
CH-8092 Zurich, Switzerland         UUCP:     ...uunet!mcvax!ethz!marti