引用

References

SQL

国际标准化组织与国际电工委员会。(2016)。*信息技术 — 数据库语言 — SQL — 第2部分:基础(SQL/Foundation)*(ISO/IEC 9075-2,第五版)。

SQLite 文档。取自 https://www.sqlite.org/docs.html

PostgreSQL 12 文档。取自 https://www.postgresql.org/docs/12/index.html

MySQL 8.0 参考手册。取自 https://dev.mysql.com/doc/refman/8.0/en/

Oracle 数据库 SQL 语言参考 18c。(2020年4月)。取自 https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/

Transact-SQL 参考。(2020年4月29日)。取自 https://docs.microsoft.com/en-us/sql/t-sql/language-reference?view=sql-server-ver15

International Organization for Standardization and International Electrotechnical Commission. (2016). Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) (ISO/IEC 9075-2, Fifth Edition).

SQLite Documentation. Retrieved from https://www.sqlite.org/docs.html.

PostgreSQL 12 Documentation. Retrieved from https://www.postgresql.org/docs/12/index.html.

MySQL 8.0 Reference Manual. Retrieved from https://dev.mysql.com/doc/refman/8.0/en/.

Oracle Database SQL Language Reference 18c. (April, 2020). Retrieved from https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/.

Transact-SQL Reference. (April 29, 2020). Retrieved from https://docs.microsoft.com/en-us/sql/t-sql/language-reference?view=sql-server-ver15.

数据模型

Data modeling

Chen, Peter Pin-Shan. “实体-关系模型—朝着数据的统一视角。” ACM 数据库系统交易 (TODS) 1.1 (1976): 9-36。

Elmasri, Ramez, 和 Sham Navathe. 数据库系统基础. 第7版,Pearson, 2016。

Everest, Gordon C. “基本数据结构模型通过一个共同的例子进行解释。” 第五届德克萨斯计算系统会议论文集. 1976。

Chen, Peter Pin-Shan. “The entity-relationship model—toward a unified view of data.” ACM transactions on database systems (TODS) 1.1 (1976): 9-36.

Elmasri, Ramez, and Sham Navathe. Fundamentals of Database Systems. 7th edition, Pearson, 2016.

Everest, Gordon C. “Basic data structure models explained with a common example.” Proc. Fifth Texas Conference on Computing Systems. 1976.

关系数据库理论

Relational database theory

Childs, David L. “集合理论数据结构的可行性:基于重构关系定义的一般结构。” 国际计算机学会会议论文集. (1968)。

Codd, Edgar Frank. “大型共享数据银行的关系模型。” ACM 通信 26.1 (1983): 64-69。

Childs, David L. “Feasibility of a set-theoretic data structure: a general structure based on a reconstituted definition of relation.” Proc. IFIP Cong. (1968).

Codd, Edgar Frank. “A relational model of data for large shared data banks.” Communications of the ACM 26.1 (1983): 64-69.