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.

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

See also

References

External links