As we had seen in the previous article, DBMS acts as the interface between the users or the application programs and the database. The users or the application programs would talk to the DBMS using a language called "Structured Query Language". It is commonly referred to as "SQL".
The history of SQL dates back to the 1970s when Dr. E.F. Codd published the paper entitled "A Relational Model of Data for Large Shared Data Banks" in June 1970 in the Association of Computer Machinery (ACM) journal "Communications of the ACM". Codd's model is now accepted as the definitive model for Relational DataBase Management Systems (RDBMS). The language "Structured English Query Language" was developed by IBM Corporation Inc., to use Codd's model. SEQUEL later became SQL. In 1979, Relational Software Inc. (now Oracle) introduced the first commercially available implementation of SQL.
Today, many flavors of SQLs are available in market. Almost each DBMS vendor in the market has got their own flavor of SQL. For example, Oracle has got PL/SQL for it's Oracle RDBMS, Microsoft and Sybase have got T-SQL for their SQL Servers, IBM has got SQL PL for it's DB2 RDBMS and so on. There is a standard of SQL accepted by the ANSI. This standard has gone through many revisions. The first version of ANSI standard (shortly called ANSI SQL) came out in 1986 and it was called "SQL-86" or "SQL-87". After that, many versions have come out namely SQL-89, SQL-92, SQL:1999, SQL:2003, SQL:2006, SQL:2008, SQL:2011.
In our articles, we are going to discuss about the T-SQL for Microsoft SQL Server. More on it in the forthcoming articles.
I hope that this article was informative. Please post your comment if you see something wrong, need correction or to appreciate :)
The history of SQL dates back to the 1970s when Dr. E.F. Codd published the paper entitled "A Relational Model of Data for Large Shared Data Banks" in June 1970 in the Association of Computer Machinery (ACM) journal "Communications of the ACM". Codd's model is now accepted as the definitive model for Relational DataBase Management Systems (RDBMS). The language "Structured English Query Language" was developed by IBM Corporation Inc., to use Codd's model. SEQUEL later became SQL. In 1979, Relational Software Inc. (now Oracle) introduced the first commercially available implementation of SQL.
Today, many flavors of SQLs are available in market. Almost each DBMS vendor in the market has got their own flavor of SQL. For example, Oracle has got PL/SQL for it's Oracle RDBMS, Microsoft and Sybase have got T-SQL for their SQL Servers, IBM has got SQL PL for it's DB2 RDBMS and so on. There is a standard of SQL accepted by the ANSI. This standard has gone through many revisions. The first version of ANSI standard (shortly called ANSI SQL) came out in 1986 and it was called "SQL-86" or "SQL-87". After that, many versions have come out namely SQL-89, SQL-92, SQL:1999, SQL:2003, SQL:2006, SQL:2008, SQL:2011.
In our articles, we are going to discuss about the T-SQL for Microsoft SQL Server. More on it in the forthcoming articles.
I hope that this article was informative. Please post your comment if you see something wrong, need correction or to appreciate :)
No comments:
Post a Comment