Jump to content

IBM System R

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Citation bot (talk | contribs) at 22:49, 5 June 2020 (Removed parameters. | You can use this bot yourself. Report bugs here. | Activated by SemperIocundus | via #UCB_webform). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

IBM System R is a database system built as a research project at IBM's San Jose Research Laboratory beginning in 1974.[1] System R was a seminal project: it was the first implementation of SQL, which has since become the standard relational data query language. It was also the first system to demonstrate that a relational database management system could provide good transaction processing performance. Design decisions in System R, as well as some fundamental algorithm choices (such as the dynamic programming algorithm used in query optimization[2]), influenced many later relational systems.

System R's first customer was Pratt & Whitney in 1977.[3]

See also

References

  1. ^ "A History and Evaluation of System R" (PDF). IBM. "Phase Zero" of the project, which occurred during 1974 and-most of 1975, involved the development of the SQL user interface
  2. ^ Selinger, PG; Astrahan, MM; Chamberlin, Donald D; Lorie, RA; Price, TG (1979), "Access Path Selection in a Relational Database Management System", Proceedings of the 1979 ACM SIGMOD International Conference on Management of Data, pp. 23–34, doi:10.1145/582095.582099, ISBN 978-0897910019
  3. ^ McJones, P (1995), "SQL reunion", System R.
  • This article is based on material taken from the Free On-line Dictionary of Computing prior to 1 November 2008 and incorporated under the "relicensing" terms of the GFDL, version 1.3 or later.