Re: Foreign key in Oracle Sql

From: Anne & Lynn Wheeler <lynn_at_garlic.com>
Date: Wed, 19 Jan 2005 16:15:41 -0700
Message-ID: <m37jm9nh7m.fsf_at_lhwlinux.garlic.com>


DA Morgan <damorgan_at_x.washington.edu> writes: > Not at all. But the code bases for DB2 did not in its various host > environments did not.

the mainframe db2 code base was direct evolution from system/r to sql/ds to db2. there might be a case made that ibm took so long shipping a rdbms product because of internal politics from its other dbms product groups. in the late 80s, there was an (new) open-system implementation done, originally for os2 and aix ... that was announced with the same name, db2.

this is from vmshare archive ... posting 2/27/83 discussing details of the sql/ds release 2 announcement:
http://vm.marist.edu/~vmshare/browse?fn=SQLDS&ft=MEMO

which was originally announced in 1981 ... although DB2 wasn't announced until 1983.

http://www.colderfusion.com/presentations/smartsql/tsld003.htm

from above history page:

History of SQL

  • pre-70 hierarchical and network databases
  • 1970 E.F. Codd defines relational model
  • 1974 IBM System/R project, inc. SEQUEL lang.
  • 1978 System/R customer tests
  • 1979 Oracle introduces commercial RDBMS
  • 1981 IBM introduces SQL/DS
  • 1983 IBM introduces DB2
  • 1986 ANSI SQL1 standard ratified
  • 1992 ANSI SQL2 standard ratified

.. snip ...

modulo first commercial RDBMS:

  • 1976 Multics Data Store
-- 
Anne & Lynn Wheeler | http://www.garlic.com/~lynn/
Received on Thu Jan 20 2005 - 00:15:41 CET

Original text of this message