理解History of Standard SQL

最新推荐文章于 2025-07-16 10:02:29 发布

原创最新推荐文章于 2025-07-16 10:02:29 发布 · 279 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#SQL #MySQL

SQL || HDF || Mongo 专栏收录该内容

65 篇文章

订阅专栏

SQL，全称Structured Query Language，是用于管理和处理关系数据库管理系统（RDBMS）数据的特定编程语言。它起源于IBM的System R项目，并由Donald D. Chamberlin和Raymond F. Boyce开发。1970年代末，Oracle公司推出了基于SQL的RDBMS。到1986年，SQL成为ANSI和ISO的官方标准。MySQL是目前广泛使用的开源SQL数据库管理系统，由Oracle公司维护。

SQL

Structured Query Language is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
History

SQL was initially developed at IBM by Donald D. Chamberlin and Raymond F. Boyce after learning about the relational model from Edgar F. Codd in the early 1970s. This version, initially called SEQUEL (Structured English Query Language), was designed to manipulate and retrieve data stored in IBM’s original quasirelational database management system, System R, which a group at IBM San Jose Research Laboratory had developed during the 1970s.

In the late 1970s, Ralational Software, Inc. (now Oracle Corporation) saw the potential of the concepts described by Codd, Chamberlin, and Boyce, and developed their own SQL-based RDBMS.

By 1986, ANSI and ISO standard groups offically adopted the standard “Database Language SQL” language definition.

The first computer databases appeared in the late 1960s.

What Edgar Frank Codd is famous for is an article published in 1970 called: A Relational Model of Data For Large Shared Data Bank, this started the area of relational databases in computer science.
MySQL

Rather than trying to write an SQL for their own databases, many companies use a database management system that has SQL already built in to it.

Developed and distributed by Oracle, MySQL is one of the most popular SQL database management systems currently avaiable.
References