Re: Foreign key in Oracle Sql
Date: Wed, 19 Jan 2005 19:50:54 -0700
Message-ID: <m3pt00n78x.fsf_at_lhwlinux.garlic.com>
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
of course there is the sequal reunion web site:
http://www.mcjones.org/System_R/
a couple specific items about DB2 from the above index:
http://www.garlic.com/~lynn/subtopic.html#systemr
http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95.html
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
-- Anne & Lynn Wheeler | http://www.garlic.com/~lynn/Received on Thu Jan 20 2005 - 03:50:54 CET