企业🤖AI智能体构建引擎,智能编排和调试,一键部署,支持私有化部署方案 广告
# 参考书目 选择一些SQL 和PostgreSQL的参考和读物。 一些来自最初的POSTGRES 开发队伍的白皮书和 技术报告可以在加州大学伯克利分校计算机科学系 [网站](http://db.cs.berkeley.edu/papers/)获取。 ## SQL参考书 Judith Bowman, Sandra Emerson, and Marcy Darnovsky, _实用SQL手册__:_ _Using SQL Variants_, Fourth Edition, Addison-Wesley Professional, ISBN 0-201-70309-2, 2001. C. J. Date and Hugh Darwen, _SQL标准指南__:_ _A user's guide to the standard database language SQL_, Fourth Edition, Addison-Wesley, ISBN 0-201-96426-0, 1997. C. J. Date, _数据库系统介绍_, Eighth Edition, Addison-Wesley, ISBN 0-321-19784-4, 2003. Ramez Elmasri and Shamkant Navathe, _数据库系统原理_, Fourth Edition, Addison-Wesley, ISBN 0-321-12226-7, 2003. Jim Melton and Alan R. Simon, _理解新的SQL__:_ _A complete guide_, Morgan Kaufmann, ISBN 1-55860-245-3, 1993. Jeffrey D. Ullman, _数据库知识原理__:_ _Base Systems_, Volume 1, Computer Science Press, 1988. ## PostgreSQL-具体文档 Stefan Simkovics, _Enhancement of the ANSI SQL Implementation of PostgreSQL_, Department of Information Systems, Vienna University of Technology, November 29, 1998. 讨论SQL历史和语法,并且描述了`INTERSECT`和`EXCEPT` 添加构建到PostgreSQL中。 为硕士论文做准备得到O. Univ. Prof. Dr. Georg Gottlob和维也纳理工大学 Univ. Ass. Mag. Katrin Seyr的支持。 A. Yu and J. Chen, The POSTGRES Group, _Postgres95用户手册_, University of California, Sept. 5, 1995. Zelaine Fong, _[POSTGRES查询优化器的设计和实现](http://db.cs.berkeley.edu/papers/UCB-MS-zfong.pdf) _, University of California, Berkeley, Computer Science Department. ## 程序和文章 Nels Olson, _POSTGRES中部分索引:研究计划_, University of California, UCB Engin T7.49.1993 O676, 1993. L. Ong and J. Goh, "数据库系统中为版本模型使用生产规则的统一框架", _ERL Technical Memorandum M90/33_, University of California, April, 1990. L. Rowe and M. Stonebraker, " [POSTGRES数据模型](http://db.cs.berkeley.edu/papers/ERL-M87-13.pdf) ", Proc. VLDB Conference, Sept. 1987. P. Seshadri and A. Swami, "Generalized Partial Indexes [(cached version)](http://citeseer.ist.psu.edu/seshadri95generalized.html) ", Proc. Eleventh International Conference on Data Engineering, 6-10 March 1995, IEEE Computer Society Press, Cat. No.95CH35724, 1995, 420-7. M. Stonebraker and L. Rowe, " [POSTGRES的设计](http://db.cs.berkeley.edu/papers/ERL-M85-95.pdf) ", Proc. ACM-SIGMOD Conference on Management of Data, May 1986. M. Stonebraker, E. Hanson, and C. H. Hong, "POSTGRES规则系统的设计", Proc. IEEE Conference on Data Engineering, Feb. 1987. M. Stonebraker, " [POSTGRES存储系统设计](http://db.cs.berkeley.edu/papers/ERL-M87-06.pdf) ", Proc. VLDB Conference, Sept. 1987. M. Stonebraker, M. Hearst, and S. Potamianos, " [POSTGRES规则系统注解](http://db.cs.berkeley.edu/papers/ERL-M89-82.pdf) ", _SIGMOD Record 18(3)_, Sept. 1989. M. Stonebraker, " [部分索引实例](http://db.cs.berkeley.edu/papers/ERL-M89-17.pdf) ", _SIGMOD Record 18(4)_, Dec. 1989, 4-11. M. Stonebraker, L. A. Rowe, and M. Hirohama, " [POSTGRES的实现](http://db.cs.berkeley.edu/papers/ERL-M90-34.pdf) ", _Transactions on Knowledge and Data Engineering 2(1)_, IEEE, March 1990. M. Stonebraker, A. Jhingran, J. Goh, and S. Potamianos, " [数据库系统中的规则,过程,缓存和视图](http://db.cs.berkeley.edu/papers/ERL-M90-36.pdf) ", Proc. ACM-SIGMOD Conference on Management of Data, June 1990.