HOME

TheInfoList




IBM System R is a
database In computing, a database is an organized collection of Data (computing), data stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal #Design and modeling, design and mode ...

database
system built as a research project at
IBM International Business Machines Corporation (IBM) is an American multinational technology company headquartered in Armonk, New York, with operations in over 170 countries. The company began in 1911, founded in Endicott, New York, as the C ...

IBM
's San Jose Research Laboratory beginning in 1974. System R was a
seminal Seminal, ultimately from Latin ''wikt:semen#Latin, semen'', "seed", may refer to: *Relating to seeds *Relating to semen *(Of a work, event, or person) Having much social influence on later developments {{Disambig ...
project: it was the first implementation of
SQL SQL ( ''S-Q-L'', "sequel"; Structured Query Language) is a domain-specific languageA domain-specific language (DSL) is a computer languageA computer language is a method of communication with a computer A computer is a machine that can b ...

SQL
, which has since become the standard relational data
query language In general, a query is a form of question A question is an utterance which typically functions as a request for information, which is expected to be provided in the form of an answer. Questions can thus be understood as a kind of illocutionary ...
. It was also the first system to demonstrate that a
relational database management system A relational database is a 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 relational database syste ...
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 failure, fail as a complete unit; it can never be only partiall ...
performance. Design decisions in System R, as well as some fundamental
algorithm In and , an algorithm () is a finite sequence of , computer-implementable instructions, typically to solve a class of problems or to perform a computation. Algorithms are always and are used as specifications for performing s, , , and other ...

algorithm
choices (such as the
dynamic programming Dynamic programming is both a mathematical optimization File:Nelder-Mead Simionescu.gif, Nelder-Mead minimum search of Test functions for optimization, Simionescu's function. Simplex vertices are ordered by their values, with 1 having the lo ...
algorithm used in
query optimization Query optimization is a feature of many relational database management systems and other databases such as graph databases. The query optimizer attempts to determine the most efficient way to execute a given query by considering the possible qu ...
), influenced many later relational systems. System R's first customer was
Pratt & Whitney Pratt & Whitney is an American aerospace manufacturer An aerospace manufacturer is a company or individual involved in the various aspects of Aircraft design process, designing, building, testing, selling, and maintaining aircraft, aircraft pa ...
in 1977..


See also

*
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 SQL ( ''S-Q-L'', "sequel"; Structured Query Language) is a domain-specific languageA domain-specific language (DSL) is a computer languageA computer language is a method of communication with a computer A computer is a machine that can b ...

SQL
*
System/38 The System/38 is a discontinued minicomputer and midrange computer manufactured and sold by the IBM Corporation. IBM announced the System/38 in 1978. The System/38 has 48-bit addressing, which was unique for the time, and a novel database#Integra ...


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