参考书目

选择一些SQL 和PostgreSQL的参考和读物。

一些来自最初的POSTGRES 开发队伍的白皮书和 技术报告可以在加州大学伯克利分校计算机科学系 网站获取。

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查询优化器的设计和实现 , 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数据模型 ", Proc. VLDB Conference, Sept. 1987.

P. Seshadri and A. Swami, "Generalized Partial Indexes (cached version) ", 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的设计 ", 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存储系统设计 ", Proc. VLDB Conference, Sept. 1987.

M. Stonebraker, M. Hearst, and S. Potamianos, " POSTGRES规则系统注解 ", SIGMOD Record 18(3), Sept. 1989.

M. Stonebraker, " 部分索引实例 ", SIGMOD Record 18(4), Dec. 1989, 4-11.

M. Stonebraker, L. A. Rowe, and M. Hirohama, " POSTGRES的实现 ", Transactions on Knowledge and Data Engineering 2(1), IEEE, March 1990.

M. Stonebraker, A. Jhingran, J. Goh, and S. Potamianos, " 数据库系统中的规则，过程，缓存和视图 ", Proc. ACM-SIGMOD Conference on Management of Data, June 1990.