SQL

From Wiki @ Karl Jones dot com
Revision as of 09:35, 9 February 2016 by Karl Jones (Talk | contribs) (See also)

Jump to: navigation, search

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.

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