HOME

TheInfoList



OR:

IBM System R is a
database In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and a ...
system built as a research project at
IBM International Business Machines Corporation (using the trademark IBM), nicknamed Big Blue, is an American Multinational corporation, multinational technology company headquartered in Armonk, New York, and present in over 175 countries. It is ...
's San Jose Research Laboratory beginning in 1974, led by Edgar Codd, to implement his ideas on
relational database A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured for ...
s. System R was a seminal project as the first implementation of
SQL Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...
, which has since become the standard relational data
query language A query language, also known as data query language or database query language (DQL), is a computer language used to make queries in databases and information systems. In database systems, query languages rely on strict theory to retrieve informa ...
. It was also the first system to demonstrate that a relational database could provide good
transaction processing In computer science, transaction processing is information processing 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 c ...
performance. Design decisions in System R, as well as some fundamental
algorithm In mathematics and computer science, an algorithm () is a finite sequence of Rigour#Mathematics, mathematically rigorous instructions, typically used to solve a class of specific Computational problem, problems or to perform a computation. Algo ...
choices (such as the dynamic programming 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 po ...
), 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 RTX Corporation (formerly Raytheon Technologies). Pratt & Whitney's aircraft engines are widely used in both civil aviation (especially ...
in 1977.. Not running on
Unix Unix (, ; trademarked as UNIX) is a family of multitasking, multi-user computer operating systems that derive from the original AT&T Unix, whose development started in 1969 at the Bell Labs research center by Ken Thompson, Dennis Ritchie, a ...
hurt its popularity.


See also

* IBM Db2 *
IBM SQL/DS SQL/DS (Structured Query Language/Data System), released in 1981, was IBM's first commercial relational-database management system. It implemented the SQL database-query language. SQL/DS ran on the DOS/VSE and VM/CMS operating systems. A little ...
*
Ingres (database) Ingres Database ( ) is a proprietary SQL relational database management system intended to support large commercial and government applications. Actian Corporation controls the development of Ingres and makes certified binaries available fo ...
*
SQL Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...
*
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 computing, 48-bit addressing, which was unique for the time, and a novel database#Integrat ...


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