Re: Foreign key in Oracle Sql
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 19 Jan 2005 23:22:33 -0800
Message-ID: <41ef5c2f$1_2_at_127.0.0.1>
>
>
> i was involved in the tech transfer of system/r to endicott for
> sql/ds. i wasn't involved in the transfer of the code back to stl for
> db2 (sjr/bldg28 where system/r was done is about 10 miles north of
> stl/bldg90 where db2 was done ... both in south silicon valley while
> endicott is on the opposite coast). several years ago, the primary
> catcher in endicott had his 30th corporate anniversary ... and i
> presented him with an email log from the period.
>
> however, in disucssions with one of the people in the following meeting
> http://www.garlic.com/~lynn/95.html#13
>
> who had been working at STL at the time, he claims to have almost
> single handed managed the transfer of the sql/ds code from endicott
> back to stl (for db2).
>
> however, there is lots of work done on that code after it reached stl
> ... both by people in stl and multiple people at sjr/bldg28 having
> worked on system/r (as well as code that was adapted from other
> projects).
>
> lots of past system/r references/posts
> http://www.garlic.com/~lynn/subtopic.html#systemr
>
> of course there is the sequal reunion web site:
> http://www.mcjones.org/System_R/
> http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95.html
>
> a couple specific items about DB2 from the above index:
> http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-SQL_DS.html#Index287
> http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-SQL_DS.html#Index290
> ttp://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-DB2.html#Index339
> some discussion of other code that went into DB2
> http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-Spreadin.html#Index271
>
> there were lots of stuff going on in that period, epstein had
> graduated from berkeley (out of the ingres project) and was CTO at BLI
> ... which had a lot of machines in the market. he left BLI to go first
> to teradata and then form sybase. when he left bli, there were some
> number of BLI people lurking(?) around bldg.28 to backfill epstain's
> position. One of the luckers(?) had been a disk engineer at the plant
> site in the 60s and had been snarfed up in the Shugart raids ... they
> may have even been having meetings at some of the same locations that
> Shugart had used (anyway i had some number of after work meetings
> about whether to leave or not to leave).
>
> minor epstein reference .... the two BLI name sakes had most recently
> come out of memorex:
> http://en.wikipedia.org/wiki/Ingres
> some discussion from the sql reunion site:
> http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-Teradata.html
> one of my shugart references:
> http://www.garlic.com/~lynn/2002.html#17 index searching
>
> there was from scratch open system rdbms done for os2 & aix (i believe
> code named shelby, circa 1989, primarily at the time focused on os2)
> that was also announced as db2. some of the shelby stuff was also tied
> up w/transarc (aka cmu camelot).
>
> now from the dlm work that we had done somewhat implied in this
> description
> http://www.garlic.com/~lynn/95.html#13
>
> there were a couple people working on (mainframe) db2 that commented
> that if we actually did that w/oracle ... it would put things five
> years ahead of where they were.
>
> and totally unrelated to most anything
> http://www.sleepycat.com/company/management.shtml
> and one of the people mentioned in the above reference
> also did consulting work on ha/cmp project
> http://www.garlic.com/~lynn/subtopic.html#hacmp
> and for even stranger reference:
> http://dune.mcs.kent.edu/~farrell/sa96/notes/sendmail/usenix.html
Date: Wed, 19 Jan 2005 23:22:33 -0800
Message-ID: <41ef5c2f$1_2_at_127.0.0.1>
Anne & Lynn Wheeler wrote:
> DA Morgan <damorgan_at_x.washington.edu> writes:
>
>>I would love to have access to your resources for class preparation >>work. And you may well be correct that system/r code is the basic >>kernel in DB2 ... but the fact that one came before the other is not >>a guarantee that DB2 was built on a system/r foundation or just on >>its design. In one sense, given where Larry used to work, one could >>say that Oracle too was built on system/r. Would you agree?
>
>
> i was involved in the tech transfer of system/r to endicott for
> sql/ds. i wasn't involved in the transfer of the code back to stl for
> db2 (sjr/bldg28 where system/r was done is about 10 miles north of
> stl/bldg90 where db2 was done ... both in south silicon valley while
> endicott is on the opposite coast). several years ago, the primary
> catcher in endicott had his 30th corporate anniversary ... and i
> presented him with an email log from the period.
>
> however, in disucssions with one of the people in the following meeting
> http://www.garlic.com/~lynn/95.html#13
>
> who had been working at STL at the time, he claims to have almost
> single handed managed the transfer of the sql/ds code from endicott
> back to stl (for db2).
>
> however, there is lots of work done on that code after it reached stl
> ... both by people in stl and multiple people at sjr/bldg28 having
> worked on system/r (as well as code that was adapted from other
> projects).
>
> lots of past system/r references/posts
> http://www.garlic.com/~lynn/subtopic.html#systemr
>
> of course there is the sequal reunion web site:
> http://www.mcjones.org/System_R/
> http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95.html
>
> a couple specific items about DB2 from the above index:
> http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-SQL_DS.html#Index287
> http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-SQL_DS.html#Index290
> ttp://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-DB2.html#Index339
> some discussion of other code that went into DB2
> http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-Spreadin.html#Index271
>
> there were lots of stuff going on in that period, epstein had
> graduated from berkeley (out of the ingres project) and was CTO at BLI
> ... which had a lot of machines in the market. he left BLI to go first
> to teradata and then form sybase. when he left bli, there were some
> number of BLI people lurking(?) around bldg.28 to backfill epstain's
> position. One of the luckers(?) had been a disk engineer at the plant
> site in the 60s and had been snarfed up in the Shugart raids ... they
> may have even been having meetings at some of the same locations that
> Shugart had used (anyway i had some number of after work meetings
> about whether to leave or not to leave).
>
> minor epstein reference .... the two BLI name sakes had most recently
> come out of memorex:
> http://en.wikipedia.org/wiki/Ingres
> some discussion from the sql reunion site:
> http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-Teradata.html
> one of my shugart references:
> http://www.garlic.com/~lynn/2002.html#17 index searching
>
> there was from scratch open system rdbms done for os2 & aix (i believe
> code named shelby, circa 1989, primarily at the time focused on os2)
> that was also announced as db2. some of the shelby stuff was also tied
> up w/transarc (aka cmu camelot).
>
> now from the dlm work that we had done somewhat implied in this
> description
> http://www.garlic.com/~lynn/95.html#13
>
> there were a couple people working on (mainframe) db2 that commented
> that if we actually did that w/oracle ... it would put things five
> years ahead of where they were.
>
> and totally unrelated to most anything
> http://www.sleepycat.com/company/management.shtml
> and one of the people mentioned in the above reference
> also did consulting work on ha/cmp project
> http://www.garlic.com/~lynn/subtopic.html#hacmp
> and for even stranger reference:
> http://dune.mcs.kent.edu/~farrell/sa96/notes/sendmail/usenix.html
Thanks.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond) ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =---Received on Thu Jan 20 2005 - 08:22:33 CET