Relational Database Systems
In 1970, E. F. Codd of the IBM Research Laboratory published a paper on the relational data model. In this paper he described a new system (i.e. relational database model) for storing and working with large databases. He applied the concepts of relational algebra ( a branch of mathematics) to describe the new system. Instead of records being stored in some sort of linked list of free-form records as in CODASYL, his concept was to use a "table" of fixed-length records. Many experimental relational database management systems were implemented thereafter, with the first commercial products appearing in the late 1970s and early 1980s. IBM started working on a prototype system based on Codd's concepts e.g., System R in the early 1970s. This project led to two major developments:
In 1979, dBase-II was developed by Ashton-Tare and it was called as relational DBMS. It was very popular in PCs. It was not a truly relational DBMS product. In face, it was a programming language with generalized file-processing capabilities.
- The development of a structured query language called SQL, which has since become the standard language for relational systems.
- The production of various commercial relational DBMS products during the 1980s, for example DB2 from IBM and ORACLE from ORACLE Corporation.
In 1979, dBase-II was developed by Ashton-Tare and it was called as relational DBMS. It was very popular in PCs. It was not a truly relational DBMS product. In face, it was a programming language with generalized file-processing capabilities.
Leave a Comment