Software:IBM System R

From HandWiki
Revision as of 17:15, 7 March 2023 by NBrushPhys (talk | contribs) (simplify)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Short description: Relational database management system, first implementation of SQL

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". IBM. http://www.cs.berkeley.edu/~brewer/cs262/SystemR.pdf. ""Phase Zero" of the project, which occurred during 1974 and-most of 1975, involved the development of the SQL user interface" 
  2. "Access Path Selection in a Relational Database Management System", Proceedings of the 1979 ACM SIGMOD International Conference on Management of Data, 1979, pp. 23–34, doi:10.1145/582095.582099, ISBN 978-0897910019 
  3. McJones, P (1995), "SQL reunion", System R, http://www.mcjones.org/System_R/SQL_Reunion_95/sqlr95-System.html .

External links