Difference between revisions of "SQL"

From Wiki @ Karl Jones dot com
Jump to: navigation, search
(→‎See also)
(→‎Description)
Line 5: Line 5:
 
Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language.
 
Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language.
  
−
The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control.  
+
The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control.
 +
 
 +
== Declarative programming language ==
 +
 
 +
SQL is a [[Declarative programming|Declarative programming language]].
  
 
== Relational model ==
 
== Relational model ==

Revision as of 08:37, 9 February 2016

SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

Description

Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language.

The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control.

Declarative programming language

SQL is a Declarative programming language.

Relational model

SQL was one of the first commercial languages for Edgar F. Codd's relational model, as described in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks."

Despite not entirely adhering to the relational model as described by Codd, SQL became the most widely used database language.

See also

External links

  • SQL @ Wikipedia
Retrieved from "http://wiki.karljones.com/index.php?title=SQL&oldid=7997"