Re: The relational model and relational algebra - why did SQL become the industry standard?

"David Cressey" <info_at_dcressey.com> writes:
> My recollection was that is was to compete with IBM. DB2 used SQL,
> and it was easier to sell Rdb if the people who already knew SQL
> didn't have to learn something else. This is the way most "de
> facto" standards come into being.

there was significant resistance from STL to system/r. some of the arguments were hierarchical vis-a-vis relational .... but probably as vociferous was arguments regarding physical pointers vis-a-vis indexes (i.e. that the indexes doubled the physical space).

so the technical transfer went from sjr to endicott ... aka from system/r to sql/ds (i was responsible for some from sjr to end). it was later that there was technology transfer from endicott back to STL ... aka sql/ds to db2. one of the people in the following meeting handled much of the endicott->stl transfer: http://www.garlic.com/~lynn/95.html#13

general reference:
http://www.mcjones.org/System_R/
http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-Contents.html

multics first commercial rdbms:
http://www.mcjones.org/System_R/mrds.html

teradata, ingres, relational tech, britton-lee, sybase, m'soft http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-Teradata.html

sql/ds
http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-SQL_DS.html

shoot-out at the ok corral
http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-Shoot-ou.html

.... note: quibble in the shoot-out tail mentioned above with regard to compare-and-swap instruction and locking. compare-and-swap instruction was the work of person in cambridge science center who's initials are CAS ... and the choice of the instruction mnemonic ... so then needed to come up with inustruction name that matched his initials.

misc. qbe
http://www.garlic.com/~lynn/2002e.html#44 SQL wildcard origins? http://www.garlic.com/~lynn/2002o.html#70 Pismronunciation

vs/query (qmf)
http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-VS_QUERY.html

random past posts rf: system/r:

http://www.garlic.com/~lynn/aadsm13.htm#8 OCSP and LDAP
http://www.garlic.com/~lynn/2000.html#18 Computer of the century
http://www.garlic.com/~lynn/2000b.html#55 Multics dual-page-size scheme
http://www.garlic.com/~lynn/2000e.html#49 How did Oracle get started?
http://www.garlic.com/~lynn/2000f.html#16 [OT] FS - IBM Future System
http://www.garlic.com/~lynn/2001d.html#44 IBM was/is: Imitation...
http://www.garlic.com/~lynn/2001i.html#32 IBM OS Timeline?
http://www.garlic.com/~lynn/2002.html#10 index searching
http://www.garlic.com/~lynn/2002e.html#26 Crazy idea: has it been done?
http://www.garlic.com/~lynn/2002e.html#44 SQL wildcard origins?
http://www.garlic.com/~lynn/2002g.html#58 Amiga Rexx
http://www.garlic.com/~lynn/2002g.html#59 Amiga Rexx
http://www.garlic.com/~lynn/2002g.html#60 Amiga Rexx
http://www.garlic.com/~lynn/2002g.html#76 Pipelining in the past
http://www.garlic.com/~lynn/2002h.html#17 disk write caching (was: ibm icecube -- return of
http://www.garlic.com/~lynn/2002i.html#69 Hercules and System/390 - do we need it?
http://www.garlic.com/~lynn/2002k.html#9 Avoiding JCL Space Abends
http://www.garlic.com/~lynn/2002l.html#71 Faster seeks (was Re: Do any architectures use instruction
http://www.garlic.com/~lynn/2002n.html#36 VR vs. Portable Computing
http://www.garlic.com/~lynn/2002o.html#54 XML, AI, Cyc, psych, and literature
http://www.garlic.com/~lynn/2002q.html#32 Collating on the S/360-2540 card reader?

topic drift re compare and swap:

http://www.garlic.com/~lynn/93.html#14 S/360 addressing
http://www.garlic.com/~lynn/94.html#45 SMP, Spin Locks and Serialized Access
http://www.garlic.com/~lynn/97.html#19 Why Mainframes?
http://www.garlic.com/~lynn/98.html#8 ** Old Vintage Operating Systems **
http://www.garlic.com/~lynn/98.html#16 S/360 operating systems geneaology
http://www.garlic.com/~lynn/99.html#89 FIne-grained locking
http://www.garlic.com/~lynn/99.html#176 S/360 history
http://www.garlic.com/~lynn/99.html#203 Non-blocking synch
http://www.garlic.com/~lynn/2000e.html#25 Test and Set: Which architectures have indivisible instructions?
http://www.garlic.com/~lynn/2000g.html#16 360/370 instruction cycle time
http://www.garlic.com/~lynn/2001b.html#35 John Mashey's greatest hits
http://www.garlic.com/~lynn/2001f.html#41 Test and Set (TS) vs Compare and Swap (CS)
http://www.garlic.com/~lynn/2001g.html#9 Test and Set (TS) vs Compare and Swap (CS)
http://www.garlic.com/~lynn/2001k.html#8 Minimalist design (was Re: Parity - why even or odd)
http://www.garlic.com/~lynn/2001k.html#12 Minimalist design (was Re: Parity - why even or odd)
http://www.garlic.com/~lynn/2001k.html#66 SMP idea for the future
http://www.garlic.com/~lynn/2001k.html#69 Programming in School (was: Re: Common uses...)
http://www.garlic.com/~lynn/2002f.html#13 Hardware glitches, designed in and otherwise
http://www.garlic.com/~lynn/2002h.html#45 Future architecture [was Re: Future micro-architecture: ]
http://www.garlic.com/~lynn/2002h.html#46 Future architecture
http://www.garlic.com/~lynn/2002h.html#55 Future architecture [was Re: Future micro-architecture: ]
http://www.garlic.com/~lynn/2002h.html#87 Atomic operations redux
http://www.garlic.com/~lynn/2002i.html#82 HONE
http://www.garlic.com/~lynn/2002l.html#69 The problem with installable operating systems
http://www.garlic.com/~lynn/2002p.html#58 AMP  vs  SMP
http://www.garlic.com/~lynn/2003b.html#20 Card Columns

-- 
Anne & Lynn Wheeler | http://www.garlic.com/~lynn/ 
Internet trivia 20th anv http://www.garlic.com/~lynn/rfcietff.htm