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 sp ...
system built as a research project at
IBM's
San Jose Research Laboratory beginning in 1974. System R was a
seminal
Seminal, ultimately from Latin ''semen'', "seed", may refer to:
*Relating to seeds
*Relating to semen
*(Of a work, event, or person) Having much social influence
Social influence comprises the ways in which individuals adjust their behavior to me ...
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
A relational database is a (most commonly digital) database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relatio ...
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 comple ...
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 Computational problem, problems or to perform a computation. Algorithms are used as specificat ...
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.
I ...
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
Pratt & Whitney is an American aerospace manufacturer with global service operations. It is a subsidiary of Raytheon Technologies. Pratt & Whitney's aircraft engines are widely used in both civil aviation (especially airlines) and military aviat ...
in 1977.
[.]
See also
*
IBM Db2
Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON a ...
*
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, cont ...
*
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