SQL # 2 - SQL History - OnlineTutorialHub

Search This Blog

Theme images by Storman. Powered by Blogger.

About Fast Edition

Popular Posts

Pages

Services

Blog Archive

Wednesday 1 November 2017

SQL # 2 - SQL History

History of SQL:-
  • 1970 -Dr. Edgar F. "Ted" Codd of IBM is known as the father of relational databases. He described a relational model for databases.
  • 1974 - Structured Query Language appeared.
  • 1978 - IBM worked to develop Codd's ideas and released a product named System/R.
  • 1986 - IBM developed the first prototype of relational database and standardized by ANSI. The first relational database was released by Relational Software which later came to be known as Oracle.
OnlineTutorialHub, OTH, SQL, SQL History
SQL Process-
When you are executing an SQL command for any RDBMS, the system determines the best way to carry out your request and SQL engine figures out how to interpret the task.
There are various components included in this process.
These components are -
  • Query Dispatcher
  • Optimization Engines
  • Classic Query Engine
  • SQL Query Engine, etc.
A classic query engine handles all the non-SQL queries, but a SQL query engine won't handle logical files.
A simple diagram of SQL Architecture –
OnlineTutorialHub, OTH, SQL, SQL Architecture


0 on: "SQL # 2 - SQL History"