参考书目 · PostgreSQL 中文文档 9.3

# 参考书目选择一些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.