Difference between revisions of "SQL"

Revision as of 21:27, 25 April 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.

Null

See Null (SQL)

See also

• Codd's 12 rules
• Computer science
• Data
• Data (computing)
• Database
• Declarative programming
• Null (SQL)
• Programming language
• Query language
• Predicate logic
• Programming language
• Relational database
• Relational database management system
• Relational model
• SQL statement examples
• Three-valued logic

External links

• SQL @ Wikipedia