IBM System R is a
database
In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases s ...
system built as a research project at
IBM's
San Jose Research Laboratory beginning in 1974. System R was a
seminal project: it was the first implementation of
SQL, which has since become the standard
relational data
query language
Query languages, data query languages or database query languages (DQL) are computer languages used to make queries in databases and information systems. A well known example is the Structured Query Language (SQL).
Types
Broadly, query language ...
. It was also the first system to demonstrate that a
relational database management system could provide good
transaction processing
Transaction processing is information processing in computer science that is divided into individual, indivisible operations called ''transactions''. Each transaction must succeed or fail as a complete unit; it can never be only partially compl ...
performance. Design decisions in System R, as well as some fundamental
algorithm
In mathematics and computer science, an algorithm () is a finite sequence of rigorous instructions, typically used to solve a class of specific problems or to perform a computation. Algorithms are used as specifications for performing ...
choices (such as the
dynamic programming
Dynamic programming is both a mathematical optimization method and a computer programming method. The method was developed by Richard Bellman in the 1950s and has found applications in numerous fields, from aerospace engineering to economics. ...
algorithm used in
query optimization
Query optimization is a feature of many relational database management systems and other databases such as NoSQL and graph databases. The query optimizer attempts to determine the most efficient way to execute a given query by considering the p ...
), influenced many later relational systems.
System R's first customer was
Pratt & Whitney in 1977.
[.]
See also
*
IBM Db2
*
IBM SQL/DS
*
Ingres (database)
Ingres Database ( ) is a proprietary SQL relational database management system intended to support large commercial and government applications.
Actian Corporation, which announced April 2018 that it is being acquired by HCL Technologies, con ...
*
SQL
*
System/38
The System/38 is a discontinued minicomputer and midrange computer manufactured and sold by
IBM. The system was announced in 1978. The System/38 has 48-bit addressing, which was unique for the time, and a novel integrated database system. It w ...
References
External links
* .
* .
* {{Citation , url = http://www.hpl.hp.com/techreports/Compaq-DEC/SRC-TN-1997-018.pdf , title = The 1995 SQL Reunion: People, Projects, and Politics , publisher = HP , format = PDF; technical report.
1974 software
System R
Proprietary database management systems
Relational database management systems