Re: Foreign key in Oracle Sql
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 19 Jan 2005 17:08:05 -0800
Message-ID: <41ef046a$1_1_at_127.0.0.1>
>
>
> 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
Date: Wed, 19 Jan 2005 17:08:05 -0800
Message-ID: <41ef046a$1_1_at_127.0.0.1>
Anne & Lynn Wheeler wrote:
> 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
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Thu Jan 20 2005 - 02:08:05 CET