History of SQL



What is the history of Structured English Query Language and what is its relationship to SQL?

In 1970 Dr. E. F. Codd published his paper,“A Relational Model of Data for Large Shared Data Banks”. This became the foundation for the relational database system. This paper described a new way to structure data within a database, and led to the relational database systems we use today.

While Dr. Codd’s paper defined the structure, his colleagues Donald D. Chamberlin and Raymond F. Boyce at IBM had been developing a query language known as SQUARE (Specifying Queries As Relational Expressions), which used set theory and predicate mathematics to select data from the database. This language had a terse mathematical syntax, but became the proving ground for concepts which are important to database manipulation.

By 1974, Chamberlin and Boyce published “SEQUEL: A Structured English Query Language” which detailed their refinements to SQUARE and introduced us to the data retrieval aspects of SEQUEL. This new SEQUEL language was as powerful as SQUARE, but Chamberlin and Boyce “kept in mind the notions of top down structured programming, the need for linear notation, and the need for readable programs that are easy to maintain and modify”. The resulting syntax could be described as block-structured English keyword syntax.

Using SQUARE to find all the names and salaries of employees who are in the toy department and whose manager is Anderson would be represented as:

NAME, SAL EMP DEPT, MGR ('TOY', 'ANDERSON')

The equivalent query in SEQUEL would be represented as:

SELECT NAME, SAL

FROM EMP

WHERE DEPT = 'TOY'

AND MGR = 'ANDERSON'

This type of syntax had many advantages, such as being easily learned by non-experts. Both SQUARE and SEQUEL had the advantage of being declarative languages. This allowed users to specify ‘what’ to do rather than ‘how’ to do it as in imperative, or procedural languages.

SEQUEL was later renamed to SQL by dropping the vowels, because SEQUEL was a trade mark registered by the Hawker Siddeley aircraft company. Thus SQL was born.

References

D D Chamberlin, R. F. Boyce, 1974, SEQUEL: A Structured English Query Language. Retrieved on May 16, 2007 from http://www.almaden.ibm.com/cs/people/chamberlin/sequel-1974.pdf.

Wikipedia Contributors, SQL. Retrieved on May 16 from http://en.wikipedia.org/wiki/SQL.

AddThis Social Bookmark Button

About these ads

Tags: ,

13 responses to “History of SQL”

  1. jroyce says :

    An interesting post. It’s good to know your roots.

  2. prahdhir says :

    Excellent work…
    Appreciated

  3. ccollins says :

    @prahdhir
    You’re welcome.

    -Chris

  4. nagraj says :

    appriciatable work.verry weldon.

  5. Bhuphender says :

    It is really good post… thanks a lot.

  6. nagaraju says :

    hi nice

  7. CuteHunter says :

    good work… :D

  8. satadru gandhi says :

    thank sir,,,awesome really

  9. Daniel says :

    Wow that was strange. I just wrote an really long comment but after I clicked submit my comment didn’t show up. Grrrr… well I’m not writing all that over
    again. Regardless, just wanted to say superb blog!

  10. Daniel says :

    My spouse and I stumbled over here by a different web address and thought
    I should check things out. I like what I see so i am just following you.

    Look forward to checking out your web page yet again.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 150 other followers

%d bloggers like this: