理解History of Standard SQL

最新推荐文章于 2022-10-27 17:24:42 发布
最新推荐文章于 2022-10-27 17:24:42 发布
阅读量168 收藏
点赞数 1
分类专栏： # SQL || HDF || Mongo 文章标签： SQL MySQL
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/The_Time_Runner/article/details/115295320
版权

  • 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

  1. Oracle Help Center: History of SQL
  2. Brief History of SQL and SQL Standards
  3. SQL material
  4. What is SQL?
  5. The History of SQL – How It All Began
  6. The History of SQL Standards
  7. https://learnsql.com/
PerpetualLearner
关注
专栏目录
benchmarksql测试mysql_数据库压力测试工具 -- BenchmarkSQL 使用说明
weixin_34039159的博客
01-26 1811
关于数据库的压力测试，之前写过3篇Blog：数据库基准测试(Database Benchmarking) 说明数据库压力测试工具 -- Hammerdb 使用说明数据库压力测试工具 -- Swingbench 使用说明今天看下BenchmarkSQL 工具的使用。1BenchmarkSQL 说明BenchmarkSQL 可以从sourceforge上直接下载：对于BenchmarkSQL，官方的解...
【数据库理论】研究 ANSI/ISO SQL 标准、事务、数据异常与隔离级别
影三人
03-02 2543
详细剖析 SQL 标准、事务、数据异常与隔离级别。
history.sql
07-15
历史上的今天数据库 自带文字介绍 数据来源于权威网站。DROP TABLE IF EXISTS `history`; CREATE TABLE `history` ( `id` int(0) NOT NULL AUTO_INCREMENT, `year` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `month` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `day` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
mysql-sql-standard
aecuhty88306453的博客
10-29 160
https://github.com/zhishutech/mysql-sql-standard 转载于:https://www.cnblogs.com/DataArt/p/9873382.html
标准SQL
心有猛虎细嗅蔷薇
07-15 4558
SQL是Structured Query Language的缩写，它的前身是著名的关系数据库原型系统System R所采用的SEQUEL语言。作为一种访问关系型数据库的标准语言，SQL自问世以来得到了广泛的应用，不仅是著名的大型商用数据库产品Oracle、DB2、Sybase、SQL Server支持它，很多开源的数据库产品如PostgreSQL、MySQL也支持它，甚至一些小型的产...
SQL*Plus Command -- history
cowboy90的专栏
08-16 458
语法：HIST[ORY] [n RUN | EDIT | DEL[ETE]] | [CLEAR | LIST] 功能：使用history命令查看历史SQL命令，并可以再次执行、编辑、删除这些历史命令。 使用history命令的前提是已经set history开启了缓存历史SQL命令的功能。当SQL数量超过了最大保留值时，自动清除最旧的数据，并重新生成从1开始的连续的序号。 s...
记录一下sql
HIstoryq的博客
05-13 107
select lkg.groupName from lz_jshd_category lkc left join (select a.id, GROUP_CONCAT(b.group_name) as groupName from lz_jshd_category as a inner join lz_jshd_group as b on FIND_IN_SET(b.id, a.group_ids) grou..
XML.rar_history
09-24
XML的历史可以追溯到其前身SGML（Standard Generalized Markup Language），一个用于大文档结构化的标准。XML的设计目标是简化数据共享和交换，特别是在不同的操作系统和网络环境之间。 XML的历史发展经历了几个...
pg数据库执行sql文件_在postgresql中通过命令行执行sql文件
weixin_42140710的博客
01-11 3640
General\copyright show PostgreSQL usage and distribution terms\g [FILE] or ; execute query (and send results to file or |pipe)\h [NAME] help on syntax of SQL commands, * for all commands\q ...
Flink SQL:Queries(Joins)
weixin_48813624的博客
10-27 863
Flink SQL:Queries(Joins)
MySQL - 学习笔记 - 标准SQL函数 Standard SQL Functions
灵台方寸山斜月三星洞
02-04 804
MySQL - 学习笔记 - 标准SQL函数 Standard SQL Functions标准SQL函数速查表参考资料 标准SQL函数速查表 标准SQL函数速查表.PDF CSDN下载 参考资料 官方文档：MySQL 5.7 Reference Manual / Functions and Operators LearnSQL：标准SQL函数速查表 ......
A Brief History of NoSQL （转）
weixin_30387663的博客
12-29 68
NoSQL的简短介绍 http://blog.knuthaugen.no/2010/03/a-brief-history-of-nosql.html 转载于:https://www.cnblogs.com/hanhuilee/archive/2012/12/29/5221397.html
MySQL Differences from Standard SQL
weixin_34221112的博客
09-16 79
SELECT INTO TABLE DifferencesMySQL Server 不支持SELECT ... INTO TABLE ，但MySQL Server 支持 INSERT INTO ... SELECT 标准的SQL,For example:INSERT INTO tbl_temp2 (fld_id)SELECT tbl_temp1.fld_order_idFR...
SQL学习笔记
History became legend, legend became myth
08-28 799
数据操作语言DML和数据定义语言DDL 查询和更新指令构成了SQL的DML部分： SELECT - 从数据库表中获取数据 UPDATE - 更新数据库表中的数据 DELETE - 从数据库表中删除数据 INSERT INTO - 向数据库表中插入数据 SQL的DDL部分使我们有能力创建或删除表格。我们也可以定义索引，规定表之间的链接，以及施加表间的约束。 SQL中最重要的DDL语句
bigquery数据类型_bigquery解释了查询您的数据
weixin_26739079的博客
10-12 2585
bigquery数据类型Previously in BigQuery Explained, we reviewed BigQuery architecture, storage management, and ingesting data into BigQuery. In this post, we will cover querying datasets in BigQuery using S...
达梦查看执行历史SQL
weixin_45779546的博客
10-13 4597
达梦数据库查看执行的历史SQL，以及SQL执行时间
xmpp协议和socket_什么是XMPP（可扩展消息和状态协议）？
cunjiu9486的博客
10-05 582
xmpp协议和socketXMPP (Extensible Messaging and Presence Protocol ) is an open standard for messaging and presence. XMPP is the most popular open-source and open standard protocol for chat, video conferen...
MICROSOFT SQL SERVER 2012 STANDARD 标准版本下载
热门推荐
Txwtech笛克特科
03-17 1万+
http://183.222.102.66/cache/download.microsoft.com/download/A/5/5/A550A7AD-F8A3-48C7-B409-DFA671449081/SQLServer2012SP1-FullSlipstream-CHS-x64.iso?ich_args2=385-16220613047526_57063e8ffcba743715000cf6
History of BNCT
最新发布
03-30
Boron neutron capture therapy (BNCT) is a therapeutic technique that uses a combination of boron-containing compounds and neutron radiation to target cancer cells. The history of BNCT can be traced back to the 1930s, when researchers first discovered that boron could absorb neutrons and become radioactive. In the 1950s, researchers began to explore the potential of BNCT for cancer treatment. The first experiments involved injecting boron-containing compounds into animals with tumors and exposing them to neutron radiation. The results were promising, showing that the boron compounds could selectively accumulate in the tumor cells and that neutron irradiation could effectively kill the cancer cells. In the 1960s and 1970s, BNCT research continued to advance, with the development of more effective boron compounds and neutron sources. The first clinical trials of BNCT were conducted in the 1980s, primarily in Japan and the United States. These early trials showed that BNCT could be effective in treating certain types of cancer, including brain tumors and melanoma. Since then, BNCT has continued to be studied and refined. Today, BNCT is considered a promising treatment option for a variety of cancers, particularly those that are difficult to treat with traditional therapies. Ongoing research is focused on improving the effectiveness and safety of BNCT, as well as expanding its use to more types of cancer.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值