SQL History - Edgar Frank Ted Codd and His Relational Model Theory

As you all know, SQL is a database language and it also has its own history. Many people plays an important role in the development of SQL. It took several years to come in public to use.

The development of the SQL language was started from 1970.

A computer scientist Dr Edgar Frank Ted Codd who was working with IBM invented the relational model for database management. It was a theoretical explanation of the relational database and the relational database management system. In his explanation, he proposed that all the data in the database be represented in the form of relation.

In his career, he made many valuable contributions to computer science but the theory of the relational model was very influential that remains his celebrated achievement.

Later in the time, the SQL language was first time developed by IBM researchers Raymond Boyce and Donald Chamberlin based upon the theory of the relational model which was explained by Ted Codd.

That time this language was called as SEQUEL(Structured English Language) and it was designed to manipulate and retrieve data stored in IBM's original quasi-relational database management system also known as System/R.

At the end of 1970s, a company called Relational Software Inc., which is now famous as Oracle Corporation, realized the ability of the concept of relational model and the ideas of SEQUEL presented by Ted Codd, Boyce and Chamberlin.

As a result, the company began working on the development of its own RDBMS, which was based on SQL.

The aim of the company was to sell this system to the Central Intelligence Agency, U.S. Navy, and other prominent agencies of the U.S. government.

The first implementation of the project, which was available commercially, was released by Relational Software Inc. in 1979. It was named Oracle Version 2 (V2) and it operates on VAX computers.

Later in the year of 1986, the SQL became a standard of the American National Standards Institute (ANSI). And in 1987, SQL became a standard of the International Organization for Standardization (ISO).

Later in some years, new versions of the standard published in 1989, 1992, 1996, 1999, 2003, 2006, 2008, 2011, 2016 and most recently 2019.

Previous Post Next Post

Contact Form