SQL (History)

History

In 1970 IBM has described a relational model for database and in 1974 Structure Query Language appeared. In 1978 IBM started working and changed the Codd ideas into reality and developed product called “System/R”. IBM developed first prototype of relational database and standardized by ANSI. The first relational database was released by Relational Software and its later became Oracle.

The initial version was SEQUEL (Structured English Query Language).

When we execute an SQL Command for any RDBMS, the systems determine the best way to carry the request and SQL engine figure out how to perform the task. There are many component involved in the process. These components are Query Dispatcher, Optimization Engine, Classic Query Engine and SQL Query Engine.

Following is a simple diagram of showing SQL Architecture

Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed my Microsoft. It is a software product whose primary functions is to store and retrieve data as requested by other applications. Its primary languages are T-SQL and ANSI SQL.

SQL Version History

That's all for Today, see you tomorrow with new learning. Please do send your queries and feedback.

Sanjay Bakshi
mesanjaybakshi@gmailcom

(Keep Calm & Keep Learning)