Re: Designing database tables for performance?
Date: Fri, 23 Feb 2007 16:48:21 -0700
paul c <toledobythesea_at_oohay.ac> writes:
> I don't remember when I first heard or read the term "logical I/O".
> It might have been the in the early 1970's when IBM's VSAM access
> method first hit the streets. I'm pretty sure it was current in some
> circles then. Codd had written his first papers then but practically
> nobody in industry was even aware of them as IBM was pushing IMS and
> Vandl hard and people who knew him then told me later that there were
> big marketing forces at IBM that made working at the same company very
> difficult for him both personally and professionally. The term is a
> very unfortunate one since I'm sure misleads many newcomers to IT. As
> we can see here, it misleads many others.
> (Anybody who was programming then has an historical advantage over
> younger people because it is so much easier to see what a revolution
> Codd started.)
original relational/sql implementation was system/r done all on vm370 ... misc. collected posts mentioning system/r activity: http://www.garlic.com/~lynn/subtopic.html#systemr
recent thread mentioning various things from system/r days:
http://www.garlic.com/~lynn/2007d.html#4 Jim Gray Is Missing http://www.garlic.com/~lynn/2007d.html#6 Jim Gray Is Missing http://www.garlic.com/~lynn/2007d.html#8 Jim Gray Is Missing http://www.garlic.com/~lynn/2007d.html#17 Jim Gray Is Missing http://www.garlic.com/~lynn/2007d.html#33 Jim Gray Is Missing
vm370 was a follow-on to cp67 ... what had implemented both virtual memory and virtual machines in the mid-60s ... done at the cambridge science center. some of the people from CTSS had gone to the science center on the 4th flr of tech sq (worked on cp67, cms and other things) http://www.garlic.com/~lynn/subtopic.html#545tech
GML (precursor to sgml, html, xml, etc) was also invented at the science center in 1969.
others from CTSS went to the 5th flr and worked on multics. the
multics group managed to bring out the first commercial relational
database product (MRDS):
it was into the 80s before tech. transfer from SJR to Endicott succeded with SQL/DS product ... and even longer for tech. transfer of SQL/DS from Endicott back to STL for DB2.
when virtual memory for 370 was announced, for whatever reason, they chose the term "virtual storage" (instead of virtual memory) ... from that comes dos/vs, vs1, vs2, svs, mvs, vsam, etc (all the "VSs")
various past posts mentioning quote from the mid-60s about "A system of that period that had implemented virtual memory was the Ferranti Atlas computer, and that was known not to be working well"
http://www.garlic.com/~lynn/2000f.html#78 TSS ancient history, was X86 ultimate CISC? designs) http://www.garlic.com/~lynn/2001h.html#10 VM: checking some myths. http://www.garlic.com/~lynn/2001h.html#26 TECO Critique http://www.garlic.com/~lynn/2002.html#42 a.f.c history checkup... (was What specifications will the standard year 2001 PC have?) http://www.garlic.com/~lynn/2003b.html#1 Disk drives as commodities. Was Re: Yamhill http://www.garlic.com/~lynn/2003m.html#34 SR 15,15 was: IEFBR14 Problems http://www.garlic.com/~lynn/2005o.html#4 Robert Creasy, RIP http://www.garlic.com/~lynn/2006i.html#30 virtual memory
lots of collected posts mentioning virtual memory, demand paging, and replacement algorithms (virtual memory and/or various kinds of "caches") http://www.garlic.com/~lynn/subtopic.html#wsclock Received on Sat Feb 24 2007 - 00:48:21 CET