参考书目

一些有关SQLPostgreSQL的参考和读物。

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

SQL参考书

Judith Bowman、 Sandra Emerson 和 Marcy Darnovsky, The Practical SQL Handbook: Using SQL Variants, Fourth Edition, Addison-Wesley Professional, ISBN 0-201-70309-2, 2001.

C. J. Date 和 Hugh Darwen, A Guide to the SQL Standard: A user's guide to the standard database language SQL, Fourth Edition, Addison-Wesley, ISBN 0-201-96426-0, 1997.

C. J. Date, An Introduction to Database Systems, Eighth Edition, Addison-Wesley, ISBN 0-321-19784-4, 2003.

Ramez Elmasri 和 Shamkant Navathe, Fundamentals of Database Systems, Fourth Edition, Addison-Wesley, ISBN 0-321-12226-7, 2003.

Jim Melton 和 Alan R. Simon, Understanding the New SQL: A complete guide, Morgan Kaufmann, ISBN 1-55860-245-3, 1993.

Jeffrey D. Ullman, Principles of Database and Knowledge: 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历史和语法,并且描述了构建在PostgreSQL中的附加的INTERSECTEXCEPT。它是在O. Univ. Prof. Dr. Georg Gottlob和Univ. Ass. Mag. Katrin Seyr的支持下为维也纳技术大学的硕士学位准备的学位论文。

A. Yu 和 J. Chen, The POSTGRES Group, The Postgres95 User Manual, University of California, Sept. 5, 1995.

Zelaine Fong, The design and implementation of the POSTGRES query optimizer , University of California, Berkeley, Computer Science Department.

会议和期刊论文

Nels Olson, Partial indexing in POSTGRES: research project, University of California, UCB Engin T7.49.1993 O676, 1993.

L. Ong 和 J. Goh, "A Unified Framework for Version Modeling Using Production Rules in a Database System", ERL Technical Memorandum M90/33, University of California, April, 1990.

L. Rowe 和 M. Stonebraker, " The POSTGRES data model ", Proc. VLDB Conference, Sept. 1987.

P. Seshadri 和 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 和 L. Rowe, " The design of POSTGRES ", Proc. ACM-SIGMOD Conference on Management of Data, May 1986.

M. Stonebraker、 E. Hanson 和 C. H. Hong, "The design of the POSTGRES rules system", Proc. IEEE Conference on Data Engineering, Feb. 1987.

M. Stonebraker, " The design of the POSTGRES storage system ", Proc. VLDB Conference, Sept. 1987.

M. Stonebraker、 M. Hearst 和 S. Potamianos, " A commentary on the POSTGRES rules system ", SIGMOD Record 18(3), Sept. 1989.

M. Stonebraker, " The case for partial indexes ", SIGMOD Record 18(4), Dec. 1989, 4-11.

M. Stonebraker、 L. A. Rowe 和 M. Hirohama, " The implementation of POSTGRES ", Transactions on Knowledge and Data Engineering 2(1), IEEE, March 1990.

M. Stonebraker、 A. Jhingran、 J. Goh 和 S. Potamianos, " On Rules, Procedures, Caching and Views in Database Systems ", Proc. ACM-SIGMOD Conference on Management of Data, June 1990.